Postgres Pro
Downloads
Home   >   mailing lists

Re: updating a row in a table with only one row - Mailing list pgsql-performance

From Hélder M. Vieira
Subject Re: updating a row in a table with only one row
Date
Msg-id FA02B0B91C8C4F6D8CA0455C580DC80C@Hmv03
Whole thread Raw
In response to updating a row in a table with only one row  (Michal Vitecek <fuf@mageo.cz>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Scara Maccai
Date:
Subject: Re: Best suiting OS
Next
From: Matthew Wakeling
Date:
Subject: Re: Best suiting OS