possible memory leak in VACUUM ANALYZE

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: possible memory leak in VACUUM ANALYZE
Date: 2023-02-10 20:09:06
Message-ID: CAFj8pRAn=CGR6AdHU_BpGMD=uWGggCXRv=hng_+T=AWor8r=0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

Just a small note - I executed VACUUM ANALYZE on one customer's database,
and I had to cancel it after a few hours, because it had more than 20GB RAM
(almost all physical RAM). The memory leak is probably not too big. This
database is a little bit unusual. This one database has more than 1 800
000 tables. and the same number of indexes.

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2023-02-10 20:15:22 Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry
Previous Message Andres Freund 2023-02-10 20:01:45 Re: [PATCH] Compression dictionaries for JSONB