The following bug has been logged online:

Bug reference: 2676
Logged by: Luke McFarlane
Email address: luke@fisheye.com.au
PostgreSQL version: 8.1.4
Operating system: Mandriva Linux 2006.0 Kernel 2.6.15.7 SMP
Description: postmaster using 100% cpu from odbc disconnect
Details:

Hi

User connects to database via Visual Basic & ODBC. During his session VB
crashed. The query that was executed was selecting all records from a simple
view (approx 20,000 records). The query has been running for 68 minutes,
postmaster on 100%. If I run the query manually it takes literally
milliseconds to complete.

When I did a netstat -nt I did not see any active connection from the
offending remote user.

Any input would be appreciated.

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

"Luke McFarlane" <luke@fisheye.com.au> writes:
> User connects to database via Visual Basic & ODBC. During his session VB
> crashed. The query that was executed was selecting all records from a simple
> view (approx 20,000 records). The query has been running for 68 minutes,
> postmaster on 100%.

Tried to reproduce this by killing psql mid-query ... no luck.

Do you want to gdb that backend process and see what it's doing?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend