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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1
Дата
Msg-id 1247646470.32366.27.camel@tillium.localnet
обсуждение исходный текст
Ответ на 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  (Greg Stark <gsstark@mit.edu>)
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  (Andres Freund <andres@anarazel.de>)
Список pgsql-performance
Дерево обсуждения 
On Wed, 2009-07-15 at 12:10 +0900, ning wrote:

> First execution: PostgreSQL 0.006277 seconds / DB2 0.009028 seconds
> Second execution: PostgreSQL 0.005932 seconds / DB2 0.000332 seconds

Actually, on second thoughts that looks a lot like DB2 is caching the
query results and is just returning the cached results when you repeat
the query.

I'm not sure to what extent PostgreSQL is capable of result caching, but
I'd be surprised if it could do as much as DB2.

--
Craig Ringer

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

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