Am 15.03.2010 12:56, schrieb Magnus Hagander:
On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine<dfontaine@xxxxxxxxxxxx> wrote:
Frank jansen<jansen@xxxxxxxxxxx> writes:
I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib
directory, tried Debians 8.4 backport package with the 8.4 contrib package
and all do the same: Segfault and terminated by Signal 11 :-(
Try 8.4.3, which has some XML crash related fix:
http://developer.postgresql.org/pgdocs/postgres/release-8-4-3.html
Note that 8.4.3 hasn't actually been released yet though - that's the
developer version of the docs.
Expect it out before tomorrow, though ;-)
Thanks for the tip with 8.4.3, its already available at the ftp mirrors :-)
Now with 8.4.3 the scripts work, but only until it has eaten up my
memory (4 gig).
The function above is executed for ~40000 items, with iteration steps of
300 items, every step memery consumption is increasing till the machine
hangs and process dies.
I am now looking into closing the database connection after every
iteration, hoping this helps.
I am bit concerned cause in postgres 8.3.1 it is/was working fine.
Kind regards,
Frank Jansen
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
