Re: slow query performance

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: slow query performance
Дата
Msg-id AANLkTilRWJ2ecRDCJkbXPZ3EhsEv2Vhr2oKTS72iTJPd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: slow query performance  (Anj Adu <fotographs@gmail.com>)
Ответы Re: slow query performance  (Anj Adu <fotographs@gmail.com>)
Список pgsql-performance
On Thu, Jun 10, 2010 at 11:32 AM, Anj Adu <fotographs@gmail.com> wrote:
> Attached

Hmm.  Well, I'm not quite sure what's going on here, but I think you
must be using a modified verison of PostgreSQL, because, as Tom
pointed out upthread, we don't have a data type called "timestamp with
time area".  It would be called "timestamp with time zone".

Can we see the index and table definitions of the relevant tables
(attached as a text file) and the size of each one (use select
pg_relation_size('name'))?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Performance tuning for postgres