[rt-devel] RT speed

[Vivek Khera]

>>>>> "m" == mwatson  <Mat> writes:

m> are from large queries being run, which in turn makes updates
m> running after them lock the tables, which makes queries being run
m> after that stall waiting for the unlock.. and no index seems to

A prime reason to move to Postgres.  The concurrency is *much* better
since it does row-level locking, and a select query doesn't block an
insert query and vice versa (except when you explicitly lock the
table).

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/