> 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