Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow join on partitioned table - Mailing list pgsql-performance

From Mark Thornton
Subject Re: Slow join on partitioned table
Date
Msg-id 4D711AAB.5010801@optrak.co.uk
Whole thread Raw
In response to Re: Slow join on partitioned table  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Slow join on partitioned table  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Mark Thornton
Date:
Subject: Re: Slow join on partitioned table
Next
From: Glyn Astill
Date:
Subject: Linux I/O schedulers - CFQ & random seeks