Re: slow queries on system tables

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Re: slow queries on system tables
Дата
Msg-id 1565963536657-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: slow queries on system tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: slow queries on system tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Well, not exactly.

Values for autovacuum and autoanalyse are Null because I did not configured
them for system tables yet, but I´m doing vacuum manually once a week. My
question now is why those selects varies that way.

Almost all times it spend 20ms but 2 o 3% of the times it spend 500ms, why ?
System tables are not cached ? What is Postgres doing on that time to get
that response times ?
Can I help Postgres on any way ?



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bad Estimate for complex query with JOINS on subselects and OR in where conditions
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Variable constants ?