pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedincreasing shared buffer slow downs query performance.
3+ messages / 3 participants
[nested] [flat]
* increasing shared buffer slow downs query performance.
@ 2008-03-24 09:27 petchimuthu lingam <spmlingam@gmail.com>
2008-03-24 10:07 ` Re: increasing shared buffer slow downs query performance. Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 1 reply; 3+ messages in thread
From: petchimuthu lingam @ 2008-03-24 09:27 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: increasing shared buffer slow downs query performance.
2008-03-24 09:27 increasing shared buffer slow downs query performance. petchimuthu lingam <spmlingam@gmail.com>
@ 2008-03-24 10:07 ` Andreas Kretschmer <akretschmer@spamfence.net>
2008-03-25 12:23 ` Re: increasing shared buffer slow downs query performance. Pavan Deolasee <pavan.deolasee@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Andreas Kretschmer @ 2008-03-24 10:07 UTC (permalink / raw)
To: pgsql-performance
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.
>
> Can anyone explain what is the reason, ( any other configuration is needed in
> postgresql.conf)
Show us the EXPLAIN ANALYSE - Output.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: increasing shared buffer slow downs query performance.
2008-03-24 09:27 increasing shared buffer slow downs query performance. petchimuthu lingam <spmlingam@gmail.com>
2008-03-24 10:07 ` Re: increasing shared buffer slow downs query performance. Andreas Kretschmer <akretschmer@spamfence.net>
@ 2008-03-25 12:23 ` Pavan Deolasee <pavan.deolasee@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Pavan Deolasee @ 2008-03-25 12:23 UTC (permalink / raw)
To: Andreas Kretschmer <akretschmer@spamfence.net>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-25 12:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-24 09:27 increasing shared buffer slow downs query performance. petchimuthu lingam <spmlingam@gmail.com>
2008-03-24 10:07 ` Andreas Kretschmer <akretschmer@spamfence.net>
2008-03-25 12:23 ` Pavan Deolasee <pavan.deolasee@gmail.com>
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