Skip site navigation (1) Skip section navigation (2)

Re: Large number of tables slow insert

From: tls(dot)wydd(at)free(dot)fr
To: DiezelMax <max(at)nts(dot)biz(dot)ua>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Large number of tables slow insert
Date: 2008-08-23 19:35:34
Message-ID: 1219520134.48b0668645ce4@imp.free.fr (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

Regards

Loïc



In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-08-23 23:49:58
Subject: Re: Large number of tables slow insert
Previous:From: Loic PetitDate: 2008-08-23 17:25:36
Subject: Re: Large number of tables slow insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group