On 10/12/2013, at 20:55, Jeff Janes wrote:
On Tue, Dec 10, 2013 at 8:23 AM, Herouth Maoz hero...@unicell.co.il wrote:
Hello.
I have one particular table with very specialized use. I am sending messages
to some partner. The partner processes them asynchronously, and then returns
the
On 10/12/2013, at 20:55, Kevin Grittner wrote:
Herouth Maoz hero...@unicell.co.il wrote:
The problem starts when our partner has some glitch, under high
load, and fails to send back a few hundred thousand reports. In
that case, the table grows to a few hundred records, and they are
not
Herouth Maoz hero...@unicell.co.il wrote:
On 10/12/2013, at 20:55, Kevin Grittner wrote:
First, make sure that you are on the latest minor release of
whatever major release you are running. There were some serious
problems with autovacuum's table truncation when a table was
used as a queue
On Wed, Dec 11, 2013 at 1:49 AM, Herouth Maoz hero...@unicell.co.il wrote:
On 10/12/2013, at 20:55, Jeff Janes wrote:
On Tue, Dec 10, 2013 at 8:23 AM, Herouth Maoz hero...@unicell.co.ilwrote:
Hello.
I have one particular table with very specialized use. I am sending
messages to some
Hello.
I have one particular table with very specialized use. I am sending messages to
some partner. The partner processes them asynchronously, and then returns the
status report to me. The table is used to store a serialized version of the
message object, together with a few identifiers,
Herouth Maoz hero...@unicell.co.il wrote:
The problem starts when our partner has some glitch, under high
load, and fails to send back a few hundred thousand reports. In
that case, the table grows to a few hundred records, and they are
not deleted until they hit their expiry date, at which
On Tue, Dec 10, 2013 at 8:23 AM, Herouth Maoz hero...@unicell.co.il wrote:
Hello.
I have one particular table with very specialized use. I am sending
messages to some partner. The partner processes them asynchronously, and
then returns the status report to me. The table is used to store a