Re: Preventing free space from being reused

2021-02-14 Thread Noah Bergbauer
le free space maps entirely for some added efficiency, but I'm inclined to agree that this is not really needed. On Sat, Feb 13, 2021 at 1:36 PM John Naylor wrote: > On Fri, Feb 12, 2021 at 6:21 PM Noah Bergbauer > wrote: > > > > A btree index on the same column is 700x th

Re: Preventing free space from being reused

2021-02-12 Thread Noah Bergbauer
ppreciated! But at the moment HEAP_INSERT_SKIP_FSM seems like the most practical solution to me. On Fri, Feb 12, 2021 at 10:43 PM Tom Lane wrote: > Noah Bergbauer writes: > > I am working on a project where I do not want Postgres to reuse free > space > >

Preventing free space from being reused

2021-02-12 Thread Noah Bergbauer
ight cause incompatibilities. Any ideas on how to proceed with this issue? Thank you, Noah Bergbauer