Answering my own question

From: gerry(dot)smit(at)lombard(dot)ca
To: pgsql-novice(at)postgresql(dot)org
Subject: Answering my own question
Date: 2002-05-15 17:37:56
Message-ID: OF2BE297D0.DD69DFF6-ON85256BBA.0060CE28@lombard.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I found, on http://www.argudo.org/postgresql/soft-tuning-10.html my
answer. (Excellent site btw) What I need to do is prefix my SELECT
statements for this table with the statement :

SET enable_seqscan='false';

as in :

SET enable_seqscan='false';SELECT * FROM pol_xref_d WHERE policy_no=1200079
ORDER BY sequence;

This change makes the response sub-second , a great improvement over the
11+ seconds we're currently experiencing.

I'ld love any explanation of why the Query plan was going sequential versus
indexed.

Gerry

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Manuel Sugawara 2002-05-15 17:45:05 Re: Answering my own question
Previous Message Manuel Sugawara 2002-05-15 17:35:30 Re: trigger, transactions, eek