TODO items for removal

Started by Simon Riggsabout 19 years ago3 messages
#1Simon Riggs
simon@2ndquadrant.com

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Simon Riggs (#1)
Re: TODO items for removal

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@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

#3Neil Conway
neilc@samurai.com
In reply to: Simon Riggs (#1)
Re: TODO items for removal

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