Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.
Дата
Msg-id 20220323131921.GR28503@telsasoft.com
обсуждение исходный текст
Ответ на Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.  (Lars Aksel Opsahl <Lars.Opsahl@nibio.no>)
Ответы Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.  (Lars Aksel Opsahl <Lars.Opsahl@nibio.no>)
Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.  (Lars Aksel Opsahl <Lars.Opsahl@nibio.no>)
Список pgsql-performance
Дерево обсуждения 
On Wed, Mar 23, 2022 at 09:44:09AM +0000, Lars Aksel Opsahl wrote:
> Why is temp tables with no indexes much faster system tables with indexes ?

I think the "temp table" way is accidentally faster due to having no
statistics, not because it has no indexes.  If you run ANALYZE, you may hit the
same issue (or, maybe you just need to VACUUM ANALYZE your system catalogs).

-- 
Justin

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

Предыдущее
От: Lars Aksel Opsahl
Дата:
Сообщение: Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view.
Следующее
От: Shai Shapira
Дата:
Сообщение: High process memory consumption when running sort