[PERFORM] MAIN vs. PLAIN

2005-03-04 Thread Dave Held
I notice that by default, postgres sets numeric fields to storage MAIN. What exactly does that mean? Does that mean it stores it in some type of compressed BCD format? If so, how much performance gain can I expect by setting the storage to PLAIN? Also, the docs say that char(n) is implemented

Re: [PERFORM] MAIN vs. PLAIN

2005-03-04 Thread Tom Lane
Dave Held [EMAIL PROTECTED] writes: I notice that by default, postgres sets numeric fields to storage MAIN. What exactly does that mean? See http://developer.postgresql.org/docs/postgres/storage-toast.html There isn't any amazingly strong reason why numeric defaults to MAIN rather than