read-only UNLOGGED tables - Mailing list pgsql-general

From Leonardo Francalanci
Subject read-only UNLOGGED tables
Date
Msg-id 63721.21717.qm@web29017.mail.ird.yahoo.com
Whole thread Raw
Responses Re: read-only UNLOGGED tables
List pgsql-general
Hi,

we're inserting tons of rows in some partitioned tables, and to get
more performance out of the system we would like to use UNLOGGED
tables that, after some time, become "regular" tables (at that point, we
wouldn't want to write to them anymore; we could only select or drop
them). Would it be a feature that can be added in the future, assuming
that the tables would then flagged somehow as "read only"?



Leonardo




pgsql-general by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: [HACKERS] Date conversion using day of week
Next
From: Gianni Ciolli
Date:
Subject: Re: read-only UNLOGGED tables