Re: [GENERAL] postgres.conf settings

2010-08-30 Thread Dario Beraldi
Thanks Martijn and to the others who replied. Here's some more detail... Quoting Martijn van Oosterhout : Not a bad start, but to be sure you really need to provide a bit more info, like: - How many simultaneous clients you're expecting? - Lots of updates, or is it read only? - Lots of simple

Re: [GENERAL] postgres.conf settings

2010-08-29 Thread Scott Marlowe
And don't forge the wiki! http://wiki.postgresql.org/wiki/Performance_Optimization On Sun, Aug 29, 2010 at 12:14 PM, Sandeep Srinivasa wrote: > Do check a previous thread: > http://www.mail-archive.com/pgsql-general@postgresql.org/msg149691.html > > On Sun, Aug 29, 2010 at 10:32 PM, Dario Beral

Re: [GENERAL] postgres.conf settings

2010-08-29 Thread Sandeep Srinivasa
Do check a previous thread: http://www.mail-archive.com/pgsql-general@postgresql.org/msg149691.html On Sun, Aug 29, 2010 at 10:32 PM, Dario Beraldi wrote: > Hello, > > I'm trying to tune the parameters in postgres.conf to improve the > performance of my database (where performance = 'make queries

Re: [GENERAL] postgres.conf settings

2010-08-29 Thread Martijn van Oosterhout
On Sun, Aug 29, 2010 at 06:02:14PM +0100, Dario Beraldi wrote: > Hello, > > I'm trying to tune the parameters in postgres.conf to improve the > performance of my database (where performance = 'make queries run > faster'). I would be very grateful if you could give me some comments > about my

[GENERAL] postgres.conf settings

2010-08-29 Thread Dario Beraldi
Hello, I'm trying to tune the parameters in postgres.conf to improve the performance of my database (where performance = 'make queries run faster'). I would be very grateful if you could give me some comments about my choice of configuration settings below (did I do anything very silly? A