From: Marti Raudsepp <marti@juffo.org>
To: runner <runner@winning.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning massive UPDATES and GROUP BY's?
Date: Mon, 14 Mar 2011 12:17:34 +0200
Message-ID: <AANLkTimVFRO3FFGo3YXf3tSTVNdXRmLh8STnmJt9eTRr@mail.gmail.com> (raw)
In-Reply-To: <8CDAFB3EE5DFE5F-1AE0-21557@web-mmc-d02.sysops.aol.com>
References: <loom.20110310T163020-437@post.gmane.org>
<AANLkTiks9aTwVyN-JW1Ep2cVoJabBF_fZfkk_43GRcNv@mail.gmail.com>
<loom.20110311T195504-383@post.gmane.org>
<AANLkTi=dGuvB_EuU43CbFUeuaG57-WXvypw+A1WKHhZ8@mail.gmail.com>
<8CDAFB3EE5DFE5F-1AE0-21557@web-mmc-d02.sysops.aol.com>
On Sun, Mar 13, 2011 at 18:36, runner <runner@winning.com> wrote:
> Tried removing the indexes and other constraints just for
> the import but for a noob like me, this was too much to ask. Maybe
> when I get more experience.
pgAdmin should make it pretty easy. Choose each index and constraint,
save the code from the "SQL pane" for when you need to restore it, and
do a right click -> Drop
> Other than being very inefficient, and consuming
> more time than necessary, is there any other down side to importing
> into an indexed table?
Doing so will result in somewhat larger (more bloated) indexes, but
generally the performance impact of this is minimal.
Regards,
Marti
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-performance@postgresql.org
Cc: marti@juffo.org, runner@winning.com
Subject: Re: Tuning massive UPDATES and GROUP BY's?
In-Reply-To: <AANLkTimVFRO3FFGo3YXf3tSTVNdXRmLh8STnmJt9eTRr@mail.gmail.com>
* 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