Re: External data files possible?

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: Chris Cleveland <ccleve+github(at)dieselpoint(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: External data files possible?
Date: 2022-02-22 13:31:04
Message-ID: CAJ7c6TM0uxrmyUiWgSB6sS=vjy3HoXjyPFPQzRG9RoYuCRHvTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Chris,

> Breaking up the data into pages with page headers means a lot of extra work [...]. It would be much better to store the index in a set of external data files. This seems possible so long as I put the files under the database's directory and name things properly.

Just curious, what is your index for, and how you are going to handle
crash recovery?

--
Best regards,
Aleksander Alekseev

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2022-02-22 13:55:23 Re: making pg_regress less noisy by removing boilerplate
Previous Message osumi.takamichi@fujitsu.com 2022-02-22 12:22:18 RE: Design of pg_stat_subscription_workers vs pgstats