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

From tls.wydd@free.fr
Subject Re: Large number of tables slow insert
Date
Msg-id 1219520134.48b0668645ce4@imp.free.fr
Whole thread Raw
In response to Re: Large number of tables slow insert  (DiezelMax <max@nts.biz.ua>)
Responses Re: Large number of tables slow insert  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
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.

> Each INDEX create a delay on INSERT. Try to measure performance w/o any
> indexes.
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

Regards

Loïc



pgsql-performance by date:

Previous
From: DiezelMax
Date:
Subject: Re: Large number of tables slow insert
Next
From: "Loic Petit"
Date:
Subject: Re: Large number of tables slow insert