Re: Enumeration of tables is very slow in largish database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kirill Müller <kirill(dot)mueller(at)ivt(dot)baug(dot)ethz(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: Enumeration of tables is very slow in largish database
Date: 2012-01-12 01:02:07
Message-ID: 943.1326330127@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?Kirill_M=FCller?= <kirill(dot)mueller(at)ivt(dot)baug(dot)ethz(dot)ch> writes:
> On 01/12/2012 01:34 AM, Tom Lane wrote:
>> This is probably an indication of eqjoinsel_semi doing the wrong thing;
>> we've whacked that estimator around a few times now, so it's hard to
>> know whether this represents an already-fixed bug or not. What PG
>> version are you using exactly?

> muelleki(at)xxx:~$ psql
> psql (8.4.8)

There were fixes for that in 8.4.9, so I'd be interested to know if you
get a better estimate in a more up-to-date version.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kirill Müller 2012-01-12 01:08:27 Re: Enumeration of tables is very slow in largish database
Previous Message Kirill Müller 2012-01-12 00:45:55 Re: Enumeration of tables is very slow in largish database