From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Grigory Smolkin <g.smolkin@postgrespro.ru>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Fun fact about autovacuum and orphan temp tables
Date: Tue, 6 Sep 2016 11:21:39 -0500
Message-ID: <ef118ae5-7e96-6470-0fe9-88fda5f9714f@BlueTreble.com> (raw)
In-Reply-To: <20160905171454.GC13538@momjian.us>
References: <5b48a2e8-571a-d24f-6a4a-cd5744e6f1dc@postgrespro.ru>
<20160905154832.GA681833@alvherre.pgsql>
<20160905171454.GC13538@momjian.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 9/5/16 12:14 PM, Bruce Momjian wrote:
>> > I have certainly faced my fair share of customers with dangling temp
>> > tables, and would like to see this changed in some way or another.
> I don't think we look at those temp tables frequently enough to justify
> keeping them around for all users.
Plus, if we cared about forensics, we'd prevent re-use of the orphaned
schemas by new backends. That doesn't seem like a good idea for normal
use, but if we had a preserve_orphaned_temp_objects GUC someone could
add that behavior.
Isn't there some other GUC aimed at preserving data for forensics
(besides zero_damaged_pages)? Maybe we could just broaden that to
include orphaned temp objects.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: Jim.Nasby@BlueTreble.com, bruce@momjian.us, alvherre@2ndquadrant.com, g.smolkin@postgrespro.ru
Subject: Re: Fun fact about autovacuum and orphan temp tables
In-Reply-To: <ef118ae5-7e96-6470-0fe9-88fda5f9714f@BlueTreble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox