[COMMITTERS] fulldisjunction - fd: more CTID attribute consolidation.
Log Message: --- more CTID attribute consolidation. index queries now up to standard in preparation for casting. Modified Files: -- fd: algstructs.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.13&r2=1.14) algstructs.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.11&r2=1.12) algutils.c (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.16&r2=1.17) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Finally, we support casting for shared attributes
Log Message: --- Finally, we support casting for shared attributes so we can use same type equality functions. Modified Files: -- fd: algstructs.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.14&r2=1.15) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: FD is now 8+ compatible including 8.1 and 8.2
Log Message: --- FD is now 8+ compatible including 8.1 and 8.2 Modified Files: -- fd: Makefile (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.5&r2=1.6) algstructs.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.15&r2=1.16) odmbfd.c (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.17&r2=1.18) queues.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.15&r2=1.16) queues.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.7&r2=1.8) queuesfuncs.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.11&r2=1.12) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: Small fixes and added an Important check that the
Log Message: --- Small fixes and added an Important check that the scheme graph is a connected scheme graph before continuing to run the algorithm!!! Modified Files: -- fd: algstructs.c (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.16&r2=1.17) ---(end of broadcast)--- TIP 6: explain analyze is your friend
[COMMITTERS] fulldisjunction - fd: Cleaned up the old integer scheme graph, now we
Log Message: --- Cleaned up the old integer scheme graph, now we only use bits scheme graph with bitwise operations. Modified Files: -- fd: algstructs.c (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.17&r2=1.18) algstructs.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.12&r2=1.13) ---(end of broadcast)--- TIP 6: explain analyze is your friend
[COMMITTERS] fulldisjunction - fd: Finally! added dictionary support so you can give
Log Message: --- Finally! added dictionary support so you can give aliases to attribute names at relations when running FD (like an AS clause). Fixed the problem with DISTINCT and CTID. ADDED much needed parameters sanity checks and error messages. Modified Files: -- fd: README (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.6&r2=1.7) algstructs.c (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.18&r2=1.19) algstructs.h (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.13&r2=1.14) algutils.c (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.17&r2=1.18) createFuncs.sql (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/createFuncs.sql.diff?r1=1.2&r2=1.3) odmbfd.c (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.18&r2=1.19) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: More clean ups
Log Message: --- More clean ups Modified Files: -- fd: Makefile (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.6&r2=1.7) README (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.7&r2=1.8) algstructs.c (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.19&r2=1.20) algstructs.h (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.14&r2=1.15) algutils.c (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.18&r2=1.19) algutils.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.11&r2=1.12) getfdr.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/getfdr.c.diff?r1=1.1&r2=1.2) odmbfd.c (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.19&r2=1.20) queues.c (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.16&r2=1.17) queues.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.8&r2=1.9) queuesfuncs.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.12&r2=1.13) tset.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.13&r2=1.14) tset.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.9&r2=1.10) tsetfuncs.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.10&r2=1.11) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: Cleaned up the context structure and generally
Log Message: --- Cleaned up the context structure and generally more cleanups and indentations. Modified Files: -- fd: Makefile (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.7&r2=1.8) algstructs.c (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.20&r2=1.21) algstructs.h (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.15&r2=1.16) algutils.c (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.19&r2=1.20) algutils.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.12&r2=1.13) getfdr.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/getfdr.c.diff?r1=1.2&r2=1.3) odmbfd.c (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.20&r2=1.21) queues.c (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.17&r2=1.18) queues.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.9&r2=1.10) queuesfuncs.h (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.13&r2=1.14) tset.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.14&r2=1.15) tset.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.10&r2=1.11) tsetfuncs.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.11&r2=1.12) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: Finished README.
Log Message: --- Finished README. More cleanups and smoothing down the edges. Modified Files: -- fd: Makefile (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.8&r2=1.9) README (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.8&r2=1.9) algstructs.c (r1.21 -> r1.22) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.21&r2=1.22) algstructs.h (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.16&r2=1.17) algutils.c (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.20&r2=1.21) algutils.h (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.13&r2=1.14) odmbfd.c (r1.21 -> r1.22) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.21&r2=1.22) queues.c (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.18&r2=1.19) queues.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.10&r2=1.11) queuesfuncs.h (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.14&r2=1.15) tset.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.15&r2=1.16) tset.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.11&r2=1.12) tsetfuncs.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.12&r2=1.13) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: Fixed the inlcude directories in the Makfile to
Log Message: --- Fixed the inlcude directories in the Makfile to point to only the includes from the binary installation. Also more documentation fixes and additions. Modified Files: -- fd: Makefile (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.9&r2=1.10) README (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.9&r2=1.10) algstructs.c (r1.22 -> r1.23) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.22&r2=1.23) algstructs.h (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.17&r2=1.18) algutils.c (r1.21 -> r1.22) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.21&r2=1.22) algutils.h (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.14&r2=1.15) queues.c (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.19&r2=1.20) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Finished the code documentation and revamping the
Log Message: --- Finished the code documentation and revamping the error messages and Asserts. Modified Files: -- fd: algstructs.c (r1.23 -> r1.24) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.23&r2=1.24) algstructs.h (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.18&r2=1.19) algutils.c (r1.22 -> r1.23) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.22&r2=1.23) algutils.h (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.15&r2=1.16) odmbfd.c (r1.22 -> r1.23) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.22&r2=1.23) queues.c (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.20&r2=1.21) queues.h (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.11&r2=1.12) queuesfuncs.h (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.15&r2=1.16) tset.c (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.16&r2=1.17) tset.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.12&r2=1.13) tsetfuncs.h (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.13&r2=1.14) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: New Directory
Update of /cvsroot/fulldisjunction/fd/sql In directory pgfoundry.org:/tmp/cvs-serv65122/sql Log Message: Directory /cvsroot/fulldisjunction/fd/sql added to the repository ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: New Directory
Update of /cvsroot/fulldisjunction/fd/expected In directory pgfoundry.org:/tmp/cvs-serv65569/expected Log Message: Directory /cvsroot/fulldisjunction/fd/expected added to the repository ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: Adjusted the cvs files to fit the contrib format
Log Message: --- Adjusted the cvs files to fit the contrib format Modified Files: -- fd: Makefile (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.10&r2=1.11) Added Files: --- fd: README.fulldisjunctions (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions?rev=1.1&content-type=text/x-cvsweb-markup) contrib.Makefile.patch (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/contrib.Makefile.patch?rev=1.1&content-type=text/x-cvsweb-markup) fulldisjunctions.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/fulldisjunctions.sql?rev=1.1&content-type=text/x-cvsweb-markup) fulldisjunctions.sql.in (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/fulldisjunctions.sql.in?rev=1.1&content-type=text/x-cvsweb-markup) uninstall_fulldisjunctions.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/uninstall_fulldisjunctions.sql?rev=1.1&content-type=text/x-cvsweb-markup) fd/expected: fulldisjunctions.out (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/expected/fulldisjunctions.out?rev=1.1&content-type=text/x-cvsweb-markup) fd/sql: fulldisjunctions.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/sql/fulldisjunctions.sql?rev=1.1&content-type=text/x-cvsweb-markup) Removed Files: - fd: README (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README) createFuncs.sql (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/createFuncs.sql) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: New Directory
Update of /cvsroot/fulldisjunction/fd/README.fulldisjunctions.usecase_files In directory pgfoundry.org:/tmp/cvs-serv60154/README.fulldisjunctions.usecase_files Log Message: Directory /cvsroot/fulldisjunction/fd/README.fulldisjunctions.usecase_files added to the repository ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Added usecase.
Log Message: --- Added usecase. Added Files: --- fd/README.fulldisjunctions.usecase_files: d.jpg (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions.usecase_files/d.jpg?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Added usecase.
Log Message: --- Added usecase. Added Files: --- fd/README.fulldisjunctions.usecase_files: c.jpg (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions.usecase_files/c.jpg?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Added usecase.
Log Message: --- Added usecase. Added Files: --- fd: README.fulldisjunctions.usecase.html (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions.usecase.html?rev=1.1&content-type=text/x-cvsweb-markup) fd/README.fulldisjunctions.usecase_files: b.jpg (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions.usecase_files/b.jpg?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: ported the code to 8.2 with the gracious help of
Log Message: --- ported the code to 8.2 with the gracious help of jeremy drake Modified Files: -- fd: algstructs.c (r1.24 -> r1.25) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.24&r2=1.25) algstructs.h (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.19&r2=1.20) algutils.c (r1.23 -> r1.24) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.23&r2=1.24) getfdr.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/getfdr.c.diff?r1=1.3&r2=1.4) queues.h (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.12&r2=1.13) tset.c (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.17&r2=1.18) tsetfuncs.h (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.14&r2=1.15) ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[COMMITTERS] fulldisjunction - fd: Added contributors section in
Log Message: --- Added contributors section in README.fulldisjunctions. Modified Files: -- fd: README.fulldisjunctions (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.fulldisjunctions.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: added jeremy drake patch to accommodate tom lane's
Log Message: --- added jeremy drake patch to accommodate tom lane's new commit for caching plans in SPI Modified Files: -- fd: algutils.c (r1.24 -> r1.25) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.24&r2=1.25) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: catversion adjustment
Log Message: --- catversion adjustment Modified Files: -- fd: algutils.c (r1.25 -> r1.26) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.25&r2=1.26) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: interim fix for the valerna patch, to make
Log Message: --- interim fix for the valerna patch, to make fulldisjunctions working again Modified Files: -- fd: tset.c (r1.18 -> r1.19) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.18&r2=1.19) tsetfuncs.h (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.15&r2=1.16) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: moved the code to use slot_getsomeattrs instead of
Log Message: --- moved the code to use slot_getsomeattrs instead of my custom deform_tuple_iterative. This is only for postgresql version 200704051 and above. The previos versions are still supported. Modified Files: -- fd: algutils.c (r1.26 -> r1.27) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.26&r2=1.27) tset.c (r1.19 -> r1.20) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.19&r2=1.20) tset.h (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.13&r2=1.14) tsetfuncs.h (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.16&r2=1.17) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: cleanup to make it backward compatible with the
Log Message: --- cleanup to make it backward compatible with the stable version. It passes the regression tests now. Modified Files: -- fd: algutils.c (r1.27 -> r1.28) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.27&r2=1.28) ---(end of broadcast)--- TIP 6: explain analyze is your friend
[COMMITTERS] fulldisjunction - fd: more backward compatible regression test script.
Log Message: --- more backward compatible regression test script. Modified Files: -- fd/sql: fulldisjunctions.sql (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/sql/fulldisjunctions.sql.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: needed fix, reported by jeremy drake.
Log Message: --- needed fix, reported by jeremy drake. Tested only with regression test. Modified Files: -- fd: algstructs.c (r1.25 -> r1.26) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.25&r2=1.26) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Imported Sources
Update of /cvsroot/fulldisjunction/fd In directory pgfoundry.org:/tmp/cvs-serv34380 Log Message: Full Disjunction Operator Status: Vendor Tag: pgstudy Release Tags: fd_1_0 No conflicts created by this import ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: First version.
Log Message: --- First version. Works but needs a lot of working. Added Files: --- fd: algstructs.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c?rev=1.1&content-type=text/x-cvsweb-markup) algstructs.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h?rev=1.1&content-type=text/x-cvsweb-markup) algutils.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c?rev=1.1&content-type=text/x-cvsweb-markup) algutils.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h?rev=1.1&content-type=text/x-cvsweb-markup) createFuncs.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/createFuncs.sql?rev=1.1&content-type=text/x-cvsweb-markup) getfdr.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/getfdr.c?rev=1.1&content-type=text/x-cvsweb-markup) Makefile (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile?rev=1.1&content-type=text/x-cvsweb-markup) odmbfd.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c?rev=1.1&content-type=text/x-cvsweb-markup) queues.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c?rev=1.1&content-type=text/x-cvsweb-markup) queuesfuncs.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h?rev=1.1&content-type=text/x-cvsweb-markup) queues.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h?rev=1.1&content-type=text/x-cvsweb-markup) tset.c (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c?rev=1.1&content-type=text/x-cvsweb-markup) tsetfuncs.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h?rev=1.1&content-type=text/x-cvsweb-markup) tset.h (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: Changed some Makefile path settings
Log Message: --- Changed some Makefile path settings Modified Files: -- fd: Makefile (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Added simple pseudo functions by allowing for
Log Message: --- Added simple pseudo functions by allowing for graceful parameters (i.e. have defaults). Modified Files: -- fd: algstructs.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.1&r2=1.2) algstructs.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.1&r2=1.2) createFuncs.sql (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/createFuncs.sql.diff?r1=1.1&r2=1.2) odmbfd.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: Added README file and corrected memory problem
Log Message: --- Added README file and corrected memory problem with mincost policy. Modified Files: -- fd: algstructs.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.2&r2=1.3) Added Files: --- fd: README (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: Added BSD name to README
Log Message: --- Added BSD name to README Modified Files: -- fd: README (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Fixed the problem of not detecting dropped
Log Message: --- Fixed the problem of not detecting dropped attributes from relations. Fixed README file and various cleanups. Modified Files: -- fd: README (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.2&r2=1.3) algstructs.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.3&r2=1.4) odmbfd.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.2&r2=1.3) queues.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Added a python script to help create test tables.
Log Message: --- Added a python script to help create test tables. Added Files: --- fd: createTable.py (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/createTable.py?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Updated the README to show how to create a test
Log Message: --- Updated the README to show how to create a test case. Modified Files: -- fd: README (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Added BSD disclaimer to README file.
Log Message: --- Added BSD disclaimer to README file. Modified Files: -- fd: README (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Added copyright to all sources aside from the BSD
Log Message: --- Added copyright to all sources aside from the BSD disclaimer to README file. Modified Files: -- fd: algstructs.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.4&r2=1.5) algstructs.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.2&r2=1.3) algutils.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.1&r2=1.2) algutils.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.1&r2=1.2) odmbfd.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.3&r2=1.4) queues.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.2&r2=1.3) queues.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.1&r2=1.2) queuesfuncs.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.1&r2=1.2) tset.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.1&r2=1.2) tset.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.1&r2=1.2) tsetfuncs.h (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Comment out the copyright notice that broke the
Log Message: --- Comment out the copyright notice that broke the code. Speeded the computation by disabling merging in On Demand procedure and doing removal of duplicates after Extend. Also revamped efficiency of removeDuplicatesMemQueueWithSelf Modified Files: -- fd: algstructs.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.5&r2=1.6) algstructs.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.3&r2=1.4) algutils.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.2&r2=1.3) algutils.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.2&r2=1.3) odmbfd.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.4&r2=1.5) queues.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.3&r2=1.4) queues.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.2&r2=1.3) queuesfuncs.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.2&r2=1.3) tset.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.2&r2=1.3) tset.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.2&r2=1.3) tsetfuncs.h (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP 6: explain analyze is your friend
[COMMITTERS] fulldisjunction - fd: Added explanation in README to why i disabled
Log Message: --- Added explanation in README to why i disabled merging in On Demand in ODMBFD Modified Files: -- fd: README (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/README.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: Forgot to free memory in
Log Message: --- Forgot to free memory in removeDuplicatesMemQueueWithSelf Modified Files: -- fd: queues.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: Added capability for Adaptive Extending upper
Log Message: --- Added capability for Adaptive Extending upper bound for per CPU capabilities. Changed the behaviour of SQGetNext to only copy when requested. Some cleanups and fixes. It should be quicker now. Modified Files: -- fd: algstructs.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.6&r2=1.7) algstructs.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.4&r2=1.5) algutils.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.3&r2=1.4) algutils.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.3&r2=1.4) odmbfd.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.5&r2=1.6) queues.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.5&r2=1.6) queuesfuncs.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Small fixes to Adaptive Extending upper bound.
Log Message: --- Small fixes to Adaptive Extending upper bound. Modified Files: -- fd: algutils.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.4&r2=1.5) odmbfd.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.6&r2=1.7) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] fulldisjunction - fd: Small fix to MakeFile.
Log Message: --- Small fix to MakeFile. Currently on development make. Modified Files: -- fd: Makefile (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Fixed a bug that slowed down a bit the algorithm
Log Message: --- Fixed a bug that slowed down a bit the algorithm and added a small speedup. Modified Files: -- fd: algutils.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.4&r2=1.5) odmbfd.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.7&r2=1.8) queues.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.6&r2=1.7) queuesfuncs.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Moved the (tableID:rowID) pairs to the first
Log Message: --- Moved the (tableID:rowID) pairs to the first attribute of the tuple set for faster access. Modified Files: -- fd: algstructs.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.7&r2=1.8) algstructs.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.5&r2=1.6) algutils.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.5&r2=1.6) algutils.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.5&r2=1.6) odmbfd.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.8&r2=1.9) queues.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.7&r2=1.8) tset.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.3&r2=1.4) tset.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Changed the generate alternatives algorithm to use
Log Message: --- Changed the generate alternatives algorithm to use components instead of JCC heuristic. Fixed the output bug. Fixed a bug in varUnSetNthBitFromLeft. moved to deformed tuple in generate alternative tuple set. Modified Files: -- fd: algstructs.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.8&r2=1.9) algstructs.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.6&r2=1.7) algutils.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.6&r2=1.7) algutils.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.6&r2=1.7) odmbfd.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.9&r2=1.10) queues.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.8&r2=1.9) queues.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.3&r2=1.4) queuesfuncs.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.5&r2=1.6) tset.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.4&r2=1.5) tset.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.4&r2=1.5) tsetfuncs.h (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.3&r2=1.4) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Switched to fast gett attribute for rowid array
Log Message: --- Switched to fast gett attribute for rowid array instead of spi_getbinval. Modified Files: -- fd: tset.c (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Less than half way thru converting the structures
Log Message: --- Less than half way thru converting the structures to work with only deformed tuples. Already faster! Modified Files: -- fd: odmbfd.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.10&r2=1.11) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[COMMITTERS] fulldisjunction - fd: Less than half way thru converting the structures
Log Message: --- Less than half way thru converting the structures to work with only deformed tuples. Already faster! Modified Files: -- fd: algstructs.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.7&r2=1.8) algutils.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.7&r2=1.8) algutils.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.7&r2=1.8) queues.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.9&r2=1.10) queues.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.4&r2=1.5) queuesfuncs.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.6&r2=1.7) tset.c (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.6&r2=1.7) tset.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.5&r2=1.6) tsetfuncs.h (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.4&r2=1.5) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[COMMITTERS] fulldisjunction - fd: Some more deformed tuple structures consolidation
Log Message: --- Some more deformed tuple structures consolidation works. Modified Files: -- fd: algutils.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.8&r2=1.9) odmbfd.c (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.11&r2=1.12) queues.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.10&r2=1.11) queuesfuncs.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.7&r2=1.8) tset.c (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.7&r2=1.8) tsetfuncs.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.5&r2=1.6) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Some more deformed tuple structures consolidation
Log Message: --- Some more deformed tuple structures consolidation works. Now even faster but still half way done. Modified Files: -- fd: algutils.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.9&r2=1.10) odmbfd.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.12&r2=1.13) queuesfuncs.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.8&r2=1.9) tset.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.8&r2=1.9) tsetfuncs.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.6&r2=1.7) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: Finally, deformed tuples consolidation is over.
Log Message: --- Finally, deformed tuples consolidation is over. Now it is faster. Also added in makefile some optimizations to make it even more faster. Left is cleanup of the code because the names and some interfaces are a mess. Modified Files: -- fd: Makefile (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.3&r2=1.4) algstructs.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.9&r2=1.10) algutils.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.10&r2=1.11) odmbfd.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.13&r2=1.14) queues.c (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.11&r2=1.12) tset.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.9&r2=1.10) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: More consolidation work, a lot of cleanups.
Log Message: --- More consolidation work, a lot of cleanups. Also, complete queue now only holds rowids array (comes at a little extra cost but for long queries it should be worth it). Modified Files: -- fd: algstructs.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.10&r2=1.11) algstructs.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.8&r2=1.9) algutils.c (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.11&r2=1.12) algutils.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.8&r2=1.9) queues.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.12&r2=1.13) queues.h (r1.5 -> r1.6) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.5&r2=1.6) queuesfuncs.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.9&r2=1.10) tset.c (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.10&r2=1.11) tset.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.6&r2=1.7) tsetfuncs.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.7&r2=1.8) ---(end of broadcast)--- TIP 6: explain analyze is your friend
[COMMITTERS] fulldisjunction - fd: More consolidation works.
Log Message: --- More consolidation works. Removed almost completely references to the term "deformed" and left it only where it is truely meaningful. Modified Files: -- fd: algutils.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.12&r2=1.13) odmbfd.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.14&r2=1.15) queues.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.13&r2=1.14) queues.h (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.h.diff?r1=1.6&r2=1.7) queuesfuncs.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queuesfuncs.h.diff?r1=1.10&r2=1.11) tset.c (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.11&r2=1.12) tset.h (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.7&r2=1.8) tsetfuncs.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.8&r2=1.9) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] fulldisjunction - fd: Moved the calculations of whether to use an index
Log Message: --- Moved the calculations of whether to use an index scan to a seperate calculation instead of doing this while constructing the query. Also, moved allocation of strings and calculations of strings sizes to after the calculation. Also improved prediction of query size. Modified Files: -- fd: algutils.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.13&r2=1.14) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] fulldisjunction - fd: Moved the index queries to work with paramters and
Log Message: --- Moved the index queries to work with paramters and improved the formula to check if to use an index prior to deciding if to use an index using the planner. It shows a clear improvement in performance. Modified Files: -- fd: algstructs.c (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.11&r2=1.12) algstructs.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.9&r2=1.10) algutils.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.14&r2=1.15) algutils.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.9&r2=1.10) odmbfd.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.15&r2=1.16) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] fulldisjunction - fd: The dropped column issue is resolved by moving the
Log Message: --- The dropped column issue is resolved by moving the CTID to the select clause of all queries. some more cleanups and fixes. Modified Files: -- fd: Makefile (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/Makefile.diff?r1=1.4&r2=1.5) algstructs.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.c.diff?r1=1.12&r2=1.13) algstructs.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algstructs.h.diff?r1=1.10&r2=1.11) algutils.c (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.c.diff?r1=1.15&r2=1.16) algutils.h (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/algutils.h.diff?r1=1.10&r2=1.11) odmbfd.c (r1.16 -> r1.17) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/odmbfd.c.diff?r1=1.16&r2=1.17) queues.c (r1.14 -> r1.15) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/queues.c.diff?r1=1.14&r2=1.15) tset.c (r1.12 -> r1.13) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.c.diff?r1=1.12&r2=1.13) tset.h (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tset.h.diff?r1=1.8&r2=1.9) tsetfuncs.h (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/fulldisjunction/fd/tsetfuncs.h.diff?r1=1.9&r2=1.10) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
