Re: Performance problem with a table with 38928077 record

Поиск
Список
Период
Сортировка
От Gregg Jaskiewicz
Тема Re: Performance problem with a table with 38928077 record
Дата
Msg-id CAJY59_h6DoTG0MpSwLbhBR1uWECUBV0cdfgrA6-xF383rQ-Pew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance problem with a table with 38928077 record  (Guillaume Cottenceau <gc@mnc.ch>)
Список pgsql-performance
Дерево обсуждения 
Do you need left join ?
Can you further normalize the tables? (to lower the I/O)
Can you upgrade to at least 8.3 ? It has huuge performance
improvements over 8.3.

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