Frequently updated tables

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Frequently updated tables
Date: 2004-06-08 19:24:42
Message-ID: 15231.64.119.142.34.1086722682.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've been down several roads about how to handle data that has to change
on a very frequent and rapid manner.

Think about summary tables, WEB session tables, etc. As great as MVCC is
for the vast majority of uses. The overhead of updates and deletes can
kill a project that needs to constantly update tables.

In most cases, the answer is just not to use PostgreSQL for that, but then
you are stuck with Mysql or something worse.

Would having a special class of table that is marked for frequent updates,
which causes the system to lock and update in place, make sense? Is that
even possible?

There has to be a way of making PostgreSQL able to handle this class of
problem. Anyone have a reasonable idea?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2004-06-08 22:15:40 Re: Frequently updated tables
Previous Message Andreas Pflug 2004-06-08 18:27:29 Re: serverlog function (log_destination file)