Yes, the additional bitmap could certainly explain the increase.
Thanks,
Mike
-Original Message-
From: Justin Pryzby [mailto:pry...@telsasoft.com]
Sent: Friday, December 06, 2019 6:29 PM
To: Mike Schanne
Cc: pgsql-performa...@postgresql.org
Subject: Re: unexpected result for wastedbytes
...@emolecules.com]
Sent: Friday, December 06, 2019 1:42 PM
To: Mike Schanne
Cc: pgsql-performa...@postgresql.org
Subject: Legal disclaimers on emails to this group
(I've changed the original subject, "autovacuum locking question", of the
sender's email so as not to hijack that thread.)
On Thu, D
Hi all,
This question is somewhat related to my previous question:
https://www.postgresql.org/message-id/0871fcf35ceb4caa8a2204ca9c38e330%40USEPRDEX1.corp.kns.com
I was attempting to measure the benefit of doing a VACUUM FULL on my database.
I was using the query found here:
.
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Thursday, December 05, 2019 6:55 PM
To: Mike Schanne
Cc: pgsql-performa...@postgresql.org
Subject: Re: autovacuum locking question
On Thu, Dec 5, 2019 at 5:26 PM Mike Schanne
mailto:mscha...@kns.com>> wrote:
Hi,
I am investigating a perfo
/
Thanks,
Mike
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, December 05, 2019 6:49 PM
To: Mike Schanne
Cc: 'pgsql-performa...@postgresql.org'
Subject: Re: autovacuum locking question
Mike Schanne writes:
> I am investigating a performance problem in