From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lars Bergeson <larsavatar@gmail.com>
cc: Justin Pryzby <pryzby@telsasoft.com>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        pgsql-performance@lists.postgresql.org
Subject: Re: Query is slower with a large proportion of NULLs in several
 columns
In-reply-to: 
 <CAK66RGZ+3eztwfRzgN7ckc-orOzxyd5G5bka=n6RtB5rWm7ZdQ@mail.gmail.com>
References: 
 <CAK66RGYim22Sd8-NvmufcxEQ_P99=UTAyJ9agnwDyEbCiVGEQg@mail.gmail.com>
 <2688019.1640051519@sss.pgh.pa.us>
 <CAK66RGbd8n46xEp3fTKOa3pO3eC=NT8tEHHZYjuNZq4Y0SQHTw@mail.gmail.com>
 <20211221045138.GZ17618@telsasoft.com> <2704544.1640062888@sss.pgh.pa.us>
 <CAKFQuwZ==D+f656wsZcctpChQ2xWx5t2fjEhr8+VQWCSCWaWgQ@mail.gmail.com>
 <2707817.1640064786@sss.pgh.pa.us> <20211221211337.GB17618@telsasoft.com>
 <CAK66RGZ+3eztwfRzgN7ckc-orOzxyd5G5bka=n6RtB5rWm7ZdQ@mail.gmail.com>
Comments: In-reply-to Lars Bergeson <larsavatar@gmail.com>
	message dated "Tue, 21 Dec 2021 14:53:20 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <166328.1640128072.1@sss.pgh.pa.us>
Date: Tue, 21 Dec 2021 18:07:52 -0500
Message-ID: <166329.1640128072@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/166329.1640128072%40sss.pgh.pa.us>
Precedence: bulk

Lars Bergeson <larsavatar@gmail.com> writes:
> I'm running PostgreSQL under AWS Aurora, and I didn't set it up or install
> it, so I'm not sure about the OS version.

Oh!  Aurora is not Postgres.  My admittedly-not-well-informed
understanding is that they stuck a Postgres front end on their
existing storage engine, so it's not surprising if storage-level
behaviors are quite different from stock Postgres.

			regards, tom lane