> 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 5: don't forget to increase your free space map settings

Reply via email to