Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Pavel Stehule
so 11. 2. 2023 v 7:53 odesílatel Justin Pryzby napsal: > On Sat, Feb 11, 2023 at 07:06:45AM +0100, Pavel Stehule wrote: > > pá 10. 2. 2023 v 23:01 odesílatel Justin Pryzby > napsal: > > > On Fri, Feb 10, 2023 at 09:23:11PM +0100, Pavel Stehule wrote: > > > > pá 10. 2. 2023 v 21:18 odesílatel And

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Andres Freund
Hi, On 2023-02-11 00:53:48 -0600, Justin Pryzby wrote: > On Sat, Feb 11, 2023 at 07:06:45AM +0100, Pavel Stehule wrote: > > pá 10. 2. 2023 v 23:01 odesílatel Justin Pryzby > > napsal: > > > On Fri, Feb 10, 2023 at 09:23:11PM +0100, Pavel Stehule wrote: > > > > pá 10. 2. 2023 v 21:18 odesílatel A

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Justin Pryzby
On Sat, Feb 11, 2023 at 07:06:45AM +0100, Pavel Stehule wrote: > pá 10. 2. 2023 v 23:01 odesílatel Justin Pryzby 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 > > > napsal: > > > > On 2023-02-10 21:09:06 +0100, Pa

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Pavel Stehule
pá 10. 2. 2023 v 23:01 odesílatel Justin Pryzby 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 > napsal: > > > > > > On 2023-02-10 21:09:06 +0100, Pavel Stehule wrote: > > > > Just a small note - I executed VACUUM ANAL

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Justin Pryzby
On Fri, Feb 10, 2023 at 09:23:11PM +0100, Pavel Stehule wrote: > pá 10. 2. 2023 v 21:18 odesílatel Andres Freund 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 f

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Pavel Stehule
pá 10. 2. 2023 v 21:18 odesílatel Andres Freund napsal: > Hi, > > 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 phys

Re: possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Andres Freund
Hi, 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

possible memory leak in VACUUM ANALYZE

2023-02-10 Thread Pavel Stehule
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