[GENERAL] Cost based SELECT/UPDATE

2005-09-08 Thread Leonid Safronie
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[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)---