pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConfiguration for my server
4+ messages / 3 participants
[nested] [flat]
* Configuration for my server
@ 2005-02-24 13:54 Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-02-24 14:39 ` Re: Configuration for my server Rick Apichairuk <rapichai@gmail.com>
2005-02-24 15:38 ` Re: Configuration for my server Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 2 replies; 4+ messages in thread
From: Marcin Giedz @ 2005-02-24 13:54 UTC (permalink / raw)
To: pgsql-admin
Hello...
Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs
146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to
find best configuration. Nowadys we have about 300 clients connected to mysql
server (we plan to switch to postgresql) but in the future there will be even
1 thousand clients. Can anyone please help me what should I change in
postgresql.conf to achieve very good performance ;)
Thx
Marcin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Configuration for my server
2005-02-24 13:54 Configuration for my server Marcin Giedz <marcin.giedz@eulerhermes.pl>
@ 2005-02-24 14:39 ` Rick Apichairuk <rapichai@gmail.com>
2005-02-24 14:55 ` Re: Configuration for my server Marcin Giedz <marcin.giedz@eulerhermes.pl>
1 sibling, 1 reply; 4+ messages in thread
From: Rick Apichairuk @ 2005-02-24 14:39 UTC (permalink / raw)
To: Marcin Giedz <marcin.giedz@eulerhermes.pl>; +Cc: pgsql-admin
I think you should also state what operating system you are using.
On Thu, 24 Feb 2005 14:54:46 +0100, Marcin Giedz
<marcin.giedz@eulerhermes.pl> wrote:
> Hello...
>
> Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
> basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs
> 146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to
> find best configuration. Nowadys we have about 300 clients connected to mysql
> server (we plan to switch to postgresql) but in the future there will be even
> 1 thousand clients. Can anyone please help me what should I change in
> postgresql.conf to achieve very good performance ;)
>
> Thx
> Marcin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Configuration for my server
2005-02-24 13:54 Configuration for my server Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-02-24 14:39 ` Re: Configuration for my server Rick Apichairuk <rapichai@gmail.com>
@ 2005-02-24 14:55 ` Marcin Giedz <marcin.giedz@eulerhermes.pl>
0 siblings, 0 replies; 4+ messages in thread
From: Marcin Giedz @ 2005-02-24 14:55 UTC (permalink / raw)
To: pgsql-admin
Dnia czwartek, 24 lutego 2005 15:39, Rick Apichairuk napisaĆ:
> I think you should also state what operating system you are using.
Ohhh Debian Sarge of course ;)
>
>
> On Thu, 24 Feb 2005 14:54:46 +0100, Marcin Giedz
>
> <marcin.giedz@eulerhermes.pl> wrote:
> > Hello...
> >
> > Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB
> > RAM basicly it one of Intel Server SR2400 configuration ;) with two
> > Seagate discs 146GB 15k connected with RAID1. I have installed PSQL ver.
> > 8.0 and try to find best configuration. Nowadys we have about 300 clients
> > connected to mysql server (we plan to switch to postgresql) but in the
> > future there will be even 1 thousand clients. Can anyone please help me
> > what should I change in postgresql.conf to achieve very good performance
> > ;)
> >
> > Thx
> > Marcin
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Configuration for my server
2005-02-24 13:54 Configuration for my server Marcin Giedz <marcin.giedz@eulerhermes.pl>
@ 2005-02-24 15:38 ` Scott Marlowe <smarlowe@g2switchworks.com>
1 sibling, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2005-02-24 15:38 UTC (permalink / raw)
To: Marcin Giedz <marcin.giedz@eulerhermes.pl>; +Cc: pgsql-admin
On Thu, 2005-02-24 at 07:54, Marcin Giedz wrote:
> Hello...
>
> Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
> basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs
> 146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to
> find best configuration. Nowadys we have about 300 clients connected to mysql
> server (we plan to switch to postgresql) but in the future there will be even
> 1 thousand clients. Can anyone please help me what should I change in
> postgresql.conf to achieve very good performance ;)
Firstly, read this document:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
It's generally considered one of the better tuning guides for
PotsgreSQL.
Secondly, if your database is going to handle a fair bit of writing then
make sure your RAID controller has battery backed cache on it. With 300
to 1000 users, and 5% or so writing, this isn't an option, it's a
requirement. :)
On a fast machine with lots of memory, it often pays to drop
random_page_cost to 1.2 to 1.4 or so.
Mount your file system noatime
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-24 15:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-24 13:54 Configuration for my server Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-02-24 14:39 ` Rick Apichairuk <rapichai@gmail.com>
2005-02-24 14:55 ` Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-02-24 15:38 ` Scott Marlowe <smarlowe@g2switchworks.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