From: | "Mitesh Shah" <Mitesh(dot)Shah(at)bangnetworks(dot)com> |
---|---|
To: | "Mitch Vincent" <mitch(at)venux(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Estimating Size of Database |
Date: | 2001-04-12 22:26:06 |
Message-ID: | 26F46487ED75F649A88B15D3FE184B0F0272B8@HERMES.bangnetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thanks!
One follow up question. In the example given, it says there are 36
bytes for each row header and 4 bytes for each pointer to a tuple. I'm
not sure where these numbers (36 and 4) are coming from. Are they
standard for *every* table? If my table has more than just two
integers, for example, will each row header be more than 36 bytes?
Thanks in advance.
Mitesh
-----Original Message-----
From: Mitch Vincent [mailto:mitch(at)venux(dot)net]
Sent: Thursday, April 12, 2001 3:16 PM
To: Mitesh Shah; pgsql-hackers(at)postgresql(dot)org
Subject: Re: Estimating Size of Database
In the FAQ..
http://www.postgresql.org/docs/faq-english.html#4.7
Good luck!
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
----- Original Message -----
From: "Mitesh Shah" <Mitesh(dot)Shah(at)bangnetworks(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Sent: Thursday, April 12, 2001 6:10 PM
Subject: Estimating Size of Database
> Is there a Web site or some info somewhere that tells you how to
> estimate the size of your database.
>
> I know what my schema is and how many records will be in each table
(but
> non have been inserted yet). How can I project how much disk space I
> will need for the database?
>
> Thanks!
> Mitesh
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-04-12 22:30:48 | Re: Yacc / Bison difficulties |
Previous Message | Mitch Vincent | 2001-04-12 22:15:39 | Re: Estimating Size of Database |