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

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 (view raw or flat)
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

pgsql-performance by date

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

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