How does postgresql deal with locking when one has a large select query running
on a > 700,000 row table, when there are inserts pending for that table.
I have an application that does a _lot_ of inserts, and a frontend that
makes large long laborious select queries on the same tables.
MySQL has the INSERT DELAYED which allows batch processing of inserts and
allows clients to receive and instant "OK" when doing inserts.
- Simon
--
Simon Attwell
Systems Engineer
Berbee
5520 Research Park Drive
Madison, WI 53711
attwell(at)berbee(dot)com
Berbee... putting the E in business.