Re: [PERFORM] Unlogged tables

Поиск
Список
Период
Сортировка
От George Neuner
Тема Re: [PERFORM] Unlogged tables
Дата
Msg-id 803241c0-fb96-2f41-4648-d75aefab2091@comcast.net
обсуждение исходный текст
Ответ на Re: [PERFORM] Unlogged tables  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список pgsql-performance


On 8/10/2017 1:29 AM, ldh@laurent-hasson.com 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: George Neuner
Дата:
Сообщение: Re: [PERFORM] Unlogged tables
Следующее
От: tianazavee
Дата:
Сообщение: [PERFORM] Kaufen Pass, Führerschein und Ausweis,COUNTERFEIT DOLLARS, EURO, AND POUNDS: --(contact--Whatsapp: +44 7572 012958)