[PATCHES] Synchronized Scan WIP patch

2007-03-14 Thread Jeff Davis
This is my latest revision of the Sync Scan patch, and it implements the observability as discussed with Simon. Changes: * ss_report_loc() called once per hundred pages rather than once per page * DEBUG messages are a little cleaner and easier to parse, for the sake of analysis after the fact.

Re: [PATCHES] LIMIT/SORT optimization

2007-03-14 Thread Gregory Stark
Bruce Momjian [EMAIL PROTECTED] writes: Is there a newer version of this patch? As requested, I've cut an updated version of this patch against CVS HEAD: http://community.enterprisedb.com/sort-limit-v5.patch.gz The open issues I see are: Adjusting the costing of the sort to take into

Re: [PATCHES] LIMIT/SORT optimization

2007-03-14 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: Bruce Momjian [EMAIL PROTECTED] writes: Is there a newer version of this patch? As requested, I've cut an updated version of this patch against CVS HEAD: http://community.enterprisedb.com/sort-limit-v5.patch.gz Someone asked why I've been posting

Re: [PATCHES] LIMIT/SORT optimization

2007-03-14 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Do people prefer receiving attachments or downloadable links? Does the answer change if the patches are quite large? Links suck from an archival standpoint; but at the same time you need to pay some attention to the size of your email. I think the

[PATCHES] Code-Cleanup: function declarations (void, and kr style)

2007-03-14 Thread Stefan Huehner
Hi, attached patch fixes some function declarations: - () - (void) - kr style - ansi C Regards, Stefan Index: src/pl/plpgsql/src/pl_funcs.c === RCS file: /projects/cvsroot/pgsql/src/pl/plpgsql/src/pl_funcs.c,v retrieving revision

[PATCHES] Code-Cleanup: char* - const char*

2007-03-14 Thread Stefan Huehner
Hi, attached patches marks several char* variables as const where they are initialized with constant strings. Regards, Stefan Index: src/backend/regex/regc_locale.c === RCS file:

Re: [PATCHES] LIMIT/SORT optimization

2007-03-14 Thread Magnus Hagander
Tom Lane wrote: Gregory Stark [EMAIL PROTECTED] writes: Do people prefer receiving attachments or downloadable links? Does the answer change if the patches are quite large? Links suck from an archival standpoint; but at the same time you need to pay some attention to the size of your

[PATCHES] Have \da in psql show return type

2007-03-14 Thread Greg Sabino Mullane
Using \da in psql should show the return type. Index: doc/src/sgml/ref/psql-ref.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v retrieving revision 1.188 diff -c -r1.188 psql-ref.sgml ***

Re: [PATCHES] LIMIT/SORT optimization

2007-03-14 Thread Simon Riggs
On Wed, 2007-03-14 at 15:16 +, Gregory Stark wrote: Do people prefer receiving attachments or downloadable links? Attachments are very clearly submissions to the project. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of