Re: Query Optimizer makes a poor choice

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query Optimizer makes a poor choice
Date: 2011-11-29 23:15:39
Message-ID: 4ED5679B.1020406@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-29 23:37:20 Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)?
Previous Message Tomas Vondra 2011-11-29 23:14:22 Re: Query Optimizer makes a poor choice