[GENERAL] Cost based SELECT/UPDATE

2005-09-08 Thread Leonid Safronie
minutes? Results differ, but in range 30-120 secs... Now looking whether some kind of RAID can improve my situation... (workaround i'm currently using is COPY to another server, then SELECT from it, but this does not work if report period includes, e.g. current day) -- Leonid Safronie DIAS-RIPE

[GENERAL] Cost based SELECT/UPDATE

2005-09-07 Thread Leonid Safronie
grows from 1-3 seconds up to 1-2 minutes). Is there any way to give different priorities to different queries/transactions, as it's done for VACUUMing (vacuum_cost_* options in config file)? -- Leonid Safronie DIAS-RIPE ---(end of broadcast)--- TIP 5