-----BEGIN PGP SIGNED MESSAGE-----
On 12/12/2011 07:55 PM, Andres Freund wrote:
> On Monday, December 12, 2011 07:48:01 PM Tom Lane wrote:
>> Andres Freund <andres(at)anarazel(dot)de> writes:
>>> On Monday, December 12, 2011 09:29:23 AM Heikki Linnakangas wrote:
>>>> Revert the behavior of inet/cidr functions to not unpack the arguments.
>>> Whats the plan to handle this wrt a stable release?
>> I was wondering whether we shouldn't revert the original patch
>> altogether in the back branches. As far as I'd heard, there were
>> no reports of the previous coding causing real trouble, and this
>> episode demonstrates that there is a possibility to make things
>> worse rather than better. I think maybe we'd better treat this
>> change as something to make in HEAD only.
This is a bug that really qualifies for an early 9.1.3.
A simple create index on an inet column almost crashed our production
server and everything got very unresponsive for a while.
The process running the create index grew to over 24GB in a matter of a
few minuttes. We managed to kill the process at the last moment before
going empty for cached memory and swap.
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
-----END PGP SIGNATURE-----
In response to
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2011-12-12 21:22:52|
|Subject: pgsql: Move BKP_REMOVABLE bit from individual WAL records to WAL pageh|
|Previous:||From: Andres Freund||Date: 2011-12-12 18:55:36|
|Subject: Re: pgsql: Revert the behavior of inet/cidr functions to not unpack the arg|