Re: update on TOAST status

Mike Mascari wrote:
> Chris Bitmead wrote:
> >
> > Jan Wieck wrote:
> >
> > >     Toast  tables  aren't  automatically   created   for   system
> > >     catalogs.  Thus I'll add
> > >
> > >         ALTER TABLE pg_rewrite CREATE TOAST TABLE
> > >
> > >     to  initdb.  So we'll get unlimited view complexity for free.
> > >     As soon as  arrays  are  toastable,  we  might  want  to  add
> > >     pg_class because of relacl too.
> >
> > Why would we want system catalogs toastable?
>
> I assume this will allow for Views with large rewrite rules which
> currently are limited in size.

    Absolutely correnct.

    With the code in place (after a few more fixes) I was able to
    create a "SELECT *" view from  a  681  attribute  table.  The
    resulting  rule  is  about  170K! And more complex things are
    possible too now,  because  the  rewrite  rule  size  is  not
    limited  any  longer (as long as you have enough CPU, ram and
    disk space).


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #