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 the same number
of rows and columns). There are no updates or deletes in
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
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
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 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
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
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
>>> 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
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
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
11 matches
Mail list logo