From: Loic Petit <tls.wydd@free.fr>
To: pgsql-performance@postgresql.org
Subject: Re: Large number of tables slow insert
Date: Sat, 23 Aug 2008 18:25:36 +0100
Message-ID: <1775c5ea0808231025u1b5df6c7nd68b1f1f264cc8b2@mail.gmail.com> (raw)
Actually, I've got another test system with only few sensors (thus few
tables) and it's working well (<10ms insert) with all the indexes.
I know it's slowing down my performance but I need them to interogate the
big tables (each one can reach millions rows with time) really fast.
Regards
Loïc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tls.wydd@free.fr
Subject: Re: Large number of tables slow insert
In-Reply-To: <1775c5ea0808231025u1b5df6c7nd68b1f1f264cc8b2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox