On Tue, Feb 11, 2020 at 06:04:09PM +1300, Thomas Munro wrote: > lseek(SEEK_END) seems to be nearly twice as fast as fstat() if you > just call it in a big loop, on Linux and FreeBSD (though I didn't > investigate exactly why, mitigations etc, it certainly returns more > stuff so there's that).
Interesting. What of Windows? We've had for some time now problem with fetching the size of files larger than 4GB (COPY, dumps..). I am wondering if we could not take advantage of that for those cases: https://www.postgresql.org/message-id/15858-9572469fd3b73...@postgresql.org -- Michael
signature.asc
Description: PGP signature
