Skip site navigation (1) Skip section navigation (2)

Re: Vacuum analyse after a long time without one ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum analyse after a long time without one ...
Date: 2009-09-11 18:20:08
Message-ID: 23765.1252693208@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Anj Adu <fotographs(at)gmail(dot)com> writes:
> For a 64 bit machine..does the higher shared buffer setting really
> offer a significant improvement over a 32 bit lower setting coupled
> with linux caching ? Is the postgres shared buffer algorithm superior
> to the linux caching algorithm to favor a switch to 64 bit

There are different schools of thought about that, but in any case the
difference is not likely to be large.  If you want to discuss it,
pgsql-performance would be a better forum.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: raghu ramDate: 2009-09-13 08:23:01
Subject: Invitation to connect on LinkedIn
Previous:From: Anj AduDate: 2009-09-11 18:13:25
Subject: Re: Vacuum analyse after a long time without one ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group