"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

• Re: Toasting more system-table columns at 2000-08-03 18:38:01 from Mark Hollomon

Responses

• Re: Toasting more system-table columns at 2000-08-03 20:23:56 from Mark Hollomon

pgsql-hackers by date

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