pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedlinux - server configuration for small database
3+ messages / 3 participants
[nested] [flat]
* linux - server configuration for small database
@ 2007-03-23 12:48 Paolo Negri <hungrylist@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Paolo Negri @ 2007-03-23 12:48 UTC (permalink / raw)
To: pgsql-performance
Hi
I'm going to install a new server and I'm looking for some advice
about how I can help my database performing at its best. I'll be using
a redhat ES 4 on a dual core opteron with 2 SCSI 10.000rpm disks in
RAID1.
The first question I have is, since I'd strongly prefer to use
postgresql 8.1 or 8.2 instead of the 7.4 that comes with redhat, if
someone else is using with success third party rpms with success in
business critical applications.
Database size: under 1 G
Load: reaches 100 r/w queries per second peak time but the average is lower
Filesystem: I'll probably have ext3 because of the redhat support.
RAM: I will have enough to let postgresql use a quantity about the
size of the db itself.
I'll have just one pair of disks so Linux will live on the same disk
array of the database, but obviously I can make any choice I like
about the partitioning and my idea was to put postgresql data on a
dedicated partition. As processes I'll have some other webby things
running on the server but the I/O impact at disk level of these should
be not that bad.
Now aside of the filesystem/partitioning choice, I have experience
with LVM, but I've never tried to take snapshots of postgresql
databases and I'd be interested in knowing how well this works/perform
and if there's any downside. I'd like even to read which procedures
are common to restore a db from the LVM snapshot.
As an alternative i was thinking about using the wal incremental
backup strategy.
In any case I'll take a pg_dump daily.
I would appreciate even just interesting web links (I've already
googled a bit so I'm quite aware of the most common stuff)
Thanks
Paolo
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: linux - server configuration for small database
@ 2007-03-23 15:05 Tom Lane <tgl@sss.pgh.pa.us>
parent: Paolo Negri <hungrylist@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2007-03-23 15:05 UTC (permalink / raw)
To: Paolo Negri <hungrylist@gmail.com>; +Cc: pgsql-performance
"Paolo Negri" <hungrylist@gmail.com> writes:
> The first question I have is, since I'd strongly prefer to use
> postgresql 8.1 or 8.2 instead of the 7.4 that comes with redhat, if
> someone else is using with success third party rpms with success in
> business critical applications.
Red Hat does support postgres 8.1 on RHEL4:
http://www.redhat.com/appstack/
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: linux - server configuration for small database
@ 2007-03-23 15:51 Joshua D. Drake <jd@commandprompt.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Joshua D. Drake @ 2007-03-23 15:51 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Paolo Negri <hungrylist@gmail.com>; pgsql-performance
Tom Lane wrote:
> "Paolo Negri" <hungrylist@gmail.com> writes:
>> The first question I have is, since I'd strongly prefer to use
>> postgresql 8.1 or 8.2 instead of the 7.4 that comes with redhat, if
>> someone else is using with success third party rpms with success in
>> business critical applications.
>
> Red Hat does support postgres 8.1 on RHEL4:
> http://www.redhat.com/appstack/
And so does the community:
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/binary/v8.1.8/linux/rpms/redhat/
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/binary/v8.2.3/linux/rpms/redhat/
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-03-23 15:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-23 12:48 linux - server configuration for small database Paolo Negri <hungrylist@gmail.com>
2007-03-23 15:05 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-03-23 15:51 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox