From: val@webtribe.net
To: pgsql-sql@postgresql.org
Subject: which will be faster? w/ or w/o indices
Date: Fri, 7 Feb 2003 08:04 +0000
Message-ID: <20030207080420.2131718332@cheetah.webtribe.net> (raw)
I understand that if you are importing data into the database
that this will go faster if there are no indices against the
target table.
If I want to run this statement:
INSERT INTO table_a SELECT * from table_b WHERE value_1 BETWEEN
X AND Y;
is it best to do that with or without indices?
AND, if I want to run this statement:
DELETE FROM table_B WHERE value_1 BETWEEN X AND Y;
is it best to do that with or without indices?
We are using v 7.2.1 on a Sun E4500.
TIA,
val
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: val@webtribe.net
Subject: Re: which will be faster? w/ or w/o indices
In-Reply-To: <20030207080420.2131718332@cheetah.webtribe.net>
* 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