Hi Tom,
I hope !
I changed it to 64 MB .
At the momenth I have results with 215 000 records.
The times is 28 sec ( for 66 000 it was ~ 8.5 sec.).
What is the normal perfornace for pg ?
And can you send me exampel conf file for better performance ?
regards,
Ivan.
Tom Lane wrote:
> pginfo <pginfo@t1.unisoftbg.com> writes:
> > I think that the problem is in sorting.
>
> Not according to the EXPLAIN results ... but did you change sort_mem?
> The default value is kinda small.
>
> regards, tom lane