I've changed my tables to INT4.
Whatever you do, it does not make sence keeping a INT8 where there is
no need for it.
As stated in the other mails, INT8 is only to be choosen where it is
needed because of scaling, but slower
than INT4. (Review 8.2 docs on type int for this)
It is hard to see a performance differance at this point because we
both changed to INT4 and deleted 15GB of mails
reducing database size from 65GB back to 50GB.
However I do have found a select which joins mailboxes and users in
one querie to *not* use the index on user_id.
After the change it did.
We are using 8.2 postgresql.
Marc
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
