From: Pavan Deolasee <pavan.deolasee@gmail.com>
To: Andreas Kretschmer <akretschmer@spamfence.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: increasing shared buffer slow downs query performance.
Date: Tue, 25 Mar 2008 17:53:58 +0530
Message-ID: <2e78013d0803250523w28a16315w3e5ec0846155c8b7@mail.gmail.com> (raw)
In-Reply-To: <20080324100718.GA7822@KanotixBox>
References: <cd233fc30803240227u7507f0c7wf67bb313c61f8a7@mail.gmail.com>
<20080324100718.GA7822@KanotixBox>
On Mon, Mar 24, 2008 at 3:37 PM, Andreas Kretschmer
<akretschmer@spamfence.net> wrote:
> petchimuthu lingam <spmlingam@gmail.com> schrieb:
>
>
> > 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.
>
> Wild guess: the second time the data are in the filesystem cache.
>
Another wild possibility is that the first query sets the hint bits for the
rows involved and hence the second time it runs fast. May be you want
to run the query few times in both the settings and then compare.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pavan.deolasee@gmail.com, akretschmer@spamfence.net
Subject: Re: increasing shared buffer slow downs query performance.
In-Reply-To: <2e78013d0803250523w28a16315w3e5ec0846155c8b7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox