Postgres Pro
Downloads
Home   >   mailing lists

Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)
Date
Msg-id C2404E95-2419-4F83-86C6-58A22C055230@anarazel.de
Whole thread Raw
In response to Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers
Tree view 

On August 24, 2016 9:32:48 AM PDT, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
>
>
>On 08/24/2016 12:20 AM, Andres Freund wrote:
>> On 2016-08-23 19:18:04 -0300, Claudio Freire wrote:
>>> On Tue, Aug 23, 2016 at 7:11 PM, Tomas Vondra
>>> <tomas.vondra@2ndquadrant.com> wrote:
>>>> Could someone please explain how the unlogged tables are supposed
>to fix the
>>>> catalog bloat problem, as stated in the initial patch submission?
>We'd still
>>>> need to insert/delete the catalog rows when creating/dropping the
>temporary
>>>> tables, causing the bloat. Or is there something I'm missing?
>>
>> Beats me.
>>
>
>Are you puzzled just like me, or are you puzzled why I'm puzzled?

Like you. I don't think this addresses the problem to a significant enough degree to care.

Andres
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)
Next
From: Anastasia Lubennikova
Date:
Subject: Re: Optimization for lazy_scan_heap