Re: Postgresql 'eats' all mi data partition

> [tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> You've definitely got an index-bloat problem on stats_min (the indexes
> are four times the size of the table :-(), and I suspect the same on
> stats_hr, though not quite as bad. What are the datatypes of the
> index columns?

indexes:
stats_min_pkey primary key btree (ip, "start")
stats_min_start btree ("start")
stats_hr_pkey primary key btree (ip, "start")
stats_hr_start btree ("start")

ip is of type "inet" in all tables.
start is of type "timestamp without time zone" in all tables.

> > Hmm, you seem to suggest that we might expect a change in this regard
> > as 7.4 ships. Is that right?
>
> 7.4 should improve matters.

Trouble is, I probably can't give it a try on the production machine
unless I'm sure it won't trash the data, and I don't know of a way to
reproduce the workload on a test setup. :(

Thanks,
--
Tomas Szepe <szepe(at)pinerecords(dot)com>