Re: inheritance performance - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: inheritance performance
Date
Msg-id 41F146B4.8010900@familyhealth.com.au
Whole thread Raw
In response to Re: inheritance performance  (ken <southerland@samsixedd.com>)
List pgsql-performance
> So if you perform a "select * from parent" then does postgres internally
> create a union between all the child tables and return you the results
> of that?

Basically, yes.  Kind of.

Chris

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: inheritance performance
Next
From: Marty Scholes
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering