Survey on backing up unlogged tables: help us with PostgreSQL development!

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date: 2010-11-16 22:46:45
Message-ID: 4CE309D5.6080805@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Folks,

Please help us resolve a discussion on -hackers.

PostgreSQL 9.1 is likely to have, as a feature, the ability to create
tables which are "unlogged", meaning that they are not added to the
transaction log, and will be truncated (emptied) on database restart.
Such tables are intended for highly volatile, but not very valuable,
data, such as session statues, application logs, etc.

The question is, how would you, as a DBA, expect pg_dump backups to
treat unlogged tables? Backing them up by default has the potential to
both cause performance drag on the unlogged table and make your backups
take longer unless you remember to omit them. Not backing them up by
default has the drawback that if you forget --include-unlogged switch,
and shut the database down, any unlogged data is gone. How would you
*expect* unlogged tables to behave?

Survey is here:
https://spreadsheets.google.com/ccc?key=0AoeuP3g2YZsFdDFnT2VKNC1FQ0pQNmJGS2dWMTNYMEE&hl=en&authkey=CISbwuYD

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-16 22:46:51 Re: Programming error: Out of Memory
Previous Message Jorge Arévalo 2010-11-16 22:35:00 Re: Programming error: Out of Memory