Andrew Marder amarder

## gist:a482deab3b1b3a2f1ddc
tce-load -wi ncurses
TERM=vt100 top -c

## query_planner.markdown

      
              1 file
            
          
              25 forks
            
          
              2 comments
            
          
              69 stars
            
          
                hgmnz
                / query_planner.markdown
            
            
              Created
              March 23, 2011 14:14
            
              
                PostgreSQL query plan and SQL performance notes
              
          
    Types of index scans

Indexes

Sequential Scan:


Read every row in the table
No reading of index. Reading from indexes is also expensive.