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 1775c5ea0808231759x6b43520du4f949dbe25f4b316@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
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)

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