increasing shared buffer slow downs query performance.

From: "petchimuthu lingam" <spmlingam(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: increasing shared buffer slow downs query performance.
Date: 2008-03-24 09:27:59
Message-ID: cd233fc30803240227u7507f0c7wf67bb313c61f8a7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi friends,

I am using postgresql 8.1, I have shared_buffers = 50000, now i execute the
query, it takes 18 seconds to do sequential scan, when i reduced to 5000, it
takes one 10 seconds, Why.

Can anyone explain what is the reason, ( any other configuration is needed
in postgresql.conf)

--
With Best Regards,
Petchimuthulingam S

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Kretschmer 2008-03-24 10:07:19 Re: increasing shared buffer slow downs query performance.
Previous Message vincent 2008-03-24 08:35:44 Re: slow pg_connect()