I just don't get how we are supposed to use LIKE with backslashes in
strings in 8.4. This is particularly vexing, because I have a field
containing UNC paths that I need to search on (and eventually update).

Just wondering...if a query is "waiting", what is it waiting for? Is
this only for locks, or can it be for disk, or a memory buffer? (If
there is a description of the meaning of things in pg_stat_activity
and it's relatives, I'd love a pointer, 'cause I can't seem to find
it.)

in an earlier thread, the following query was submitted:

SELECT COUNT(*) FROM q

and as part of his answer, David Johnson responded

3. Also, you are using a correlated sub-query instead of a LEFT OUTER JOIN

This interests me. How would you rewrite the correlated subquery above
using the outer join?

Thank goodness I'm still in development! I'm trying to use pg_restore with
a dump created with pg_dump. But it keeps failing with segmentation or
general protection faults. My restore command is:

$ sudo -u postgres pg_restore -d mydatabase -j8 mydatabase.dmp

I've now tried five times, and gotten five failures.