From: Justin Pryzby <pryzby@telsasoft.com>
To: David Wheeler <dwheeler@dgitsystems.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@lists.postgresql.org, Cameron Redpath <credpath@dgitsystems.com>
Subject: Re: Slow planning, fast execution for particular 3-table query
Date: Wed, 6 Nov 2019 16:59:45 -0600
Message-ID: <20191106225945.GE4999@telsasoft.com> (raw)
In-Reply-To: <15855.1572843659@sss.pgh.pa.us> <175BE386-F861-4064-8B5D-93E63BD90F13@dgitsystems.com>
On Mon, Nov 04, 2019 at 03:04:45AM +0000, David Wheeler wrote:
> Postgres version 9.5.19
> Each of the tables has between 3-4 indexes, and all the indexes include tid as first parameter.
On Mon, Nov 04, 2019 at 12:00:59AM -0500, Tom Lane wrote:
> If this *is* the cause, v11 and up have a performance improvement that
> you need:
But note that index definition will be prohibited since:
https://www.postgresql.org/docs/9.6/release-9-6.html
|Disallow creation of indexes on system columns, except for OID columns (David Rowley)
|Such indexes were never considered supported, and would very possibly misbehave since the system might change the system-column fields of a tuple without updating indexes. However, previously there were no error checks to prevent them from being created.
Justin
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: pryzby@telsasoft.com, dwheeler@dgitsystems.com, tgl@sss.pgh.pa.us, credpath@dgitsystems.com
Subject: Re: Slow planning, fast execution for particular 3-table query
In-Reply-To: <20191106225945.GE4999@telsasoft.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