Re: dedicated server & postgresql 8.1 conf tunning

From: <paul(at)wayr(dot)org>
To: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: dedicated server & postgresql 8.1 conf tunning
Date: 2008-10-02 15:14:34
Message-ID: 1f85e3205b1395eaa2ac64a295a226ba@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
<tommy(dot)gildseth(at)usit(dot)uio(dot)no> wrote:
> Richard Huxton wrote:
>> paul(at)wayr(dot)org 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Віталій Тимчишин 2008-10-02 15:21:59 Re: Delete performance again
Previous Message Tom Lane 2008-10-02 12:14:20 Re: Delete performance again