Re: Degenerate Performance Problem

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Vincent Predoehl" <vpredoehl(at)phoenixwebgroup(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Degenerate Performance Problem
Date: 2008-12-10 03:47:23
Message-ID: dcc563d10812091947q6a0813b2m5319cf949785e57e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Dec 9, 2008 at 8:16 PM, Vincent Predoehl
<vpredoehl(at)phoenixwebgroup(dot)com> wrote:
> I have postgresql 8.3.5 installed on MacOS X / Darwin. I remember setting
> shared memory buffer parameters and that solved the initial performance
> problem, but after running several tests, the performance goes way, way
> down. Restarting the server doesn't seem to help.
> I'm using pqxx to access the database, if that makes any difference.

Could be a vacuuming issue.

What does

vacuum verbose;

on the database say?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2008-12-10 05:48:02 Re: Need help with 8.4 Performance Testing
Previous Message Vincent Predoehl 2008-12-10 03:16:43 Degenerate Performance Problem