Kevin Grittner wrote:

Applied with trivial editing, mostly from a pgindent run against
modified files.
Applied back as far as 9.0. Before that code didn't match well
enough for it to seem safe to apply without many hours of
additional testing.

I have confirmed occurences of this problem at least as far back as
9.0 in the wild, where it is causing performance degradation severe
enough to force users to stop production usage long enough to
manually vacuum the affected tables. The use case is a lot like
what Jan described, where PostgreSQL is being used for high volume
queuing. When there is a burst of activity which increases table
size, and then the queues are drained back to a normal state, the
problem shows up.


Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
postedJan 23, '13 at 7:50p
activeJan 23, '13 at 7:50p

1 user in discussion

Kevin Grittner: 1 post



site design / logo © 2021 Grokbase