> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
