Re: unlogged tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, marcin mank <marcin(dot)mank(at)gmail(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: unlogged tables
Date: 2010-11-17 15:11:51
Message-ID: 26245.1290006711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> fsync()ing the file at shutdown doesn't seem too bad to me from
> performance point of view, we tolerate that for all other tables. And
> you can always truncate the table yourself before shutdown.

The objection to that was not about performance. It was about how
to find out what needs to be fsync'd.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-11-17 15:20:06 Re: describe objects, as in pg_depend
Previous Message Marc Cousin 2010-11-17 15:00:46 Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY