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

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: 2005-12-29 20:59:48
Message-ID: 20051229205948.GA9702@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Larry RosenmanDate: 2005-12-29 21:15:01
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Previous:From: SebastianDate: 2005-12-29 20:12:52
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1

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