473,326 Members | 2,175 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

need help

hi
iam a new member and i need a help in my porject
i need to Know how can I calculate the size of DB ,meaning caculaste the size of each table?
also I need to know if the size of the database H/W is dependent or S/W is the dependent one or both are ?
and when the DB is transferred from one computer to another does its size
change?

I hope that anyone can help me I will appreciated it and thanks anyway

The Angel
Dec 10 '06 #1
1 1406
michaelb
534 Expert 512MB
The best way to calculate the size of your tables is to use the optional module dbsize, which comes with the Postgres source code, see .../contrib/dbsize
(You may or may not have it compiled/included in your Postgres installatiuon).

The size of the database between different UNIX platforms should be about the same (that is my best guess) and I have no idea how it would compare with Windows installation.

Keep in mind that size on the disk is always larger than all your data, because database needs to maintain a lot of metadata, logs, etc.
On UNIX you can see the overall size with the `du` command:

Expand|Select|Wrap|Line Numbers
  1. % cd $PGDATA
  2. postgresql % du -h
  3. 3.6M    ./base/1
  4. 3.6M    ./base/16975
  5. 4.0K    ./base/16976/pgsql_tmp
  6. 32M     ./base/16976
  7. 39M     ./base
  8. 132K    ./global
  9. 81M     ./pg_xlog
  10. 52K     ./pg_clog
  11. 120M    .
Here it's about 120 mb

Check the man pages for options to du command supported on given platform
Also keep in mind that overall size on disk may change without any changes to your data, because of either postgres internal maintenance or some user actions
(Try running "VACUUM FULL" on your db and then run `du` again to compare)

To answer all of your questions... this takes more than just yes or now... can I ask why are you concerned with all this?
Dec 11 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: mike | last post by:
Hello, After trying to validate this page for a couple of days now I was wondering if someone might be able to help me out. Below is a list of snippets where I am having the errors. 1. Line 334,...
5
by: John Flynn | last post by:
hi all i'm going to be quick i have an assignment due which i have no idea how to do. i work full time so i dont have the time to learn it and its due date has crept up on me .. As follows:...
0
by: xunling | last post by:
i have a question about answering ..... this topic is "need help" what do i have to write at te topic line, !after i have klicked the "answer message" button ive tried many possibilities,...
9
by: sk | last post by:
I have an applicaton in which I collect data for different parameters for a set of devices. The data are entered into a single table, each set of name, value pairs time-stamped and associated with...
7
by: Timothy Shih | last post by:
Hi, I am trying to figure out how to use unmanaged code using P/Invoke. I wrote a simple function which takes in 2 buffers (one a byte buffer, one a char buffer) and copies the contents of the byte...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
16
by: pamelafluente | last post by:
I am still working with no success on that client/server problem. I need your help. I will submit simplified versions of my problem so we can see clearly what is going on. My model: A client...
8
by: skumar434 | last post by:
i need to store the data from a data base in to structure .............the problem is like this ....suppose there is a data base which stores the sequence no and item type etc ...but i need only...
0
by: U S Contractors Offering Service A Non-profit | last post by:
Brilliant technology helping those most in need Inbox Reply U S Contractors Offering Service A Non-profit show details 10:37 pm (1 hour ago) Brilliant technology helping those most in need ...
20
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.