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 (<[EMAIL PROTECTED]>)
"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

Reply via email to