Re: extremely slow when execute select/delete for certain tables

Поиск
Список
Период
Сортировка
От kah_hang_ang@toray.com.my
Тема Re: extremely slow when execute select/delete for certain tables
Дата
Msg-id OFDCB56234.D420B52A-ON48257169.000581D2@pengroup.com.my
обсуждение исходный текст
Список pgsql-performance



Actually now I already work to upgrade Postgresql version to 8.1 but not
yet finish.

Yesterday I did re-create the affected tables indices, it does improve the
performance but still need 2-5 mins to execute the query.
Is this 'normal' for a table with 40K rows of records?

Anyway thanks for your help.



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

Предыдущее
От: Brendan Duddridge
Дата:
Сообщение: Assistance with optimizing query - same SQL, different category_id = Seq Scan
Следующее
От: "soni de"
Дата:
Сообщение: Re: Takes too long to fetch the data from database