public inbox for [email protected]
help / color / mirror / Atom feedFrom: Siraj G <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: Álvaro Herrera <[email protected]>
Cc: [email protected]
Subject: Re: size of attributes table is too big
Date: Wed, 19 Mar 2025 23:02:04 +0530
Message-ID: <CAC5iy60eCTtUJPTrwt3f0hgvWyn9Au7kiYGJYYxqj=+7Khx27g@mail.gmail.com> (raw)
In-Reply-To: <CAFj8pRDhfOs5mDQNL7D7Z+CxX6ceXppQFLCOYPQKmLqH3BHotg@mail.gmail.com>
References: <CAC5iy61zUBySCMFH3JSKd6W922nV3fHMpXi+qUuPvXQ3shuOBg@mail.gmail.com>
<[email protected]>
<CAFj8pRDhfOs5mDQNL7D7Z+CxX6ceXppQFLCOYPQKmLqH3BHotg@mail.gmail.com>
Hello Pavel
The SQL instance is a target of google DMS and it does have a physical
replica.
A couple of weeks back we did have a performance issue and vacuum was run
at that time to fix the problem. Very soon we may run into the same problem
I presume.
Regards
Siraj
On Wed, Mar 19, 2025 at 10:47 PM Pavel Stehule <[email protected]>
wrote:
>
>
> st 19. 3. 2025 v 18:14 odesílatel Álvaro Herrera <[email protected]>
> napsal:
>
>> Hello
>>
>> On 2025-Mar-19, Siraj G wrote:
>>
>> > I have a PG (v16) instance which is occupying around 1TB of storage.
>> Out of
>> > this, around 350GB is occupied by the table pg_catalog.pg_attribute.
>> > Why is the catalog table's size so big?
>>
>> Heavy use of temp tables is a known cause of this.
>>
>> > I think this table must have tons of dead tuples. Please suggest to me
>> if
>> > we can purge any data/shrink the size of this table.
>>
>> Yeah, I'd also bet that there are tons of dead tuples, or just unused
>> free space. To purge it you would use VACUUM FULL, though that would
>> need to lock all accesses to the table.
>>
>> Does your instance run with autovacuum disabled perchance?
>>
>
> or long unclosed transactions, maybe forgotten replication slots, ...
>
> It is very strange so with this size it is still usable. Today hardware is
> unbelievable strong
>
> Regards
>
> Pavel
>
>
>>
>> --
>> Álvaro Herrera PostgreSQL Developer —
>> https://www.EnterpriseDB.com/
>> Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
>> stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
>> After collecting 500 such letters, he mused, a university somewhere in
>> Arizona would probably grant him a degree. (Don Knuth)
>>
>>
>>
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: size of attributes table is too big
In-Reply-To: <CAC5iy60eCTtUJPTrwt3f0hgvWyn9Au7kiYGJYYxqj=+7Khx27g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox