db size reporting
I'm going to be working with some rather large datasets and I want to
evaluate the effects of normalization/denormalization on disk space. Is
there a simple way to find the size on disk of a specific database? To do so
with the operating system is rather crude, since it know nothing about what
proportion of the cluster area is allocated for each database.
jeff sacksteder <jsacksteder@gmail.com> writes:
I'm going to be working with some rather large datasets and I want to
evaluate the effects of normalization/denormalization on disk space. Is
there a simple way to find the size on disk of a specific database?
Look into the functions offered by contrib/dbsize. Or read
http://developer.postgresql.org/docs/postgres/storage.html
and use du by hand ;-)
regards, tom lane
jeff sacksteder wrote:
I'm going to be working with some rather large datasets and I want to
evaluate the effects of normalization/denormalization on disk space.
Is there a simple way to find the size on disk of a specific database?
To do so with the operating system is rather crude, since it know
nothing about what proportion of the cluster area is allocated for
each database.
look for the dbsize utils in the contrib.
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/