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

Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1

From: Sebastian <buddhahead(at)gmail(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Date: 2005-12-30 08:15:03
Message-ID: 4e36d31d0512300015s5499c982me8c5267b5edabd17@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Any ideas for a temporary work around?

On 12/29/05, Sebastian <buddhahead(at)gmail(dot)com> wrote:
> > How many columns in the table?
>
> There are 4 columns in the table
>
> On 12/29/05, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> > 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: Simon RiggsDate: 2005-12-30 13:09:12
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Previous:From: Robert TreatDate: 2005-12-30 05:42:10
Subject: Re: Fwd: Re: [ADMIN] migrating oracle table to PostgresQL

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