pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Configuration for my server
4+ messages / 3 participants
[nested] [flat]

* Configuration for my server
@ 2005-02-24 13:54  Marcin Giedz <marcin.giedz@eulerhermes.pl>
  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 14:39  Rick Apichairuk <rapichai@gmail.com>
  parent: 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 14:55  Marcin Giedz <marcin.giedz@eulerhermes.pl>
  parent: Rick Apichairuk <rapichai@gmail.com>
  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 15:38  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Marcin Giedz <marcin.giedz@eulerhermes.pl>
  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