Re: FILLFACTOR and increasing index

> What about the index size?  How much space do they occupy? Analyze the
> table and do this


Of course space is different. That's not the point. The point is: I'm willing
to pay the price for another HD, if that helps with performance. But it doesn't.

>
> The minimal performance difference is  probably caused by the fact that
> we're dealing with int4 column (and you've  used just 100000 rows, i.e.
> about 0.5MB of data) so the index is going to be  tiny anyway.


I've used 10M rows, not 100000.

> Let's try to do that with varchar(32) column, just do  something like this


Did it with 5M rows. Still no difference.