From: Richard Huxton <dev@archonet.com>
To: Mitch Skinner <mitch@egcrc.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: same plan, add 1 condition, 1900x slower
Date: Fri, 11 Nov 2005 11:51:55 +0000
Message-ID: <437485DB.50005@archonet.com> (raw)
In-Reply-To: <1131700635.29496.136.camel@enzian>
References: <1131630176.29496.91.camel@enzian>
<10164.1131643400@sss.pgh.pa.us>
<1131700635.29496.136.camel@enzian>
Mitch Skinner wrote:
>
> The version with the condition is definitely doing more I/O. The
> version without the condition doesn't read at all.
[snip]
> relname | relpages | reltuples
> -----------------------------+----------+-------------
> external_id_map | 126883 | 1.55625e+07
> external_id_map_primary_key | 64607 | 1.55625e+07
> subject | 31 | 1186
> subject_pkey | 19 | 1186
Does external_id_map really have 15 million rows? If not, try a VACUUM
FULL on it. Be prepared to give it some time to complete.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, mitch@egcrc.net, tgl@sss.pgh.pa.us
Subject: Re: same plan, add 1 condition, 1900x slower
In-Reply-To: <437485DB.50005@archonet.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