[GENERAL] Q: Table scans on set difference

2006-07-14 Thread G. Ralph Kuntz, MD
What's happening here? I have two tables, encounter_properties_table with about 10 rows and xfiles with about 50 rows. The structures of these tables is as follows: Table "public.encounter_properties_table" Column | Type | Modifiers +-

[GENERAL] Repost: Problem with pg_ctl register -w

2006-04-29 Thread G. Ralph Kuntz, MD
I posted this to pgsql-admin but got no replies.   I am trying to add the -w option to the Windows NT service startup so that the service is really running before it returns (I have another service - tomcat - that depends on it).  I can add the -w, but when I try to start the postgresql serv