From: Mark Thornton <mthornton@optrak.co.uk>
To: pgsql-performance@postgresql.org
Subject: Re: Slow join on partitioned table
Date: Fri, 04 Mar 2011 17:00:27 +0000
Message-ID: <4D711AAB.5010801@optrak.co.uk> (raw)
In-Reply-To: <AANLkTinD5R7f6W5ziC2RzszwGfn48w-u6-6a+t+XPaVH@mail.gmail.com>
References: <4D70CFC7.5050805@optrak.co.uk>
<AANLkTinD5R7f6W5ziC2RzszwGfn48w-u6-6a+t+XPaVH@mail.gmail.com>
On 04/03/2011 16:07, Robert Haas wrote:
> That seems quite surprising. There are only 14 rows in the table but
> PG thinks 2140? Do you have autovacuum turned on? Has this table
> been analyzed recently?
>
I think autovacuum is enabled, but as a temporary table LinkIds has only
existed for a very short time (at least in my current tests).
Mark
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: mthornton@optrak.co.uk
Subject: Re: Slow join on partitioned table
In-Reply-To: <4D711AAB.5010801@optrak.co.uk>
* 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