Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] rule plan string too big. - Mailing list pgsql-sql

From jwieck@debis.com (Jan Wieck)
Subject Re: [SQL] rule plan string too big.
Date
Msg-id m100kq2-000EBQC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to rule plan string too big.  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Responses byte
List pgsql-sql
Tree view 
>
>
> 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@debis.com (Jan Wieck) #

pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: rule plan string too big.
Next
From: Remigiusz Sokolowski
Date:
Subject: byte