Re: [SQL] rule plan string too big.

From: jwieck(at)debis(dot)com (Jan Wieck)
To: lutzeb(at)aeccom(dot)com (Dirk Lutzebaeck)
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] rule plan string too big.
Date: 1999-01-14 11:21:21
Message-ID: m100kq2-000EBQC@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
>
> Umm, I am creating a big view and then I get:
>
> PostgresSQL error message: ERROR:
> DefineQueryRewrite: rule plan string too big.
>
> This is on 6.4.2
>
> Any hints?

It's a known problem - not solved yet.

Currently the only possible solution is to increase the
blocksize (defaults to 8K). Don't forget to run initdb after!

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #

In response to

Responses

  • byte at 1999-01-14 14:12:53 from Remigiusz Sokolowski

Browse pgsql-sql by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-01-14 14:12:53 byte
Previous Message Dirk Lutzebaeck 1999-01-14 11:03:42 rule plan string too big.