AW: Query Planning time increased 3 times on 7.1 compar ed to 7.0.3

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Query Planning time increased 3 times on 7.1 compar ed to 7.0.3
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368221@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> Here is one of the queries, it takes about half a second on our computer
> (PII 233 with 256MB RAM) to execute and returns typically 1-4 rows via
> two index scans with high selectivity. So it looks to me that planning
> time outwages execution time by far. 7.0 took about 0.15 
> seconds (which is still much).

The plans show two different indexes and different statistics for the 
two different versions. No wonder, you see different response times.

Is the "vacuum [analyze]" up to date in both versions ?

Andreas 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christof Petig
Дата:
Сообщение: Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Oops! Its bug in parser????