Re: Strange Problem

Tim Sailer <tps@unslept.org> writes:
> On 02/11/2016 09:53 AM, Tom Lane wrote:
>> "VACUUM VERBOSE <table>" would likely be informative.

> Ugh. I saw a slew of "suspending truncate due to conflicting lock
> request" scroll up the screen, along with lines like "truncated 4928 to
> 1376 pages" all the say down to "truncated 1376 to 0 pages".

> I'm guessing that my table is now empty for some reason. Sigh.

Well, it was logically empty before, now it's physically empty too.

So what this confirms is that there is *not* a question of uncommitted
transactions or anything like that.  At this point I'd be looking for
client-side problems in your data insertion procedures.

            regards, tom lane