Results 1 to 3 of 3

Thread: Indexing FAQ

  1. #1
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Unanswered: Indexing FAQ

    After I have seen so much questions about indexing here is a small FAQ


    1. workaround:
    set seq_scan=off;
    QUERY
    set seq_scan=on;

    planer is forced to use indices.

    2. always write SELECTS like this

    SELECT x,y FROM T_table WHERE x='7' AND y='get it';

    always make single quotes. The planer can work better with single quotes.
    Some internal things are getting better with that. Does not remember the whole story, but it is working.
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  2. #2
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    great

    Sounds great , but can you précise how much of speed gain does it occur ?
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

  3. #3
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    speed

    seqential scan against index scan in the best scenario
    http://www.postgresql.org
    --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
  •