Horton

Re: unlogged tables

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, marcin mank <marcin.mank@gmail.com>, Andy Colson <andy@squeakycode.net>, pgsql-hackers@postgresql.org
Date: 2010-11-17T18:32:27Z
Lists: pgsql-hackers 
On 17.11.2010 17:11, Tom Lane wrote:
> Heikki Linnakangas<heikki.linnakangas@enterprisedb.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.

I must be missing something: we handle that just fine with normal 
tables, why is it a problem for unlogged tables?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com