Has anyone investigated having either high, or low urgency queries? A system I'm working on has a constant inflow of data, which has some queries gainst it which might require long sequential scans. I'm not that worried about how long those queries take, just that they don't interfere with other insertions.
This is a bit DSSish, I guess, but I would think it could be managed by nicing processes? Chris -- | Christopher Petrilli | [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match