[PERFORM] index on partitioned table

Dear Postgres Community, I'm running postgres 8.3 I have a table, partitioned by month -- Table: datadump -- DROP TABLE datadump; CREATE TABLE datadump ( sys_timestamp timestamp without time zone, sys_device_id integer, usefields integer, timedate timestamp without time zone, digital

[PERFORM] plpgsql function running long, but resources consumption is very low

Hi, I'm having serious performance problems with my two plpgsql functions (lots of calculations inside, including distance (lat,long) using earthdistance etc). My problem is: both functions are executing for hours (if not days) but resource consumption is low (I/O, CPU, memory), like 2-5% on