Re: Slow join on partitioned table

From: Mark Thornton <mthornton(at)optrak(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow join on partitioned table
Date: 2011-03-04 17:00:27
Message-ID: 4D711AAB.5010801@optrak.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2011-03-04 17:34:39 Linux I/O schedulers - CFQ & random seeks
Previous Message Mark Thornton 2011-03-04 16:47:23 Re: Slow join on partitioned table