Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT

From: Kim Bisgaard <kim+pg(at)alleroedderne(dot)adsl(dot)dk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Date: 2009-08-03 06:40:55
Message-ID: 4A768677.909@alleroedderne.adsl.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Are there plans to make a small follow-up patch to make
CREATE UNIQUE INDEX on one column
(and variants in CREATE TABLE ... PRIMARY KEY) automatically do
SET STATISTICS DISTINCT?

It might not be as perfect a solution as teaching the planner to know
about unique indexes, but it is better than nothing.

Good work!

Regards,
Kim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2009-08-03 07:54:15 Re: mixed, named notation support
Previous Message Fujii Masao 2009-08-03 04:18:53 Re: Revised signal multiplexer patch