Hello People, I upgraded to a 64 bits System. Now, everything is OK. Thnk you guys.
On Sat, Jul 11, 2009 at 2:19 AM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Fri, Jul 10, 2009 at 10:27 PM, <sriram.dandap...@bt.com> wrote: > > > > 2G per process is plenty ...and useful if you have large data warehouse > style queries which are long running (especially multiple of those) > > For you, yes. But not necessarily for others. > > > We do benefit from the Linux memory caching model regardless of what > Postgres uses right ? > > Definitely. > > > On a machine which we upgraded from 4G to 16G on a 32 bit PAE kernel...we > saw a doubling of performance for most queries of a certain type.(mostly > data warehouse type accessing several hundreds of thousands of records). > > > > Postgres version that we use is 8.1.9. > > I bet you'd see another big performance improvement with a 64bit OS > and pgsql AND an upgrade to 8.4. But if it's fast enough, then stick > to 8.1.x I would recommend an update to the latest 8.1 release > though. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
