Hi,
I have an issue with sporadic slow insert operations with query duration
more than 1 sec while it takes about 50ms in average.
Configuration:
OS: Centos 7.2.151
PostgreSQL: 9.6.3
CPU: Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GHz
Memory: totalusedfree shared buf
Am 22.01.2018 um 11:21 schrieb pavan95:
Could you please explain what antiwraparound autovacuum is?? Is it related
for preventing transactionID wraparound failures?
Yes.
If so does running vacuum
full against the database will suppress this abnormal generation of archive
logs??
Such a va
Hello Sergi,
The size of the database is 24GB.
The output of the above query is :
datid | datname | procpid | usesysid | usename | application_name |
client_addr | client_hostname | client_port | backend_start
|xact_start| query_start
Hello
How big is database?
Please show result of this query: select * from pg_stat_activity where query
like 'autovacuum%';
I think here is running antiwraparound autovacuum. In this case all is normal,
antiwraparound will produce a lot of WAL and this is necessary to continue
database working.
Hi Pallav,
I'm currently on PostgreSQL 9.1. Everything was fine till Dec 27th 2017. But
to my wonder archive logs started to increase from December 28th 2017 till
date.
The configuration parameters were default and everything in the past was
fine with default configuration parameters. I'm facing
OK, thanks a lot.
Regards,
Peter
Från: David Steele [da...@pgmasters.net]
Skickat: den 19 januari 2018 14:41
Till: Magnus Hagander; Joe Conway
Kopia: Svensson Peter; pgsql-performa...@postgresql.org
Ämne: Re: pgaudit and create postgis extension logs a lo
