From: Martin Knipper <knipper@mk-os.de>
To: pgsql-sql@postgresql.org
Subject: Re: degradation in performance
Date: Tue, 21 Sep 2004 13:32:46 +0200
Message-ID: <4150115E.3080307@mk-os.de> (raw)
In-Reply-To: <41502C4F.15411.6617D37@localhost>
References: <41502C4F.15411.6617D37@localhost>
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@mk-os.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: knipper@mk-os.de
Subject: Re: degradation in performance
In-Reply-To: <4150115E.3080307@mk-os.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox