Hi.
I've tracked down some crashes we are having and produced a test case using
the nasty data. The sample data used to trigger the crash is 6MB in size. It
doesn't crash immediately, instead chewing up CPU for several minutes before
crashing.
http://launchpadlibrarian.net/9501485/crashme.sql
I've only tried reproducing this with latest released Ubuntu packages
(Feisty) for 8.2.5.
Also reported in the Ubuntu bug tracker too:
https://bugs.launchpad.net/ubuntu/+source/postgresql/+bug/144740
--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/