Re: Large number of tables slow insert - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Large number of tables slow insert
Date
Msg-id dcc563d10808231818l4ad52e58k6b29ba92d6bc51e4@mail.gmail.com
Whole thread Raw
In response to Re: Large number of tables slow insert  ("Loic Petit" <tls.wydd@free.fr>)
Responses Re: Large number of tables slow insert  (dforum <dforums@vieonet.com>)
List pgsql-performance
On Sat, Aug 23, 2008 at 6:59 PM, Loic Petit <tls.wydd@free.fr> 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

pgsql-performance by date:

Previous
From: "Loic Petit"
Date:
Subject: Re: Large number of tables slow insert
Next
From: "Loic Petit"
Date:
Subject: Re: Large number of tables slow insert