Re: [INTERNET] Re: auto vacuum question

2023-08-29 Thread Jerry Sievers
Alan Stange writes: > On 8/28/23 18:35, Jerry Sievers wrote: > >> Adrian Klaver writes: >> >>> On 8/28/23 13:06, Alan Stange wrote: >>> All, We recently changed the name of the superuser role in our database, >> My take on this, is that the *postmaster* user is perhaps the one that >>

Re: [INTERNET] Re: auto vacuum question

2023-08-29 Thread Alan Stange
On 8/28/23 18:35, Jerry Sievers wrote: > Adrian Klaver writes: > >> On 8/28/23 13:06, Alan Stange wrote: >> >>> All, >>> We recently changed the name of the superuser role in our database, > My take on this, is that the *postmaster* user is perhaps the one that > the OP cut privileges on, and thus

Re: auto vacuum question

2023-08-28 Thread Jerry Sievers
Adrian Klaver writes: > On 8/28/23 13:06, Alan Stange wrote: > >> All, >> We recently changed the name of the superuser role in our database, My take on this, is that the *postmaster* user is perhaps the one that the OP cut privileges on, and thus the launcher is (now) spawning workers with less

Re: [INTERNET] Re: auto vacuum question

2023-08-28 Thread Adrian Klaver
On 8/28/23 13:19, Alan Stange wrote: On 8/28/23 16:11, Adrian Klaver wrote: On 8/28/23 13:06, Alan Stange wrote: All, Are you sure that is coming from autovacuum? What are the log lines preceding the WARNING? What is the complete warning line? Thank you for your quick response. The pref

Re: [INTERNET] Re: auto vacuum question

2023-08-28 Thread Alan Stange
On 8/28/23 16:11, Adrian Klaver wrote: > On 8/28/23 13:06, Alan Stange wrote: >> All, >> >> We recently changed the name of the superuser role in our database, and >> then noticed some issues with the autovacuum processes.  We are running >> 15.3, and had a login role, lets call it 'red', which had

Re: auto vacuum question

2023-08-28 Thread Adrian Klaver
On 8/28/23 13:06, Alan Stange wrote: All, We recently changed the name of the superuser role in our database, and then noticed some issues with the autovacuum processes.  We are running 15.3, and had a login role, lets call it 'red', which had the superuser attribute assigned to it.   This was t

auto vacuum question

2023-08-28 Thread Alan Stange
All, We recently changed the name of the superuser role in our database, and then noticed some issues with the autovacuum processes.  We are running 15.3, and had a login role, lets call it 'red', which had the superuser attribute assigned to it.   This was the original owner/creator of all the da

Re: vacuum question

2018-09-30 Thread Stephen Frost
Greetings, * Torsten Förtsch (tfoertsch...@gmail.com) wrote: > I have a table with a really small number of rows, usually about 1500, > sometimes may be up to 5000. The usage pattern of that table is such that > rows are inserted and kept for a while, mostly seconds or minutes but > theoretically

vacuum question

2018-09-30 Thread Torsten Förtsch
Hi, I have a table with a really small number of rows, usually about 1500, sometimes may be up to 5000. The usage pattern of that table is such that rows are inserted and kept for a while, mostly seconds or minutes but theoretically up to 1 year. After that they are deleted. No updates, just inser