Derrick,
> Production database that is hosted remotely, accessed with pgAdminIII.
> When I INSERT records into a table (only 500 or so) it never completes
> (I've waited for 30 minutes before). It will take a transaction of up to
> 200 statements, but it takes 3-5 minutes.
This has got to be something about how pgAdmin handles batch inserts. I
suggest trying the pgAdmin mailing list.
--
Josh Berkus
Aglio Database Solutions
San Francisco