Re: same plan, add 1 condition, 1900x slower

From: Richard Huxton <dev(at)archonet(dot)com>
To: Mitch Skinner <mitch(at)egcrc(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: same plan, add 1 condition, 1900x slower
Date: 2005-11-11 11:51:55
Message-ID: 437485DB.50005@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-11-11 14:09:36 Re: same plan, add 1 condition, 1900x slower
Previous Message Mitch Skinner 2005-11-11 09:17:15 Re: same plan, add 1 condition, 1900x slower