On Thu, Jan 7, 2010 at 3:05 PM, Lefteris <lsidir@gmail.com> wrote:
> On Thu, Jan 7, 2010 at 3:51 PM, Ivan Voras <ivoras@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
