Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group