From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
---|---|
To: | PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: update on TOAST status |
Date: | 2000-07-06 22:01:43 |
Message-ID: | 200007062201.AAA20087@hot.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-06 22:08:59 | Re: update on TOAST status' |
Previous Message | Jan Wieck | 2000-07-06 21:51:03 | Re: 2nd update on TOAST |