Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group