From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Roman Fail <rfail@posportal.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3.1 New install, large queries are slow
Date: Wed, 15 Jan 2003 11:44:01 -0800 (PST)
Message-ID: <20030115113159.F91182-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BF9@pos_pdc.posportal.com>
On Wed, 15 Jan 2003, Roman Fail wrote:
> The disks are not reading at max speed during the query - when I ran a
> VACUUM ANALYZE (after data migration), sar -b was consistently 100,000
> block reads/sec. It does not seem like the hardware is holding back
> things here. I read something about 'fsync' recently, would changing
> that setting apply in this case?
You ran vacuum analyze, but some of the explain still looks suspiciously
like it's using default statistics (dr and cr for example, unless they
really do have 1000 rows).
What are the actual query and table definitions for the query?
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: sszabo@megazone23.bigpanda.com, rfail@posportal.com
Subject: Re: 7.3.1 New install, large queries are slow
In-Reply-To: <20030115113159.F91182-100000@megazone23.bigpanda.com>
References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4BF9@pos_pdc.posportal.com> <20030115113159.F91182-100000@megazone23.bigpanda.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