Skip site navigation (1) Skip section navigation (2)

Re: Toasting more system-table columns

From: "Mark Hollomon" <mhh(at)nortelnetworks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Toasting more system-table columns
Date: 2000-08-03 20:23:56
Message-ID: 3989D4DC.1C4AF3C6@americasm01.nt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> 
> "Mark Hollomon" <mhh(at)nortelnetworks(dot)com> writes:
> > Tom Lane wrote:
> >> pg_statistic to cope with long
> >> min/max/common values (not sure about this).
> 
> > I would think pg_statistic would be a 'must'.
> 
> Well, it's not a "must" because the code copes fine now (there's a test
> in there that simply drops pg_statistic tuples that won't fit).

Oh, well of course. Even pre-toast len(min)+len(max)+len(common) > 8K
was possible.


-- 

Mark Hollomon
mhh(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-08-03 22:15:19
Subject: Anyone particularly wedded to func_tlist mechanism?
Previous:From: The Hermit HackerDate: 2000-08-03 20:20:36
Subject: Re: comparing rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group