Re: Postgres 7.4.9 slow!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres 7.4.9 slow!
Дата
Msg-id 21209.1129904407@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgres 7.4.9 slow!  (Mario Splivalo <mario.splivalo@mobart.hr>)
Ответы Re: Postgres 7.4.9 slow!  (Mario Splivalo <mario.splivalo@mobart.hr>)
Список pgsql-sql
Mario Splivalo <mario.splivalo@mobart.hr> writes:
> I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> One has 85000 records, and other has 1000000 records. I've been running
> the tests on 7.4.3,

Your later message shows 7.4.8.  Which is it?

> But, now I downloaded postgres 7.4.9, and i'm running the very same
> query on the very same database with all the indices and constraints
> beeing the same (also SET ENABLE_SEQSCAN TO OFF), and I get around
> 90-110 seconds.

You sure it's the very same?  The version outputs suggest that these
might be two different machines; certainly two very different compilers
were used.  One thing I'd wonder about is whether both databases were
initialized in the same locale.
        regards, tom lane


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

Предыдущее
От: Wiebe Cazemier
Дата:
Сообщение: Delete rule chain stops unexpectedly
Следующее
От: Mario Splivalo
Дата:
Сообщение: Re: Postgres 7.4.9 slow!