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

Re: Toasting more system-table columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Hollomon" <mhh(at)nortelnetworks(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Toasting more system-table columns
Date: 2000-08-03 19:57:47
Message-ID: 19269.965332667@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"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).

Question is whether we need good selectivity estimation on columns where
the min/max/common values exceed 8K total (when represented in text form).
Or for that matter whether the estimates we derive from such values are
really useful ...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2000-08-03 20:08:56
Subject: Re: [BUGS] ALTER TABLE
Previous:From: Chris JonesDate: 2000-08-03 19:43:51
Subject: Re: [HACKERS] random() function produces wrong range

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