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 Corey Huinker
Subject Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)
Date
Msg-id CADkLM=dyyWBcBKPWAG+Jk3RLvveO8rEJ8A3JO-_1uX5Swgn2RA@mail.gmail.com
Whole thread Raw
In response to Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view
On Wed, Aug 31, 2016 at 6:07 PM, Andres Freund <andres@anarazel.de> wrote:

In my experience pg attribute is usually the worst affected. Many tech takes won't even have stays entries...


Mine too. One database currently has a 400GB pg_attribute table, because we chew through temp tables like popcorn. 

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: _mdfd_getseg can be expensive
Next
From: Jeff Janes
Date:
Subject: Re: Notice lock waits