Re: [PERFORM] Index occupancy

2006-02-04 Thread Tom Lane
"tschak" <[EMAIL PROTECTED]> writes: > 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. Unfor

[PERFORM] Index occupancy

2006-02-04 Thread tschak
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 ab