Re: Query Optimizer makes a poor choice - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Query Optimizer makes a poor choice
Date
Msg-id 4ED5679B.1020406@fuzzy.cz
Whole thread Raw
In response to Re: Query Optimizer makes a poor choice  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
On 29.11.2011 23:19, Tomas Vondra wrote:
> Hi,
>
> 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.

Tomas

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Query Optimizer makes a poor choice
Next
From: panam
Date:
Subject: Re: Extending the volume size of the data directory volume