>From: Tom Lane <tgl@xxxxxxxxxxxxx> 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
