Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
От | Sebastian |
---|---|
Тема | Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 |
Дата | |
Msg-id | 4e36d31d0512300015s5499c982me8c5267b5edabd17@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 (Sebastian <buddhahead@gmail.com>) |
Ответы |
Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
|
Список | pgsql-hackers |
Any ideas for a temporary work around? On 12/29/05, Sebastian <buddhahead@gmail.com> wrote: > > How many columns in the table? > > There are 4 columns in the table > > On 12/29/05, Michael Fuhr <mike@fuhr.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 > > >
В списке pgsql-hackers по дате отправления: