Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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
- Follow-Ups:
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Sebastian
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- References:
- broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Sebastian
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Michael Fuhr
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Sebastian
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Michael Fuhr
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Sebastian
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Sebastian
- Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- From: Michael Fuhr
- broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- Prev by Date: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Next by Date: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
- Previous by thread: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- Next by thread: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
- Indexes: