System catalog bloat removing safety

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
Subject: System catalog bloat removing safety
Date: 2013-09-18 06:12:24
Message-ID: CAL_0b1v-QO6CB8quUgc-z1-3sGDB-Eig-ckJZm_qFHj+BSgsXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

How safe is it to use the technique described by the link below with
system catalog tables to remove bloat?

(in a couple of words it is about moving tuples to the beginning of
the table with a special way of updating)

http://www.depesz.com/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/

Are there any caveats?

Thank you.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-09-18 06:25:24 Re: [RFC] Extend namespace of valid guc names
Previous Message Peter Geoghegan 2013-09-18 05:54:38 Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE