Re: is insertion and movement times are correlated to

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: is insertion and movement times are correlated to
Дата
Msg-id 1039439098.79804.219.camel@jester
обсуждение исходный текст
Ответ на is insertion and movement times are correlated to the size of the database?  ("Kalle Barck-Holst" <carl@barck-holst.com>)
Список 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
measurementswe 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
movementtimes are correlated to the size of the database. Can this be possible? IE inserting into a large database
takeslonger 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@rbt.ca>

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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Adrian 'Dagurashibanipal' von Bidder
Дата:
Сообщение: Re: questions about disk configurations
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Speeding up aggregates