On 2008-09-09 05:07, Kashmir wrote:
> querying data from august 1st - august 25:
> Total runtime: 26762.999 ms
>
> now querying data from august 1st - august 29:
> Total runtime: 20123.584 ms
>
> Any idea why these analysises look so different? the only
> query-difference is the 2nd timestamp
hello pg'lers,
we are facing a puzzle, and was wondering if you could advise?
db has been just vacuumed:
table as:
CREATE TABLE bigdb.t_rrddata
(
f_insrt_dt timestamptz,
f_timestamp int4 NOT NULL,
f_site_a text NOT NULL,
f_site_b text NOT NULL,
f_probe text NOT NULL,
f_ipv varchar N
