Don't include MMAP DSM's transient files in basebackup

Started by Oskari Saarenmaaalmost 10 years ago5 messageshackers
Jump to latest

The files are not useful when restoring a backup and would be
automatically deleted on startup anyway. Also deleted an out-of-date
comment in dsm.c.

/ Oskari

Attachments:

0001-Don-t-include-MMAP-DSM-s-transient-files-in-baseback.patchtext/x-patch; name=0001-Don-t-include-MMAP-DSM-s-transient-files-in-baseback.patchDownload+3-5
#2Michael Paquier
michael@paquier.xyz
In reply to: Oskari Saarenmaa (#1)
Re: Don't include MMAP DSM's transient files in basebackup

On Wed, Jul 6, 2016 at 10:46 PM, Oskari Saarenmaa <os@aiven.io> wrote:

The files are not useful when restoring a backup and would be automatically
deleted on startup anyway.

The same could be said about pg_snapshots.
--
Michael

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Andres Freund
andres@anarazel.de
In reply to: Oskari Saarenmaa (#1)
Re: Don't include MMAP DSM's transient files in basebackup

Hi,

On 2016-07-06 16:46:53 +0300, Oskari Saarenmaa wrote:

The files are not useful when restoring a backup and would be automatically
deleted on startup anyway. Also deleted an out-of-date comment in dsm.c.

No arguments against the change. But I am wondering how you ran into
this - the mmap dsm backend really should pretty much never be used...

- Andres

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#4Magnus Hagander
magnus@hagander.net
In reply to: Andres Freund (#3)
Re: Don't include MMAP DSM's transient files in basebackup

On Thursday, July 7, 2016, Andres Freund <andres@anarazel.de> wrote:

On 2016-07-06 16:46:53 +0300, Oskari Saarenmaa wrote:

The files are not useful when restoring a backup and would be

automatically

deleted on startup anyway. Also deleted an out-of-date comment in dsm.c.

No arguments against the change. But I am wondering how you ran into
this - the mmap dsm backend really should pretty much never be used...

Unfortunately I think that's still what happens by default if you use
pg_upgradecluster on debian :(

//Magnus

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

#5Andres Freund
andres@anarazel.de
In reply to: Magnus Hagander (#4)
Re: Don't include MMAP DSM's transient files in basebackup

On 2016-07-07 08:49:18 +0100, Magnus Hagander wrote:

On Thursday, July 7, 2016, Andres Freund <andres@anarazel.de> wrote:

On 2016-07-06 16:46:53 +0300, Oskari Saarenmaa wrote:

The files are not useful when restoring a backup and would be

automatically

deleted on startup anyway. Also deleted an out-of-date comment in dsm.c.

No arguments against the change. But I am wondering how you ran into
this - the mmap dsm backend really should pretty much never be used...

Unfortunately I think that's still what happens by default if you use
pg_upgradecluster on debian :(

Ugh. Sounds like that should better be fixed before 9.6. It'll make
parallel query seriously slower.

Andres

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers