Re: Linux/PostgreSQL scalability issue - problem with 8 cores

From: Jakub Ouhrabka <kuba(at)comgate(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date: 2008-01-03 19:26:30
Message-ID: fljct0$2g7i$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alvaro,

>>> - do an UNLISTEN if possible
>> Yes, we're issuing unlistens when appropriate.
>
> You are vacuuming pg_listener periodically, yes? Not that this seems
> to have any relationship to your problem, but ...

yes, autovacuum should take care of this. But looking forward for
multiple-workers in 8.3 as it should help us during high load periods
(some tables might wait too long for autovacuum now - but it's not that
big problem for us...).

Thanks for great work!

Kuba

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Childs 2008-01-04 08:46:37 Re: Commit takes a long time.
Previous Message Alvaro Herrera 2008-01-03 18:31:18 Re: Linux/PostgreSQL scalability issue - problem with 8 cores