Re: Large number of tables slow insert

From: "Loic Petit" <tls(dot)wydd(at)free(dot)fr>
To: scott(dot)marlowe(at)gmail(dot)com
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:31:37
Message-ID: 1775c5ea0808231831m5275ff08y24ea6ef4c7479cf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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...

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-08-24 01:37:39 Re: Large number of tables slow insert
Previous Message Scott Marlowe 2008-08-24 01:18:43 Re: Large number of tables slow insert