Changeset 152 for trunk/tools

Show
Ignore:
Timestamp:
05/25/10 18:20:43 (4 years ago)
Author:
ssteinpreis
Message:

tid12312 removed reference to avoiding pg_temp_nnn namespaces, handled on command line

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/tools/pg_bloat_report.pl

    r142 r152  
    251251  ) AS rs 
    252252  JOIN pg_class cc ON cc.relname = rs.tablename and cc.relkind = 'r' 
    253   JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema'  AND nn.nspname !~ '^pg_temp' 
     253  JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' 
    254254) AS sml 
    255255WHERE sml.relpages - otta > 128  
     
    303303  ) AS rs 
    304304  JOIN pg_class cc ON cc.relname = rs.tablename 
    305   JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' AND nn.nspname !~ '^pg_temp' 
     305  JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' 
    306306  LEFT JOIN pg_index i ON indrelid = cc.oid 
    307307  LEFT JOIN pg_class c2 ON c2.oid = i.indexrelid