Re: Use of indexes with table inheritance - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Use of indexes with table inheritance
Date
Msg-id 20050207223452.GC30539@dcc.uchile.cl
Whole thread Raw
In response to Use of indexes with table inheritance  (Christopher Petrilli <petrilli@gmail.com>)
Responses Re: Use of indexes with table inheritance
List pgsql-general
On Mon, Feb 07, 2005 at 01:59:16PM -0500, Christopher Petrilli wrote:
> I have a "master table" called events, and 10 subtables which are
> created using this:
>
>     CREATE TABLE events001 ( ) INHERITS (events) WITHOUT OIDS;
>
> I then build all the indexes on it, including a column called "src_ip":
>
>     CREATE INDEX events001_src_ip_idx ON events001(src_ip);
>
> Then I populate it with about 1M events per table, but none in the
> "master table".  I'm using this for data partitioning basically.

Any reason you don't use a single table?  Also, please post the EXPLAIN
ANALYZE of your query.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)

pgsql-general by date:

Previous
From: Clodoaldo Pinto
Date:
Subject: Re: Out of memory error
Next
From: Christopher Petrilli
Date:
Subject: Re: Use of indexes with table inheritance