| From: | Matteo Beccati <php(at)beccati(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru> |
| Subject: | Re: Enhanced containment selectivity function |
| Date: | 2005-08-06 13:22:42 |
| Message-ID: | 42F4B9A2.4050102@beccati.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Hi,
>>Moving it in contrib/ltree would be more difficult to me because it
>>depends on other functions declared in selfuncs.c
>>(get_restriction_variable, etc).
>
> I'd be willing to consider exporting those functions from selfuncs.c.
In the meanwhile here is the latest patch which uses both mcv and
histogram values.
BTW, when restoring my test database I've found out that there were many
errors on ALTER INDEX "something" OWNER TO ... :
ERROR: "something" is not a table, view, or sequence
This using 8.1devel pg_restore and a 8.0.3 compressed dump. I could be
wrong, but I didn't get those errors a few days ago (some cvs updates ago).
Best regards
--
Matteo Beccati
http://phpadsnew.com/
http://phppgads.com/
| Attachment | Content-Type | Size |
|---|---|---|
| parentsel.diff | text/plain | 11.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Buttafuoco | 2005-08-06 18:20:32 | unexpected pageaddr on startup/recovery |
| Previous Message | yuanjia lee | 2005-08-06 07:58:40 | For Review: Allow WAL information to recover corrupted pg_controldata patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laszlo Hornyak | 2005-08-06 16:45:06 | default tablespace for roles |
| Previous Message | yuanjia lee | 2005-08-06 07:58:40 | For Review: Allow WAL information to recover corrupted pg_controldata patch |