On Thu, Jan 7, 2010 at 3:05 PM, Lefteris <lsi...@gmail.com> wrote: > On Thu, Jan 7, 2010 at 3:51 PM, Ivan Voras <ivo...@freebsd.org> wrote: >> On 7.1.2010 15:23, Lefteris wrote: >> >>> I think what you all said was very helpful and clear! The only part >>> that I still disagree/don't understand is the shared_buffer option:)) >> >> Did you ever try increasing shared_buffers to what was suggested (around >> 4 GB) and see what happens (I didn't see it in your posts)? > > No I did not to that yet, mainly because I need the admin of the > machine to change the shmmax of the kernel and also because I have no > multiple queries running. Does Seq scan uses shared_buffers? Think of the shared buffer as a cache. It will help subsequent queries running to not have to use disk.
-- GJ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
