On Wed, Nov 21, 2007 at 09:51:22AM -0800, SHARMILA JOTHIRAJAH wrote:
> Thanks for the detailed explanation Tom. You are rigt...The number of pages
> for this tables as per pg_class is 189.
>
> I have a few questions
> 1. How do you find the MAXALIGN of the machine? And what is that used for?
MA
mber 21, 2007 1:14:02 PM
Subject: Re: [GENERAL] Postgres table size
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> 1. How do you find the MAXALIGN of the machine? And what is that
used for?
pg_controldata will show "maximum data alignment". A rule of thumb is
that it&#
SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> writes:
> 1. How do you find the MAXALIGN of the machine? And what is that used for?
pg_controldata will show "maximum data alignment". A rule of thumb is
that it's 4 on 32-bit machines and 8 on 64-bit machines, but there are
exceptions.
> 2. How does nul
>>> Calculation
>> >varchar = (overhead) 4 + (actual length of string) 3 = 7 bytes
>> >*for 5 varchar cols =
>> >5*7 = 35 bytes
>> >
>> >numeric (according to manual--- The actual storage requirement is
>> >two bytes for each group of four deci
Erik Jones <[EMAIL PROTECTED]> writes:
> On Nov 21, 2007, at 9:17 AM, SHARMILA JOTHIRAJAH wrote:
>> Calculation
>> varchar = (overhead) 4 + (actual length of string) 3 = 7 bytes
>> *for 5 varchar cols =
>> 5*7 = 35 bytes
>>
>> numeric (according to
Re: [GENERAL] Postgres table size
On Nov 21, 2007, at 9:17 AM, SHARMILA JOTHIRAJAH wrote:
> Hi
> Thanks. Ill post it on the mailing list when I get the results. Im
> trying to calculate and see how the tablesize works for a simple
> table.
>
> I have a table with 10 cols
> 5 var
On Nov 21, 2007, at 9:17 AM, SHARMILA JOTHIRAJAH wrote:
Hi
Thanks. Ill post it on the mailing list when I get the results. Im
trying to calculate and see how the tablesize works for a simple
table.
I have a table with 10 cols
5 varchars _ it is declared as varchar(40) but contains data of
o: SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]>
Sent: Friday, November 16, 2007 2:12:46 PM
Subject: Re: [GENERAL] Postgres table size
On Fri, 2007-11-16 at 07:36 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi,
>
> You were right. I installed beta2 and the table size now is
> 4682817536. Thanks
On Tue, 2007-11-13 at 08:36 -0800, SHARMILA JOTHIRAJAH wrote:
> Hi
> I have a table with 29384048 records in oracle and postgresql. The
> table has 47 columns (16 numeric and 27 varchar and the rest
> timestamp). The tablesize in postgresql is twice as much than the
> tablesize in oracle (for th
Il Tuesday 13 November 2007 17:36:30 SHARMILA JOTHIRAJAH ha scritto:
> Hi
> I have a table with 29384048 records in oracle and postgresql. The table
> has 47 columns (16 numeric and 27 varchar and the rest timestamp). The
> tablesize in postgresql is twice as much than the tablesize in oracle (fo
10 matches
Mail list logo
