Am Dienstag, 4. Januar 2005 03:10 schrieb Chris Hoover: > This faq is not very helpful. I really need to know the values for each > type of column, and then how much to add for the overhead. It only > gives a single example, and does not address the index size. Nor does > it give the storage size for the various column types.
The storage requirements for each column type are quite evidently displayed in the documentation about the data types. The overhead is shown in the FAQ. If you want more precise values, create a table, fill it with values, run VACUUM FULL, and look at the file system size. That's the only way you can be sure. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
