Leonid Safronie wrote:
Hi, ppl
Is there any way to do SELECTs with different priorities?
The issue is that response time for
these 50 processes is very important unlike for report generation, and
time spent by these processes while report running is unacceptable for
my production environment (response time grows from 1-3 seconds up to
1-2 minutes).
The most important question is why response time drops so much? Does it
look like it's disk I/O that's the problem?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
