Postgres Pro
Downloads
Home   >   mailing lists

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

From Loic Petit
Subject Re: Large number of tables slow insert
Date
Msg-id 1775c5ea0808231831m5275ff08y24ea6ef4c7479cf@mail.gmail.com
Whole thread Raw
In response to Large number of tables slow insert  ("Loic Petit" <tls.wydd@free.fr>)
Responses Re: Large number of tables slow insert  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view
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...

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Large number of tables slow insert
Next
From: "Scott Marlowe"
Date:
Subject: Re: Large number of tables slow insert