I played with work_mem and setting work_mem more than 256000 do not change the performance.
I try to upgrade to 8.3 using etch-backports but it's a new install not an upgrade. So i have to create users, permissions, import data again, it scared me so i want to find another solutions first. But now i'll try 8.3 On Thu, 02 Oct 2008 10:36:50 +0200, Tommy Gildseth <[EMAIL PROTECTED]> wrote: > Richard Huxton wrote: >> [EMAIL PROTECTED] wrote: >>> Thanks, >>> >>> Unfornatly, i can't update pgsql to 8.3 since it's not in debian > stable. >> >> That's why backports.org was invented :-) >> Or does can't mean "not allowed to"? > > > Well, running production servers from backports can be a risky > proposition too, and can land you in situations like the one discussed > in "Debian packages for Postgres 8.2" from the General list. > > > -- > Tommy Gildseth -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
