[GENERAL] Postgres table size

2007-11-13 Thread SHARMILA JOTHIRAJAH
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

Re: [GENERAL] Postgres table size

2007-11-13 Thread Reg Me Please
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

Re: [GENERAL] Postgres table size

2007-11-13 Thread Jeff Davis
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

Re: [GENERAL] Postgres table size

2007-11-21 Thread SHARMILA JOTHIRAJAH
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

Re: [GENERAL] Postgres table size

2007-11-21 Thread Erik Jones
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

2007-11-21 Thread SHARMILA JOTHIRAJAH
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

Re: [GENERAL] Postgres table size

2007-11-21 Thread Tom Lane
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

2007-11-21 Thread SHARMILA JOTHIRAJAH
>>> 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

Re: [GENERAL] Postgres table size

2007-11-21 Thread SHARMILA JOTHIRAJAH
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&#

Re: [GENERAL] Postgres table size

2007-11-21 Thread Tom Lane
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

Re: [GENERAL] Postgres table size

2007-11-22 Thread Martijn van Oosterhout
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