From: Mike Sofen <msofen@runbox.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
To: 'Laurenz Albe' <laurenz.albe@cybertec.at>
Cc: 'MingJu Wu' <mingjuwu0505@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: RE: Partial index creation always scans the entire table
Date: Sun, 16 Feb 2020 16:43:10 -0800
Message-ID: <05fc01d5e52b$3c3d1c50$b4b754f0$@runbox.com> (raw)
In-Reply-To: <19549.1581867005@sss.pgh.pa.us>
References: <CAKVFrvFY-f7kgwMRMiPLbPYMmgjc8Y2jjUGK_Y0HVcYAmU6ymg@mail.gmail.com>
<43b329d274c3535c75d2fbd6912b5ae8e3e51582.camel@cybertec.at>
<19549.1581867005@sss.pgh.pa.us>
>From: Tom Lane <tgl@sss.pgh.pa.us> Sent: Sunday, February 16, 2020 7:30
AM
>I've seen people try to do this before. I wonder if the manual page about
partial indexes should explicitly say "don't do that".
> regards, tom lane
Yes please (seriously). The utter beauty of Postgres is the flexibility and
power that its evolutionary path has allowed/created. The tragic danger is
that the beauty is fairly easy to misapply/misuse. Caveats in the
documentation would be very beneficial to both seasoned practitioners and
newcomers - it is quite challenging to keep up with everything Postgres and
the documentation is where most of us turn for guidance.
And thank you Tom (and others), for your willingness to share these (and
many, many other) insights - it is so powerful when facts connect with
database reality.
Mike Sofen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: msofen@runbox.com, tgl@sss.pgh.pa.us, laurenz.albe@cybertec.at, mingjuwu0505@gmail.com, pgsql-performance@lists.postgresql.org
Subject: RE: Partial index creation always scans the entire table
In-Reply-To: <05fc01d5e52b$3c3d1c50$b4b754f0$@runbox.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox