From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: possible memory leak in VACUUM ANALYZE |
Date: | 2023-02-11 06:06:45 |
Message-ID: | CAFj8pRAcD+cvxUM50XSympSdiXP2y2xkJwVR36k8i4GJw3se3Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
pá 10. 2. 2023 v 23:01 odesílatel Justin Pryzby <pryzby(at)telsasoft(dot)com>
napsal:
> On Fri, Feb 10, 2023 at 09:23:11PM +0100, Pavel Stehule wrote:
> > pá 10. 2. 2023 v 21:18 odesílatel Andres Freund <andres(at)anarazel(dot)de>
> napsal:
> > >
> > > On 2023-02-10 21:09:06 +0100, Pavel Stehule wrote:
> > > > 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).
> > >
> > > Just to make sure: You're certain this was an actual memory leak, not
> just
> > > vacuum ending up having referenced all of shared_buffers? Unless you
> use huge
> > > pages, RSS increases over time, as a process touched more and more
> pages in
> > > shared memory. Of course that couldn't explain rising above
> > > shared_buffers + overhead.
> > >
> > > > 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.
> > >
> > > If you have 1.8 million tables in a single database, what you saw
> might just
> > > have been the size of the relation and catalog caches.
> >
> > can be
>
> Well, how big was shared_buffers on that instance ?
>
20GB RAM
20GB swap
2GB shared buffers
>
> --
> Justin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2023-02-11 06:53:48 | Re: possible memory leak in VACUUM ANALYZE |
Previous Message | Takamichi Osumi (Fujitsu) | 2023-02-11 05:44:47 | RE: Time delayed LR (WAS Re: logical replication restrictions) |