Re: Compressing temporary files - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Compressing temporary files
Date
Msg-id 20211006142447.GG24555@momjian.us
Whole thread Raw
In response to Compressing temporary files  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
On Sat, Sep 11, 2021 at 05:31:37PM +0500, Andrey Borodin wrote:
> How do you think: does it worth to pursue the idea? OLTP systems rarely rely on data spilled to disk.
> Are there any known good random access compressed file libs? So we could avoid reinventing the wheel.
> Maybe someone tried this approach before?

Why are temporary tables more useful for compression that other database
files?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-hackers by date:

Previous
From: Andrew Bille
Date:
Subject: Re: [Proposal] Global temporary tables
Next
From: Tom Lane
Date:
Subject: Re: Improved tab completion for PostgreSQL parameters in enums