pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: paul@wayr.org
To: Tommy Gildseth <tommy.gildseth@usit.uio.no>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: dedicated server & postgresql 8.1 conf tunning
Date: Thu, 2 Oct 2008 17:14:34 +0200
Message-ID: <1f85e3205b1395eaa2ac64a295a226ba@localhost> (raw)
In-Reply-To: <48E48822.5060009@usit.uio.no>
References: <48E48822.5060009@usit.uio.no>

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.gildseth@usit.uio.no> wrote:
> Richard Huxton wrote:
>> paul@wayr.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




view thread (8+ messages)

Message-ID: <1f85e3205b1395eaa2ac64a295a226ba@localhost>
Permalink:  ../1f85e3205b1395eaa2ac64a295a226ba@localhost/
Also on:    postgresql.org/message-id/1f85e3205b1395eaa2ac64a295a226ba@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: paul@wayr.org, tommy.gildseth@usit.uio.no, dev@archonet.com
  Subject: Re: dedicated server & postgresql 8.1 conf tunning
  In-Reply-To: <1f85e3205b1395eaa2ac64a295a226ba@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox