| Lists: | pgsql-hackers |
|---|
| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | TODO items for removal |
| Date: | 2007-01-12 22:24:17 |
| Message-ID: | 1168640657.3990.173.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
These two items are complete in 8.2, IIRC
Allow constraint_exclusion to work for UNIONs like it does for
inheritance, allow it to work for UPDATE and DELETE statements, and
allow it to be used for all statements with little performance impact
Fix memory leak from exceptions
http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php
This item was rejected by Tom, since a workaround exists
Add estimated_count(*) to return an estimate of COUNT(*)
This would use the planner ANALYZE statistics to return an estimated
count. http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TODO items for removal |
| Date: | 2007-01-13 15:13:47 |
| Message-ID: | 200701131513.l0DFDlx14929@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Thanks, removed.
---------------------------------------------------------------------------
Simon Riggs wrote:
> These two items are complete in 8.2, IIRC
>
> Allow constraint_exclusion to work for UNIONs like it does for
> inheritance, allow it to work for UPDATE and DELETE statements, and
> allow it to be used for all statements with little performance impact
>
> Fix memory leak from exceptions
> http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php
>
>
> This item was rejected by Tom, since a workaround exists
>
> Add estimated_count(*) to return an estimate of COUNT(*)
> This would use the planner ANALYZE statistics to return an estimated
> count. http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
>
> --
> Simon Riggs
> EnterpriseDB http://www.enterprisedb.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TODO items for removal |
| Date: | 2007-01-13 15:33:36 |
| Message-ID: | 1168702416.6174.20.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Fri, 2007-01-12 at 22:24 +0000, Simon Riggs wrote:
> This item was rejected by Tom, since a workaround exists
>
> Add estimated_count(*) to return an estimate of COUNT(*)
> This would use the planner ANALYZE statistics to return an estimated
> count. http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
ISTM Tom didn't reject the TODO item (or the basic feature idea it
describes), he just objected to the syntax -- which I can understand,
count(*) is not syntax we want to be copying. AFAIK no one has actually
implemented the UDF he describes, though, so there should still be a
TODO item.
-Neil