From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Greg Stark <gsstark(at)mit(dot)edu>, Simon Riggs <simon(at)2ndquadrant(dot)com>, bizgres-general(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: A Guide to Constraint Exclusion (Partitioning) |
Date: | 2005-07-24 19:00:23 |
Message-ID: | 87vf309ghk.fsf@stark.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Uh, maybe you have sql_inheritance turned off? Every version I can
> remember would show you a pretty explicit Append plan for inheritance
> scans...
staging=> show sql_inheritance;
sql_inheritance
-----------------
on
(1 row)
Maybe I'm doing something more obvious wrong?
db=> create table _test (a integer);
CREATE TABLE
db=> create table _test2 (like _test);
CREATE TABLE
db=> create table _test3 (like _test);
CREATE TABLE
db=> create index _i on _test2 (a);
CREATE INDEX
db=> explain select * from _test where a=1;
QUERY PLAN
------------------------------------------------------
Seq Scan on _test (cost=0.00..22.50 rows=5 width=4)
Filter: (a = 1)
(2 rows)
--
greg
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-07-24 19:10:10 | Re: For review: Server instrumentation patch |
Previous Message | Andrew Dunstan | 2005-07-24 18:36:14 | Re: For review: Server instrumentation patch |