Re: Large number of tables slow insert

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Loic Petit" <tls(dot)wydd(at)free(dot)fr>
Cc: max(at)nts(dot)biz(dot)ua, pgsql-performance(at)postgresql(dot)org
Subject: Re: Large number of tables slow insert
Date: 2008-08-24 01:18:43
Message-ID: dcc563d10808231818l4ad52e58k6b29ba92d6bc51e4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Aug 23, 2008 at 6:59 PM, Loic Petit <tls(dot)wydd(at)free(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Loic Petit 2008-08-24 01:31:37 Re: Large number of tables slow insert
Previous Message Loic Petit 2008-08-24 00:59:16 Re: Large number of tables slow insert