Re: updating a row in a table with only one row

From: Hélder M(dot) Vieira <hmv(at)mail(dot)telepac(dot)pt>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: updating a row in a table with only one row
Date: 2009-10-02 09:25:20
Message-ID: FA02B0B91C8C4F6D8CA0455C580DC80C@Hmv03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> There are ~100 tables in the database and one of them (tableOne) always
> contains only a single row. There's one index on it. However performing
> update on the single row (which occurs every 60 secs) takes a
> considerably long time -- around 200ms. The system is not loaded in any
> way.

How often is the the table VACUUMed ?
At the mentioned update rate, the table has a daily growth of 1440 dead row
versions.

Helder M. Vieira

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scara Maccai 2009-10-02 09:28:17 Re: Best suiting OS
Previous Message A. Kretschmer 2009-10-02 09:14:35 Re: updating a row in a table with only one row