Re: how to shrink pg_attribute table in some database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Artem Tomyuk <admin(at)leboutique(dot)com>
Cc: Hubert Lubaczewski <depesz(at)depesz(dot)com>, Keith <keith(at)keithf4(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how to shrink pg_attribute table in some database
Date: 2018-03-26 15:46:21
Message-ID: 28175.1522079181@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Artem Tomyuk <admin(at)leboutique(dot)com> writes:
> There was broken query that every time was creating temp table and than was
> trying to insert into this table some data in another query but within
> single connection, what happened next that second query was unable to be
> executed because of syntax error (yes, human factor), this query was
> repeated every minute by cron 24/7.

One temp table per minute doesn't explain this amount of bloat, unless
autovacuum had failed to process pg_attribute for a really really long
time. It would be good to figure out why that happened.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Artem Tomyuk 2018-03-26 15:51:10 Re: how to shrink pg_attribute table in some database
Previous Message Artem Tomyuk 2018-03-26 15:41:48 Re: how to shrink pg_attribute table in some database