Re: BUG #7914: pg_dump aborts occasionally - Mailing list pgsql-bugs

From Shin-ichi MORITA
Subject Re: BUG #7914: pg_dump aborts occasionally
Date
Msg-id 1DC703B050534F4EBAF5F0E46E2A1478@25a038note
Whole thread Raw
In response to Re: BUG #7914: pg_dump aborts occasionally  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> I tried nice'ing pg_dump without any success in making it bloat memory.
> I'm suspicious that there's something Windows-specific in what you're
> seeing, because it's fairly hard to credit that nobody's seen this
> problem in the ten years or so that libpq has been doing it like that.
>
> Can anyone else manage to reproduce a similar behavior?

I tried several other conditions as well including Linux,
32bit OS, non-virtual environments, and so on.

However, so far, I have not been able to reproduce this issue yet
with conditions other than the following combination:

Hypervisor: VMware vSphere Hypervisor 5.1
Allocated vCPUs: 1
Allocated Memory: more than 2GB
OS: Windows Server 2012 or 2008R2 (64bit)
Run pg_dump under high load
or run pb_dump with the Low priority using Windows Task Manager

This might be a rare case.

By the way, we have already worked around this issue by adding --inserts.

Thank you.

Best regards,
Shin-ichi MORITA

pgsql-bugs by date:

Previous
From: jakubkania@onet.pl
Date:
Subject: BUG #7926: column 2 has type numeric(20, 2) in non-recursive term but type numeric overall
Next
From: sivakumar.og@gmail.com
Date:
Subject: BUG #7927: MEDIAN FUNCTION IN POSTGRE REQUIRED