Re: pg_basebackup failed to read a file

From: Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_basebackup failed to read a file
Date: 2018-08-14 17:40:37
Message-ID: f30f9d43-9a44-8302-a6d2-3c96efb4813e@bmrb.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mate Varga 2018-08-14 17:41:26 pg_upgrade with large pg_largeobject table
Previous Message Ron 2018-08-14 17:14:56 Re: pg_basebackup failed to read a file