On Sat, Aug 23, 2008 at 6:59 PM, Loic Petit <[EMAIL PROTECTED]> wrote: > 1 table contains about 5 indexes : timestamp, one for each sensor type - 3, > and one for packet counting (measures packet dropping) > (I reckon that this is quite heavy, but a least the timestamp and the values > are really usefull)
But what's the update rate on these indexes and tables? I'm wondering if you're not vacuuming aggresively enough to keep up with bursty update patterns -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance