Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Дата
Msg-id 200907161133.41945.andres@anarazel.de
обсуждение исходный текст
Ответ на Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1  (ning <mailxiening@gmail.com>)
Ответы Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Список pgsql-performance
Дерево обсуждения 
On Thursday 16 July 2009 11:30:00 ning wrote:
> Hi Andres,
>
> By executing
> #explain analyze execute test_query;
>
> the first execution cost 0.389 seconds
> the second cost 0.285 seconds
Seconds or milliseconds?

If seconds that would be by far slower than the plain SELECT, right?

Andres

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

Предыдущее
От: ning
Дата:
Сообщение: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Следующее
От: ning
Дата:
Сообщение: Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1