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:37:39
Message-ID: dcc563d10808231837h75f2fd7ex24450190e6573a74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Aug 23, 2008 at 7:31 PM, Loic Petit <tls(dot)wydd(at)free(dot)fr> wrote:
> One sensor (so one table) sends a packet each seconds (for 3000 sensors).
> => So we have : 1 insert per second for 3000 tables (and their indexes).
> Hopefully there is no update nor delete in it...

Wait, I'm confused, I thought you said earlier that for the big test
the tables only had a few rows. I'd expect it to be quite a bit
bigger if you're inserting into a table once a second for any period.

In response to

Browse pgsql-performance by date

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