[PATCHES] Synchronized Scan WIP patch

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

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 ac

Re: [PATCHES] LIMIT/SORT optimization

"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

Re: [PATCHES] LIMIT/SORT optimization

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 cu

[PATCHES] Code-Cleanup: function declarations (void, and k&r style)

Hi, attached patch fixes some function declarations: - () -> (void) - k&r 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 revisio

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

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: /projects/cvsroot/pgsql/src/backend/regex/regc_locale

Re: [PATCHES] LIMIT/SORT optimization

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 y

[PATCHES] Have \da in psql show return type

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 *** doc/src/sgml/ref/

Re: [PATCHES] LIMIT/SORT optimization

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 broa