Re: Log level of logical decoding

From: Francesco Nidito <frnidito(at)live(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Log level of logical decoding
Date: 2018-12-07 11:24:26
Message-ID: VI1PR0902MB2127E26E0BA578F25E274EB3A6AA0@VI1PR0902MB2127.eurprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi All,

One week ago I posted the following question in the general list but probably the developers' list is a better place for such question.

Thanks in advance (again)!

Francesco

________________________________
From: Francesco Nidito
Sent: 30 November 2018 15:10
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Log level of logical decoding

Hi All,

With reference to an old thread (https://www.postgresql.org/message-id/8307.1419439826%40sss.pgh.pa.us) our application polls the database instance periodically to check if there are new transaction in the WAL waiting to be processed. As a consequence of this, our log file is full of messages like

2018-11-30 10:37:29 UTC LOG: starting logical decoding for slot "test_slot"
2018-11-30 10:37:29 UTC DETAIL: streaming transactions committing after 4AC/41D5F950, reading WAL from 4AC/41C16868
2018-11-30 10:37:29 UTC STATEMENT:
SELECT * FROM pg_logical_slot_peek_changes('test_slot', NULL, NULL,
'include-timestamp', '1', 'skip-empty-xacts', '1')

As those logs are of dubious utility, and following the comment of Tom in the last email of the old thread, I would like to ask why this message is a LOG and not a DEBUG and if there is any plan to make them DEBUG?

Thanks a lot in advance!

Francesco

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Wilson 2018-12-07 12:39:50 != ANY(array) does not behave as expected
Previous Message s400t 2018-12-07 08:28:18 Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2018-12-07 13:55:57 Re: WIP: Avoid creation of the free space map for small tables
Previous Message Ashutosh Bapat 2018-12-07 11:14:14 Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0