Re: Please help - performance problems
От
Gaetano Mendola
Тема
Re: Please help - performance problems
Дата
Msg-id
410445FE.1020709@bigfoot.com
Список
ctrl wrote: > I have news...good news for me:) > even though I wasn't able to find the answers I was looking for, I did > something that made a big difference: by removing the ORDER BY clause, > the same function takes now 5 milliseconds (instead of sometimes 10 > minutes). > I have tried to vacuum, analyze, etc...nothing worked. > I post this hoping it could help somebody. How many memory are you using for the sort operations, is that column indexed ? Regards Gaetano Mendola
В списке pgsql-sql по дате отправления
От: Gaetano Mendola
Дата: