On 29.11.2011 23:19, Tomas Vondra wrote:
> what PostgreSQL version is this? That's the first thing we need to know.
> On 29.11.2011 22:28, Tyler Hains wrote:
>> Yes, I'm pretty sure autovacuum is enabled. Changing the query as shown
>> there uses the sub-optimal index.
> That doesn't mean
Sorry, deleted this part by accident. It should be "That doesn't mean
the table / index is not bloated." See my other posts for more details.
In response to
pgsql-general by date
|Next:||From: Tomas Vondra||Date: 2011-11-29 23:37:20|
|Subject: Re: Limiting number of connections to PostgreSQL per IP
(not per DB/user)?|
|Previous:||From: Tomas Vondra||Date: 2011-11-29 23:14:22|
|Subject: Re: Query Optimizer makes a poor choice|