On 2. Oct, 2008, at 10:00, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote:
Unfornatly, i can't update pgsql to 8.3 since it's not in debian
stable.
Did you consider using backport packages (http://www.backports.org) for
Debian Etch? They are providing postgresql v.8.3.3 packages for Debian
E
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
Tommy Gildseth 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 b
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, an
[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"?
> So i'm going to play with work_mem & shared_buffers.
>
> With big shared_buffers pgsql tells me
> shm
Thanks,
Unfornatly, i can't update pgsql to 8.3 since it's not in debian stable.
So i'm going to play with work_mem & shared_buffers.
With big shared_buffers pgsql tells me
shmget(cle=5432001, taille=11183431680, 03600).
so i do "echo 13183431680 > /proc/sys/kernel/shmmax" ( 10Go + 2Go just
in
[EMAIL PROTECTED] wrote:
> Hello
>
> I'm running pgsql 8.1.11 (from debian stable) on a server with 16GB RAM
> (Linux helios 2.6.18-6-amd64 #1 SMP Tue Aug 19 04:30:56 UTC 2008 x86_64
> GNU/Linux).
Unless you're committed to this version, I'd seriously look into 8.3
from backports (or compiled you
