From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Postgresql database
Date: Fri, 14 May 2010 11:51:02 +0200
User-Agent: KMail/1.12.4 (Linux/2.6.32-gentoo-r7; KDE/4.3.5; i686; ; )
References: <AANLkTikmPaFrIhuYUkxuhsC6kRgRJlmb0IfFAb7EE2x-@mail.gmail.com>
In-Reply-To: <AANLkTikmPaFrIhuYUkxuhsC6kRgRJlmb0IfFAb7EE2x-@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <201005141151.02716.leif@solumslekt.org>

On Friday 14. May 2010 10.42.17 Trinath Somanchi wrote:
> Hi All,
[snipped]
> This way the data in the table is tree structured. Also A single
> manufacturer has all mode of vehicles. I'm in my way to design this DB for
> use in PgSQL. But for a vast data, data retrieval is a very costly task
> (Joining all tables).
> 
> Can any one guide me of this design, on how the structure looks like. Hard
> about Inheritance feature of pgSQL. But not aware of how implementation
> goes.

You should think about a more normalized structure. Think about a table of 
"manufacturers", and a table of "models", the latter with a foreign key 
referencing the id of the former. The number of wheels is obviously an 
attribute of "models".

regards,
-- 
Leif Biberg Kristensen
http://solumslekt.org/blog/