Re: Setting Shared-Buffers

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(dot)marlowe(at)gmail(dot)com>wrote:

> On Fri, Jul 10, 2009 at 10:27 PM, <sriram(dot)dandapani(at)bt(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>