Hi everyone, I have a question concerning the size of an index... What I acually did was bulid a btree index on an smallint attribute within a table with 10^8 rows. The table itself is app. 10GB large and what I would like to have the smallest possible indeces. Unfortunately the current size is about 2GB per indexed column (8 columns are indexed in total) which is too large if the planner is supposed to choose a bitmap scan between all of the indices. So what I would like to know is the following: Is there an easy way to tell postgres to occupy the index pages up to 100 %? I am working in a decision support system so inserts/deletes etc. do normally not happen at all? Thanks, Tschak
