Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group