pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John M. Flinchbaugh <glynis@butterfly.hjsoft.com>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big.
Date: Wed, 28 Jul 1999 05:29:09 -0400 (EDT)
Message-ID: <Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com> (raw)
In-Reply-To: <12416.932918447@sss.pgh.pa.us>

On Sun, 25 Jul 1999, Tom Lane wrote:
> > At 23:45 +0300 on 23/07/1999, John M. Flinchbaugh wrote:
> >> [ how to avoid "rule plan string too big" ? ]
> He might have some luck by splitting the query into two subqueries,
> one that joins half the tables and the other one joining the other half,
> then a top query that joins those two.  (The trick here is figuring
> out how to split the tables into two groups that can be joined without
> reference to the other group and without producing too many useless
> tuples.)  The top query is still going to be tight, because the number
> of targetlist nodes (output columns) won't change, but reducing the
> number of tables it references to two views and simplifying its WHERE
> condition down to one or so clauses will both help eliminate nodes.

i broke that huge view into a bunch of smaller ones successfully, but the
top view which pulled together 2 smaller views (which each pulled together
smaller parts,etc), and i got the same error.  it seems to still get hung
up on the number of columns the view was returning, so i had to drop a few
of the less useful columns to get it to create the view successfully.

____________________}John Flinchbaugh{______________________
| -> glynis@hjsoft.com <-             john@cs.millersv.edu |
|    glynis@netrax.net      http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~




view thread (7+ messages)  latest in thread

Message-ID: <Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com>
Permalink:  ../Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: glynis@butterfly.hjsoft.com
  Subject: Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big.
  In-Reply-To: <Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com>
  References: <12416.932918447@sss.pgh.pa.us> <Pine.LNX.4.10.9907280524450.7565-100000@butterfly.hjsoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox