Postgres Pro
Downloads
Home   >   mailing lists

Enabling and Disabling Sequencial Scan - Mailing list pgsql-performance

From Yusuf
Subject Enabling and Disabling Sequencial Scan
Date
Msg-id 3ED7C003.1090303@netscape.net
Whole thread Raw
Responses Re: Enabling and Disabling Sequencial Scan  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Table Relationships
Next
From: "scott.marlowe"
Date:
Subject: Re: Enabling and Disabling Sequencial Scan