Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Toronto, Canada

    Unanswered: Enabling and disabling sequential scan

    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?

  2. #2
    Join Date
    Sep 2001

    seq scan

    no why not if it is faster do it

    you will see that more queries will be faster igf you disable seq scan. then he must use an index.
    if you are setting more indeces then you will get a faster database
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts