Re: Missed index opportunity for outer join?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Missed index opportunity for outer join?
Date: 2005-12-06 21:42:09
Message-ID: 439605B1.5070800@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:
> If you have background tasks doing ANALYZEs then this explanation seems
> plausible enough. I'm willing to accept it anyway ...

Yup, there are such tasks. I could dig through logs to try to confirm
or reject it; but I think it's reasonably likely that this happened.
Basically, data gets added to that table as it becomes ready from other
systems, and after each batch a vacuum analyze is run.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brandon Metcalf 2005-12-06 21:45:04 Re: Context switching and Xeon processors
Previous Message Alan Stange 2005-12-06 21:39:59 Re: postgresql performance tuning