Re: [GENERAL] Log messages regarding automatic vacuum and exclusive locks

2013-04-24 Thread jonesd
I'll give using TRUNCATE to clear the tables a try and see what happens. Dominic Jones Quoting Sergey Konoplev gray...@gmail.com: On Tue, Apr 23, 2013 at 8:50 AM, jon...@xmission.com wrote: Good morning. I'm seeing several of the following log messages each morning (for example, there

[GENERAL] Log messages regarding automatic vacuum and exclusive locks

2013-04-23 Thread jonesd
Good morning. I'm seeing several of the following log messages each morning (for example, there were five this morning, spaced approximately one minute apart, with the closest interval between messages being 44 seconds). They're occurring during a daily cycle of deleting all rows from a

Re: [GENERAL] Log messages regarding automatic vacuum and exclusive locks

2013-04-23 Thread Kevin Grittner
jon...@xmission.com jon...@xmission.com wrote: I'm seeing several of the following log messages each morning (for example, there were five this morning, spaced approximately one minute apart, with the closest interval between messages being 44 seconds).  They're occurring during a daily

Re: [GENERAL] Log messages regarding automatic vacuum and exclusive locks

2013-04-23 Thread Sergey Konoplev
On Tue, Apr 23, 2013 at 8:50 AM, jon...@xmission.com wrote: Good morning. I'm seeing several of the following log messages each morning (for example, there were five this morning, spaced approximately one minute apart, with the closest interval between messages being 44 seconds). They're