Re: Please help - performance problems - Mailing list pgsql-sql

From Gaetano Mendola
Subject Re: Please help - performance problems
Date
Msg-id 410445FE.1020709@bigfoot.com
Whole thread Raw
List pgsql-sql
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 by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: regex engine
Next
From: Gaetano Mendola
Date:
Subject: Re: constraitnt on case sensetive and case insensetive columns