Any ideas for a temporary work around?
On 12/29/05, Sebastian <[EMAIL PROTECTED]> wrote:
> > How many columns in the table?
>
> There are 4 columns in the table
>
> On 12/29/05, Michael Fuhr <[EMAIL PROTECTED]> 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
> >
>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
