Re: Zero throughput on a query on a very large table.

Поиск
Список
Период
Сортировка
От ldh@laurent-hasson.com
Тема Re: Zero throughput on a query on a very large table.
Дата
Msg-id BN6PR15MB1185E4664C980E40D1450B06859B0@BN6PR15MB1185.namprd15.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Zero throughput on a query on a very large table.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Zero throughput on a query on a very large table.
Список pgsql-performance
Дерево обсуждения

Sorry :) When i look at the "SQL" tab in PGAdmin when i select the index in the schema browser. But you are right that /d doesn't show that.

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Friday, January 25, 2019 1:34:01 PM
To: ldh@laurent-hasson.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Zero throughput on a query on a very large table.
 
"ldh@laurent-hasson.com" <ldh@laurent-hasson.com> writes:
> Also, the original statement i implemented did not have all of that. This is the normalized SQL that Postgres now gives when looking at the indices.

[ squint... ]  What do you mean exactly by "Postgres gives that"?
I don't see any redundant COLLATE clauses in e.g. psql \d.

                        regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Zero throughput on a query on a very large table.
Следующее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: Re: Zero throughput on a query on a very large table.