Re: 8.2 Autovacuum BUG ?

Hi all, Regarding this archive log generation found one observation. A table named abc_table id found to be archived every 9'th and 39'th minute. We are able to find number of tuples deleted from the pg_stat_user_tables view. But to my wonder the number of tuple inserts are shown 0. How can

Re: 8.2 Autovacuum BUG ?

On Tue, Jan 30, 2018 at 10:55 AM, pavan95 wrote: > Hello all, > > Will a sudden restart(stop/start) of a postgres database will generate this > huge WAL? Shouldn't

Re: 8.2 Autovacuum BUG ?

Hello all, Will a sudden restart(stop/start) of a postgres database will generate this huge WAL? Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: 8.2 Autovacuum BUG ?

On Jan 26, 2018 6:02 AM, "Pavan Teja" wrote: On Jan 26, 2018 3:00 AM, "Alvaro Herrera" wrote: pavan95 wrote: > Hi Álvaro Herrera, > > Please find the corresponding output: OK, these settings look pretty normal, so they don't explain your

Re: 8.2 Autovacuum BUG ?

Hi Álvaro Herrera, Please find the corresponding output: *1).select name, setting, source, sourcefile, sourceline from pg_settings where name like '%vacuum%'; * -[ RECORD 1 ] name | autovacuum setting| on source | configuration file

Re: 8.2 Autovacuum BUG ?

Please show the output of these queries in the relevant databases: select name, setting, source, sourcefile, sourceline from pg_settings where name like '%vacuum%'; select oid::regclass, reloptions from pg_class where reloptions is not null; -- Álvaro Herrera

Re: 8.2 Autovacuum BUG ?

On Wed, Jan 24, 2018 at 7:48 AM, Pavan Teja wrote: > > > Yes, but why doing vacuum freeze of a table is causing a rapid > ​archiving?? > Any idea?? > > IIUC ​Freezing involves physically altering those pages that are not frozen to make them frozen. Those

Re: 8.2 Autovacuum BUG ?

On Jan 24, 2018 7:57 PM, "Claudio Freire" wrote: On Wed, Jan 24, 2018 at 8:50 AM, pavan95 wrote: > Hello all, > > One more interesting observation made by me. > > I have ran the below query(s) on production: > > SELECT > relname, >

Re: 8.2 Autovacuum BUG ?

On Wed, Jan 24, 2018 at 8:50 AM, pavan95 wrote: > Hello all, > > One more interesting observation made by me. > > I have ran the below query(s) on production: > > SELECT > relname, > age(relfrozenxid) as xid_age, > pg_size_pretty(pg_table_size(oid)) as

Re: 8.2 Autovacuum BUG ?

On Wed, Jan 24, 2018 at 3:54 AM, pavan95 wrote: > Hi Claudio, > > We didn't configure any replication to our production server. Which strace > are you talking about? > This one: https://linux.die.net/man/1/strace You can attach it to a process (assuming you have

Re: 8.2 Autovacuum BUG ?

Hi Claudio, We didn't configure any replication to our production server. Which strace are you talking about? We did a keen observation that only at the time 9'th minute of the hour and 39'th minute of the hour the so called archive logs are generated even when nobody is connecting from

Re: 8.2 Autovacuum BUG ?

Hello, Is there any way to check, how many transactions happened till date from the point the database created and started accepting transactions ? The reason for this doubt is to find whether my database has crossed 2 million transactions or not. Strangely had an interesting observation, when

Re: 8.2 Autovacuum BUG ?

Am 23.01.2018 um 16:20 schrieb Pavan Teja: Hi David, If it's yes what needs to be done in order to stabilize this issue?? Don't top-post ;-) You can't prevent the generation of wal's (apart from using unlogged tables, but i'm sure, that will be not your solution.) Regards, Andreas --

Re: 8.2 Autovacuum BUG ?

Hi David, If it's yes what needs to be done in order to stabilize this issue?? Thanks in advance. Regards, Pavan On Jan 23, 2018 8:15 PM, "David G. Johnston" wrote: > On Tue, Jan 23, 2018 at 7:39 AM, Pavan Teja > wrote: > >> "

Re: 8.2 Autovacuum BUG ?

Yes so many wals are continuing to be produced. Deleting the wals after a backup of the database. Yes archiving mode is on. And the warning message in log file is " checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter". My doubt is previously

Re: 8.2 Autovacuum BUG ?

Hi Andreas, Yes I'm facing problem because of this huge WAL(archive log) generation. As it is seriously consuming a lot of disk space almost close to 50GB per day even if the DML's don't have that impact in this WAL generation. Previously the archive_log size is nearly 2 to 3 GB a day. Now with