From: dev@archonet.com
To: val@webtribe.net
Cc: pgsql-sql@postgresql.org
Subject: Re: which will be faster? w/ or w/o indices
Date: Fri, 7 Feb 2003 09:36:54 -0000 (GMT)
Message-ID: <1064.192.168.1.16.1044610614.squirrel@mainbox.archonet.com> (raw)
In-Reply-To: <20030207080420.2131718332@cheetah.webtribe.net>
References: <20030207080420.2131718332@cheetah.webtribe.net>
> 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?
Can't really say without testing - it'll depend on the size of the various
tables, X and Y disk speeds etc. The only suggestion I can make is to try
an EXPLAIN (Reference manual, SQL commands) with and without
ENABLE_SEQSCAN off (Admin guide ch 3.2).
- Richard Huxton
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: dev@archonet.com, val@webtribe.net
Subject: Re: which will be faster? w/ or w/o indices
In-Reply-To: <1064.192.168.1.16.1044610614.squirrel@mainbox.archonet.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