On Mon, 2007-08-06 at 17:42 +0200, Marc Dirix wrote: > 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)
I'm not really strongly invested either way, but there would have to be a dramatic performance benefit to convince me to change a lot of code and assumptions that are already in place. > 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. Do share! > We are using 8.2 postgresql. > > > Marc > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
