public inbox for [email protected]  

help / color / mirror / Atom feed

From: George Neuner <[email protected]>
To: [email protected] <[email protected]>
Cc: [email protected]
Subject: Re: Unlogged tables
Date: Thu, 10 Aug 2017 18:52:46 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <BN4PR15MB05477F51C9D6D8B45178F64585880@BN4PR15MB0547.namprd15.prod.outlook.com>
References: <[email protected]>
	<BN4PR15MB0547F5864AD9691E31458FE1858B0@BN4PR15MB0547.namprd15.prod.outlook.com>
	<[email protected]>
	<BN4PR15MB05477F51C9D6D8B45178F64585880@BN4PR15MB0547.namprd15.prod.outlook.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>



On 8/10/2017 1:29 AM, [email protected] wrote:
>
> Finally, my true question was whether Postgres would support something 
> like worm with the performance benefits of UNLOGGED, but not the 
> inconveniences of auto truncates.
>

If you can live with the limitations, one other thing you might try is 
storing WORM data in the filesystem and accessing it via file_fdw.
https://www.postgresql.org/docs/current/static/file-fdw.html

There are a lot of downsides to this:  file_fdw tables are read-only, so 
you have to update the external file through some other means.  Also, 
I've never used file_fdw, so I'm not sure whether you can create indexes 
on the tables - and even if you can, you would need to manually recreate 
the indexes periodically because Postgresql won't see your updates.

George

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Unlogged tables
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox