Re: degradation in performance

From: Martin Knipper <knipper(at)mk-os(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: degradation in performance
Date: 2004-09-21 11:32:46
Message-ID: 4150115E.3080307@mk-os.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Am 21.09.2004 13:27 schrieb Alain Reymond:

>
> Do you have any idea how I can improve speed - apart from splitting
> the table every 2 or 3 years which is the the aim of a database!
>

Drop the index before you insert the data and recreate it afterwards.
Use the "copy from ..." command instead of "insert into".

Greetings,

Martin

--
Martin Knipper
www : http://www.mk-os.de
Mail : knipper(at)mk-os(dot)de

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2004-09-21 12:25:16 Re: degradation in performance
Previous Message Alain Reymond 2004-09-21 11:27:43 degradation in performance