Re: pg 8.1.2 performance issue

From: "chris smith" <dmagick(at)gmail(dot)com>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg 8.1.2 performance issue
Date: 2006-03-26 04:55:19
Message-ID: 3c1395330603252055uaf86b6r62fa4684012a7708@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/26/06, Ed L. <pgsql(at)bluepolka(dot)net> wrote:
> On Saturday March 25 2006 9:36 pm, Ed L. wrote:
> > I have a performance riddle, hoping someone can point me in a
> > helpful direction. We have a pg 8.1.2 cluster using
> > Apache::Sessions and experiencing simple UPDATEs taking
> > sometimes 30+ seconds to do a very simply update, no foreign
> > keys, no triggers:
> >
> > Table "public.sessions"
> > Column | Type | Modifiers
> > -----------+---------------+-----------
> > id | character(32) | not null
> > a_session | text |
> > Indexes:
> > "sessions_pkey" PRIMARY KEY, btree (id)
>
> The table has 6800 rows over 18000 pages, and is getting a
> minimum of many tens of thousands of updates per day with
> queries like this:

If you're updating that much, how often are you running 'analyze'? Are
you running autovacuum? How often?

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2006-03-26 14:22:46 Re: pg 8.1.2 performance issue
Previous Message Ed L. 2006-03-26 04:53:03 Re: pg 8.1.2 performance issue