I'm trying to actually run the experiments Tom suggested running EXPLAIN on
the DBT3 DSS queries for various default_stats_target sizes. It's a bit of a
headache because DBT3 seems to be unmaintained these days so lots of things
don't really work.
I ran into an error I've never seen before:
ERROR: XX000: could not devise a query plan for the given query
LOCATION: set_cheapest, pathnode.c:191
I haven't tried to figure out what's going on yet.
The schema is attached and the query which triggers the error is:
count(*) as numwait
s_suppkey = l1.l_suppkey
and o_orderkey = l1.l_orderkey
and o_orderstatus = 'F'
and l1.l_receiptdate > l1.l_commitdate
and exists (
l2.l_orderkey = l1.l_orderkey
and l2.l_suppkey <> l1.l_suppkey
and not exists (
l3.l_orderkey = l1.l_orderkey
and l3.l_suppkey <> l1.l_suppkey
and l3.l_receiptdate > l3.l_commitdate
and s_nationkey = n_nationkey
and n_name = 'IRAQ'
Description: application/octet-stream (7.5 KB)
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-11-28 18:00:33|
|Subject: Re: A bug with ALTER TABLE SET WITHOUT OIDS in CVS HEAD |
|Previous:||From: Tom Lane||Date: 2008-11-28 17:45:37|
|Subject: Re: Review: Hot standby |