Enabling and Disabling Sequencial Scan

From: Yusuf <yusuf0478(at)netscape(dot)net>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Enabling and Disabling Sequencial Scan
Date: 2003-05-30 20:33:07
Message-ID: 3ED7C003.1090303@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In the application, that I'm working on, I have a query that'll be a lot
60% faster if I disable sequential scan forcing it to you my index.

Is it bad practice to disable sequential scan ( set
enable_seqscan=false), run my query then enable sequential scan,
whenever I'm running this query? Why?

Thanks in advance

- David Wendy

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2003-05-30 20:46:12 Re: Enabling and Disabling Sequencial Scan
Previous Message Josh Berkus 2003-05-30 19:54:26 Re: Table Relationships