DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=Yuhgu67o+7gT0g2aCaqmsXDtrMjFtkaUj9sd53o8uyWF8c/DLaYPmDyduSKKle2KftgCcUxHZQgR+Jc/ddW8Ubvwtds8fRfhgpVBAF6Jzu1a7mhAHmCZxPzdWQfILzmVl4vw3jgC+hjcK0EDJKpSLUNVqUAJtKmsyD47BmBJrhc=
Message-ID: <f966c2ee0803212110n2d84585eqf5d9bf67cdba0898@mail.gmail.com>
Date: Sat, 22 Mar 2008 09:40:02 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Having MANY MANY empty columns in database
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6960_29598030.1206159002789"

------=_Part_6960_29598030.1206159002789
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,

I want some clarification in the following,

In a database which we are having we have nearly 100 tables, and in 75% of
the tables we have 6 columns ( INT ) as standard columns. What is standard
columns, if you create a table in this database you should have some default
6 columns in there they should maintain
    1. who is the owner of that read
    2. when it is added
    3. who is updating the record
    4. when it is updated .... and other columns....

But many of the users are not doing anything with those columns, they are
all empty always....

Say in that 75 % of tables, 60 % table contains nearly 1000 records
always...

and other 10% of tables contains less than 10000 records

and 5% of table contain records nealy 5 lakh.....

What i need is???

If you drop those columns we will gain any performance or not.....
Definitely i know having that columns is not useful, but i want some
clarification that having empty columns will make performance degradation or
not....


Am using Debian, and having 1 GB RAM...
I want this informations in both postgres 7.4 and 8.1 ( don't ask me to use
8.3 please, i want info in 7.4 and 8.1 )...


Regards
SathiyaMoorthy

------=_Part_6960_29598030.1206159002789
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi All,<br><br>I want some clarification in the following, <br><br>In a database which we are having we have nearly 100 tables, and in 75% of the tables we have 6 columns ( INT ) as standard columns. What is standard columns, if you create a table in this database you should have some default 6 columns in there they should maintain <br>
&nbsp;&nbsp;&nbsp; 1. who is the owner of that read<br>&nbsp;&nbsp;&nbsp; 2. when it is added<br>&nbsp;&nbsp;&nbsp; 3. who is updating the record<br>&nbsp;&nbsp;&nbsp; 4. when it is updated .... and other columns....<br><br>But many of the users are not doing anything with those columns, they are all empty always....<br>
<br>Say in that 75 % of tables, 60 % table contains nearly 1000 records always...<br><br>and other 10% of tables contains less than 10000 records<br><br>and 5% of table contain records nealy 5 lakh.....<br><br>What i need is???<br>
<br>If you drop those columns we will gain any performance or not..... Definitely i know having that columns is not useful, but i want some clarification that having empty columns will make performance degradation or not....<br>
<br><br>Am using Debian, and having 1 GB RAM...<br>I want this informations in both postgres 7.4 and 8.1 ( don&#39;t ask me to use 8.3 please, i want info in 7.4 and 8.1 )...<br><br><br>Regards<br>SathiyaMoorthy<br>

------=_Part_6960_29598030.1206159002789--