Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_basebackup failed to read a file - Mailing list pgsql-general

From Dimitri Maziuk
Subject Re: pg_basebackup failed to read a file
Date
Msg-id f30f9d43-9a44-8302-a6d2-3c96efb4813e@bmrb.wisc.edu
Whole thread Raw
In response to Re: pg_basebackup failed to read a file  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
On 08/14/2018 12:14 PM, Ron wrote:

> Why is checking a bunch of file permissions anywhere close to being as
> expensive as transferring 1.5TB over a WAN link?

Normally it shouldn't be but I recently had postgres create ~13M .snap
files and just opendir() took longer than anyone would care to wait...
so it can be just as expensive.

One could just as easily ask why create mode 600 files in places where
they don't belong.

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_basebackup failed to read a file
Next
From: Mate Varga
Date:
Subject: pg_upgrade with large pg_largeobject table