using inheritance in production application.

From: Larry White <ljw1001(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: using inheritance in production application.
Date: 2004-12-09 20:21:53
Message-ID: d15ea14a04120912212b4f089b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How 'ready for prime-time' is the table inheritance feature? I've
seen some postings about particular issues (lack of full FK support,
for example), but would like to get an overall sense of the stability
and robustness of the feature.

Also, is there a performance hit in using inheritance? For example if
I have a sub-table that adds a couple of columns to a base table,
would it be slower to query that structure than it would to represent
the extra columns as a separate table that would be joined with the
base table?

thanks for your help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2004-12-09 22:10:21 Temporary tables and disk activity
Previous Message Janning Vygen 2004-12-09 17:32:19 table with sort_key without gaps