Thread: How to calculate row sizes
I need some help. I need to calculate the max amount of space a row in each of my tables will take. However, I am having a difficult timefinding the information needed to do this. Would someone please be so kind as to point me to a listing of field type sizes, and also how to calculate the space usageof the associated indexes. thanks, revoohc
Chris Hoover wrote: > Would someone please be so kind as to point me to a listing of field > type sizes, and also how to calculate the space usage of the > associated indexes. FAQ 4.6 -- Peter Eisentraut http://developer.postgresql.org/~petere/
Peter Eisentraut wrote: >Chris Hoover wrote: > > >>Would someone please be so kind as to point me to a listing of field >>type sizes, and also how to calculate the space usage of the >>associated indexes. >> >> > >FAQ 4.6 > > > 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. Anything better out there, or has anyone have a script/spreadsheet that will calculate this? Thanks
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/