Postgres Pro
Downloads
Home   >   mailing lists

Re: logtape.c stats don't account for unused "prefetched" block numbers - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: logtape.c stats don't account for unused "prefetched" block numbers
Date
Msg-id 0383d21d58c6fd7d2426d7730c50c6743a5ba303.camel@j-davis.com
Whole thread Raw
In response to Re: logtape.c stats don't account for unused "prefetched" block numbers  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
On Sat, 2020-09-05 at 12:03 -0700, Peter Geoghegan wrote:
> We should totally disable the preallocation stuff for external sorts
> in any case. External sorts are naturally characterized by relatively
> large, distinct batching of reads and writes -- preallocation cannot
> help.

Patch attached to disable preallocation for Sort.

I'm still looking into the other concerns.

Regards,
    Jeff Davis
Attachment

pgsql-hackers by date:

Previous
From: James Coleman
Date:
Subject: Re: [DOC] Document concurrent index builds waiting on each other
Next
From: James Coleman
Date:
Subject: Re: PROC_IN_ANALYZE stillborn 13 years ago