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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > Regards Loïc
