Re: slow queries on system tables - Mailing list pgsql-general

From PegoraroF10
Subject Re: slow queries on system tables
Date
Msg-id 1565963536657-0.post@n3.nabble.com
Whole thread Raw
In response to Re: slow queries on system tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: slow queries on system tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bad Estimate for complex query with JOINS on subselects and OR in where conditions
Next
From: Luca Ferrari
Date:
Subject: Re: Variable constants ?