pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedrule plan too big (fwd)
3+ messages / 3 participants
[nested] [flat]
* rule plan too big (fwd)
@ 1999-06-03 15:57 Phil DiCorpo <pd3@wuerl.wustl.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Phil DiCorpo @ 1999-06-03 15:57 UTC (permalink / raw)
To: pgsql-sql
---------- Forwarded message ----------
Date: Thu, 3 Jun 1999 10:03:56 -0500 (CDT)
From: Phil DiCorpo <pd3@wuerl.wustl.edu>
To: pgsql-sql@postgresql.org
Subject: rule plan too big
I'm trying to create a relatively large view and I'm getting the
"DefineQueryRewrite: rule plan too big" error. Is this a bug in Postgres
that currently has no workaround, or is there something I can do. A
previous posting mentioned changing the blocksize. I thought I made this
change correctly, but it did not get rid of the error. Any help would be
much appreciated.
Phil
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] rule plan too big (fwd)
@ 1999-06-03 16:24 Jan Wieck <wieck@debis.com>
parent: Phil DiCorpo <pd3@wuerl.wustl.edu>
0 siblings, 1 reply; 3+ messages in thread
From: wieck@debis.com @ 1999-06-03 16:24 UTC (permalink / raw)
To: pd3@wuerl.wustl.edu; +Cc: pgsql-sql
> I'm trying to create a relatively large view and I'm getting the
> "DefineQueryRewrite: rule plan too big" error. Is this a bug in Postgres
> that currently has no workaround, or is there something I can do. A
> previous posting mentioned changing the blocksize. I thought I made this
> change correctly, but it did not get rid of the error. Any help would be
> much appreciated.
Currently there is no other workaround than increasing the
overall database blocksize until it fits. At the time I
mentioned changing the rule plan (and qualification) storage
to be able to split over tuples there was discussion about a
general tuple split capability, which would have solved this
problem silently. Unfortunately this general solution did not
incarnate for v6.5.
I've also played around with another data type which uses an
internal format that is a simple, byte oriented lz
compression. Using that on rule strings approximately
compresses with rates of 40-70% (better on large rules ==
complex views).
For now I'm planning to wait until v6.5 is released and then
make a feature patch where the rule plans will be stored
compressed. That will lower the problem (not entirely fixing
it) and offer the new compressed type for other purposes too.
*******************************************************
* WE STILL NEED THE GENERAL TUPLE SPLIT CAPABILITY!!! *
*******************************************************
I vote for sticking this onto the TODO and make it a
permanent show-stopper for version 7.0. NO v7.0 without
unlimited tuple size! I know that this is about a year or so
ahead :-)
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck@debis.com (Jan Wieck) #
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] rule plan too big (fwd)
@ 1999-06-03 17:02 Bruce Momjian <maillist@candle.pha.pa.us>
parent: Jan Wieck <wieck@debis.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 1999-06-03 17:02 UTC (permalink / raw)
To: Jan Wieck <jwieck@debis.com>; +Cc: Phil DiCorpo <pd3@wuerl.wustl.edu>; pgsql-sql
> *******************************************************
> * WE STILL NEED THE GENERAL TUPLE SPLIT CAPABILITY!!! *
> *******************************************************
>
> I vote for sticking this onto the TODO and make it a
> permanent show-stopper for version 7.0. NO v7.0 without
> unlimited tuple size! I know that this is about a year or so
> ahead :-)
>
Already on TODO:
* allow chaining of pages to allow >8k tuples
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-06-03 17:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-03 15:57 rule plan too big (fwd) Phil DiCorpo <pd3@wuerl.wustl.edu>
1999-06-03 16:24 ` Jan Wieck <wieck@debis.com>
1999-06-03 17:02 ` Bruce Momjian <maillist@candle.pha.pa.us>
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