Faulting application postgres.exe, version 8.3.3.8160, faulting module
msvcr80.dll, version 8.0.50727.1433, fault address 0x0001e44a.
I have a function that's doing a summary report counting data. It makes
a couple of small temp tables then makes a big temp table. In the query
that makes the big temp table, there's an immutable function that gets
called thousands of times in the execution. In the immutable function,
there was a raise notice for debugging . Without the raise, the query
finishes in about 40sec. With it, the postgres.exe grinds down to about
2% cpu usage and eventually throws the message above. Then I reboot the
machine - nothing responds to control.
After reading of recent win32 network buffer problems, I'm wondering if
this is another one. The context statement is nearly 8k long. The
server is w2k3 on a 3.8ghz P4 with 3g memory on a 10mbit network (don't
ask about the network - it just is and there's nothing I can do about
it). The client is xp pentium M notebook, 2ghz, 1g memory.
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
No comments:
Post a Comment