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)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
