"Luke McFarlane" <[EMAIL PROTECTED]> 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