Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Sebastian <buddhahead(at)gmail(dot)com>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- Date: Fri, 30 Dec 2005 15:55:25 -0700
- Message-id: <20051230225525.GA14981@winnie.fuhr.org> <text/plain>
On Fri, Dec 30, 2005 at 11:02:20AM -0700, Michael Fuhr wrote:
> On Fri, Dec 30, 2005 at 03:15:03AM -0500, Sebastian wrote:
> > Any ideas for a temporary work around?
>
> You could try querying the system catalogs directly instead of using
> the information_schema views;
You could also set enable_nestloop to off for your original query.
Now that EXPLAIN is fixed it looks like 8.1.1 is choosing a nested
loop where a hash join is actually much faster.
--
Michael Fuhr
Home |
Main Index |
Thread Index