[v8.4.2] How doesn inheritance work?

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: [v8.4.2] How doesn inheritance work?
Date: 2010-01-25 10:09:24
Message-ID: 3eff28921001250209h39752da3j58dd614eb1d9bc75@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

I'd like to know how is inheritance handled when the number of child
tables grows and
I'm accessing (actually SELECTing from) the master, possibly with
contraint exclusion enabled.

How does grow then planner time and the query execution time for such
queries when
the number of children increases? Is it linear or what?

MTIA.

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 2010-01-25 10:09:33 Re: Questions about connection clean-up and "invalid page header"
Previous Message Pavel Stehule 2010-01-25 09:32:19 Re: Variadic polymorpic functions