From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Lars Bergeson <larsavatar(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Query is slower with a large proportion of NULLs in several columns |
Date: | 2021-12-22 00:45:06 |
Message-ID: | CAKFQuwbq9s7X1nJOk+dpi1qGvPjgEc58UsmcBU1EaSFQY_qOfw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, Dec 21, 2021 at 4:07 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Lars Bergeson <larsavatar(at)gmail(dot)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.
>
>
I do wish Amazon would be more considerate and modify what version()
outputs to include "AWS Aurora" somewhere in the human readable string.
Though the lack really isn't an excuse for reports of this nature to omit
such a crucial hardware/hosting detail. The rest of the problem statement,
even with the "newbie to PostgreSQL" qualifier, was written well enough I
hadn't really considered that it would be anything but stock PostgreSQL on
a personal VM setup for testing.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Zbigniew Kostrzewa | 2021-12-22 15:34:19 | WAL files keep piling up |
Previous Message | Tom Lane | 2021-12-21 23:07:52 | Re: Query is slower with a large proportion of NULLs in several columns |