## Re: partitioning question 1

From: "Joshua D(dot) Drake" Ben pgsql-performance(at)postgresql(dot)org Re: partitioning question 1 2010-10-28 20:48:32 1288298912.22359.46.camel@jd-desktop (view raw or flat) 2010-10-28 16:36:54 from Ben  2010-10-28 17:31:32 from "Joshua D(dot) Drake"   2010-10-28 18:44:41 from Ben    2010-10-28 18:50:14 from "Joshua D(dot) Drake"     2010-10-28 19:25:16 from Ben      2010-10-28 19:44:12 from "Joshua D(dot) Drake"       2010-10-28 19:59:50 from Ben        2010-10-28 20:08:43 from "Reid Thompson"        2010-10-28 20:48:32 from "Joshua D(dot) Drake"         2010-10-28 21:06:57 from Ben  2010-10-29 14:38:47 from "Igor Neyman"   2010-10-29 16:16:13 from Ben    2010-10-29 16:28:20 from "Igor Neyman" pgsql-performance
```On Thu, 2010-10-28 at 12:59 -0700, Ben wrote:
> On Oct 28, 2010, at 12:44 PM, Joshua D. Drake wrote:
> >
> > My tests show you are incorrect:
> >
> >
> > part_test=# explain analyze select * from foo join bar using (i) where
> > i=9;
> >                                                    QUERY
> > PLAN
> > ------------------------------------------------------------------------------------------------------------------
> > Nested Loop  (cost=34.26..106.76 rows=200 width=20) (actual
> > time=0.004..0.004 rows=0 loops=1)
> >   ->  Append  (cost=0.00..68.50 rows=20 width=12) (actual
> > time=0.004..0.004 rows=0 loops=1)
> >         ->  Seq Scan on foo  (cost=0.00..34.25 rows=10 width=12)
> > (actual time=0.001..0.001 rows=0 loops=1)
> >               Filter: (i = 9)
> >         ->  Seq Scan on foo_1 foo  (cost=0.00..34.25 rows=10 width=12)
> > (actual time=0.000..0.000 rows=0 loops=1)
> >               Filter: (i = 9)
> >   ->  Materialize  (cost=34.26..34.36 rows=10 width=12) (never
> > executed)
> >         ->  Seq Scan on bar  (cost=0.00..34.25 rows=10 width=12) (never
> > executed)
> >               Filter: (i = 9)
> > Total runtime: 0.032 ms
> > (10 rows)
>
> strange.  my tests don't agree with your tests :

Do you have constraint_exclusion turned on? You should verify with show
constraint_exclusion (I saw what you wrote below).

JD

P.S. Blatant plug, you coming to http://www.postgresqlconference.org ?

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

```

### pgsql-performance by date

 Next: From: Ben Date: 2010-10-28 21:06:57 Subject: Re: partitioning question 1 Previous: From: James Mansion Date: 2010-10-28 20:33:19 Subject: Re: BBU Cache vs. spindles