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

Re: is insertion and movement times are correlated to

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Kalle Barck-Holst <carl(at)barck-holst(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: is insertion and movement times are correlated to
Date: 2002-12-09 13:04:58
Message-ID: 1039439098.79804.219.camel@jester (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2002-12-09 at 01:30, Kalle Barck-Holst wrote:
> Hi
> 
> I am doing a research project on real time robotics and wanted to have the postgres as a database to save measurements we aggregate when running our robots.
> 
> A common operation we do is insertion and movements of measurements within tables. But it seams as if insertion and movement times are correlated to the size of the database. Can this be possible? IE inserting into a large database takes longer time than into a small database.

If there are any indexes or constraints, then definitely.  The insert
really doesn't have additional overhead for the size of the DB, but the
work involved for most constraints and indexes do.

-- 
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

pgsql-performance by date

Next:From: Hubert depesz LubaczewskiDate: 2002-12-09 13:05:21
Subject: Re: questions about disk configurations
Previous:From: Adrian 'Dagurashibanipal' von BidderDate: 2002-12-09 12:01:58
Subject: Re: questions about disk configurations

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