pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Inconsistent performance
Date: Mon, 15 Sep 2003 22:26:45 -0400
Message-ID: <m38yoptqmy.fsf@wolfe.cbbrowne.com> (raw)
References: <5.1.0.14.2.20030915182422.00a8a2d8@mail.vetstar.com>
The world rejoiced as jbove@vetstar.com (Joseph Bove) wrote:
> Actually, it's inconsistent with the exact same command. I've now
> replicated the problem by doing the following command:
>
> select count (*) from table;
>
> The table in question has 88899 rows.
>
> The response time is anywhere from 1 second to 12 seconds. Different
> response times can occur in the same minute of testing!
The only possible plan for THAT query will involve a seq scan of the
whole table. If the postmaster already has the data in cache, it
makes sense for it to run in 1 second. If it has to read it from
disk, 12 seconds makes a lot of sense.
You might want to increase the "shared_buffers" parameter in
postgresql.conf; that should lead to increased stability of times as
it should be more likely that the data in "table" will remain in
cache.
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/x.html
Signs of a Klingon Programmer - 8. "Debugging? Klingons do not
debug. Our software does not coddle the weak. Bugs are good for
building character in the user."
view thread (16+ messages) latest in thread
Message-ID: <m38yoptqmy.fsf@wolfe.cbbrowne.com> Permalink: ../m38yoptqmy.fsf@wolfe.cbbrowne.com/ Also on: postgresql.org/message-id/m38yoptqmy.fsf@wolfe.cbbrowne.com ·
reply
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 from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: cbbrowne@acm.org Subject: Re: Inconsistent performance In-Reply-To: <m38yoptqmy.fsf@wolfe.cbbrowne.com> References: <5.1.0.14.2.20030915182422.00a8a2d8@mail.vetstar.com> <m38yoptqmy.fsf@wolfe.cbbrowne.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