Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Date
Msg-id 20051229205948.GA9702@winnie.fuhr.org
Whole thread Raw
In response to Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1  (Sebastian <buddhahead@gmail.com>)
Responses Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
List pgsql-hackers
On Thu, Dec 29, 2005 at 12:12:52PM -0800, Sebastian wrote:
> I've waited 10 minutes before cancelling. On pg8 it runs in less than a second

How many columns in the table?  In 8.1.1 I'm seeing a nearly
exponential increase in time with each extra column, at least up
to about five columns; with more columns the time continues to
increase although not as sharply.  I don't see such an increase in
8.0.5.  Querying the views individually doesn't take long; I wonder
if the planner is doing something wrong with the join operation.

-- 
Michael Fuhr


pgsql-hackers by date:

Previous
From: Sebastian
Date:
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Next
From: Larry Rosenman
Date:
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1