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 q
I apologize for the legalese; as others have suggested it’s corporate IT policy
and I have no control over it. I certainly intended no offense to the
community here. I will use my personal email for future inquiries on this
mailing list.
Thanks,
Mike
From: Craig James [mailto:cja...@emolecul
On Fri, Nov 29, 2019 at 11:06 AM Florian Philippon <
florian.philip...@doctolib.com> wrote:
>
> We tried another solution: we loaded a minimal schema (without indexes and
> constraints) on the subscriber and created the subscription. The initial
> copy phase was way faster (a few hours). Then we c
>
> There is a specific search query I am running to get list of Documents and
> their metadata from several table in the DB.
> We are running Postgres 9.6.9 on Amazon RDS (db.m5.4xlarge instance)
>
> Our current DB consists of 500GB of data and indexes. Most of the rows in
> table are consist of 4
