|
Jul 10 2006, 5:15 PM EDT
|
Anonymous |
|
edit |
8 words added
|
|
Change: Fix ordering of function table entries in docsNeilc's project ideas for anyone who's interested:Implement UNIQUE predicate, per SQL:2003Implement CREATE TABLE LIKE composite_typeImprove schema browsing in psqlAdd a psql option to have it submit SELECT queries
View changes from previous version.
(Word count: 572)
|
|
Jul 10 2006, 2:13 PM EDT
|
Anonymous |
|
edit |
7 words added
|
|
Change: INSERT ... SELECT FROM ..., CREATE TABLE ... AS SELECT ...,tunability of new tuple placement (both insert and update)clustering by set of bitmap indexes TOAST tuples should be accessed by CTIDCICSRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 564)
|
|
Jul 10 2006, 12:51 PM EDT
|
Anonymous |
|
edit |
6 words added
|
|
Change: CREATE INDEX, UPDATE, COPY, INSERT ... SELECT FROM ..., CREATE TABLE ... AS SELECT ...,tunability of new tuple placement (both insert and update) clustering by set of bitmap indexesCICSRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 557)
|
|
Jul 10 2006, 11:56 AM EDT
|
Anonymous |
|
edit |
3 words added
3 words deleted
|
|
Change: in addition to vacuum. dependingDepending on context, main."maintenance" comms.commands can be DELETE, CREATE INDEX, UPDATE, COPY, INSERT ... SELECT FROM ..., CREATE TABLE ... AS SELECT ...,tunability of new tuple placement (both insert and update)CICSRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 551)
|
|
Jul 10 2006, 10:04 AM EDT
|
Anonymous |
|
edit |
89 words added
|
|
Change: add ctid to non-unique indexes when ordering + implement non-locking CREATE INDEX and REINDEXdiscuss "ARCHIVE TABLES" + index-only queries.haggle about getting CONCURRENT VACUUM into backendadd throttling knobs to more "maintenance" commands in addition to vacuum. depending on context, main. comms. can be DELETE, CREATE INDEX, UPDATE,
View changes from previous version.
(Word count: 551)
|
|
Jul 10 2006, 9:49 AM EDT
|
Anonymous |
|
edit |
3 words added
1 word deleted
|
|
Change: know, Chris Mair)Finish INSERT ... RETURNING patchImplement INSERT with multiple VALUES, per SQL:2003Implement UNIQUE for hash indexesFinish patch for column-level triggersEnumerating each of the outstanding patches on Bruce's list, and applying or rejecting each of themGavin's suggestions:Improving contended LWLocksPreparing for 8.2Make
View changes from previous version.
(Word count: 464)
|
|
Jul 10 2006, 9:49 AM EDT
|
Anonymous |
|
edit |
23 words added
|
|
Change: (<- I'll look a bit into this (too shy to touch the backend :) - if you're doing this too, let me know)Finish INSERT ... RETURNING patchImplement INSERT with multiple VALUES, per SQL:2003Implement UNIQUE for hash indexesFinish patch for column-level triggersEnumerating each of
View changes from previous version.
(Word count: 462)
|
|
Jul 10 2006, 12:19 AM EDT
|
Anonymous |
|
edit |
4 words added
|
|
Change: Finalize my pg_dump patchpostgresql.conf analyzerAsynchronous DBD::PgImproved logging of prepared statementsOverhaul of logging to allow fine granularity per database/user/subsection/etc.More tid operatorsalvherre's suggestions:Will probably work on: finishing the relminxid patchMay work on: autovacuum maintenance-window featureMay work on: COPY (query) TO featureHaving
View changes from previous version.
(Word count: 440)
|
|
Jul 9 2006, 9:25 PM EDT
|
Anonymous |
|
edit |
23 words added
|
|
Change: until the serial snapshot is setDeferred UNIQUE constraintsEnhance pg_dump to support dumping multiple tables Devrim will work on:Enable multiple versions of PostgreSQL RPMs to be installed to the same server. Currently we do not allow that. Relevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 436)
|
|
Jun 29 2006, 6:43 PM EDT
|
|
|
edit |
1 word added
1 word deleted
|
|
Change: relminxid patchMay work on: autovacuum maintenance-window featureMay work on: COPY (query) TO featureHaving BEGIN not start a transaction right away, but rather wait until the serial snapshot is setDeferred UNIQUE constraints EnhaceEnhance pg_dump to support dumping multiple tablesRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 413)
|
|
Jun 29 2006, 3:36 PM EDT
|
Anonymous |
|
edit |
7 words added
|
|
Change: the relminxid patchMay work on: autovacuum maintenance-window featureMay work on: COPY (query) TO featureHaving BEGIN not start a transaction right away, but rather wait until the serial snapshot is setDeferred UNIQUE constraints Enhace pg_dump to support dumping multiple tablesRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 413)
|
|
Jun 27 2006, 8:49 AM EDT
|
Anonymous |
|
edit |
7 words added
|
|
Change: operatorsalvherre's suggestions:Will probably work on: finishing the relminxid patchMay work on: autovacuum maintenance-window feature May work on: COPY (query) TO featureHaving BEGIN not start a transaction right away, but rather wait until the serial snapshot is setDeferred UNIQUE constraintsRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 406)
|
|
Jun 27 2006, 2:06 AM EDT
|
|
|
edit |
71 words added
14 words deleted
|
|
Change: Per Tom, a good rule of thumb might be to limit code sprint projects to ideas where community input isn't warranted (because the feature is
View changes from previous version.
(Word count: 399)
|
|
Jun 27 2006, 2:02 AM EDT
|
Anonymous |
|
edit |
36 words added
25 words deleted
|
|
Change: is interested in working on:Make the int8 type pass-by-value on 64-bit platformsImplement CORRESPONDING BY, per SQL:2003 ImplementConsider UNIQUEusing predicateprofile-guided optimization, perwith SQL:2003recent versions of GCCGeneralize the planner knobsInline set-returning SQL functions Consider using profile-guidedNeilc's optimizationproject withideas
View changes from previous version.
(Word count: 339)
|
|
Jun 26 2006, 3:36 PM EDT
|
Anonymous |
|
edit |
36 words added
|
|
Change: granularity per database/user/subsection/etc.More tid operators alvherre's suggestions:Will probably work on: finishing the relminxid patchMay work on: autovacuum maintenance-window featureHaving BEGIN not start a transaction right away, but rather wait until the serial snapshot is setDeferred UNIQUE constraintsRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 327)
|
|
Jun 26 2006, 7:22 AM EDT
|
Anonymous |
|
edit |
42 words added
|
|
Change: & int8). Greg's suggestions and notes:Will probably work on: column-level triggers, CREATE OR REPLACE enhancementsMay work on: INSERT with multiple VALUESpostgresql.conf analyzerAsynchronous DBD::PgImproved logging of prepared statementsOverhaul of logging to allow fine granularity per database/user/subsection/etc.More tid operatorsRelevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 289)
|
|
Jun 23 2006, 5:48 PM EDT
|
|
|
edit |
1 word added
1 word deleted
|
|
Change: column-level triggersEnumerating each of the outstanding patches on Bruce's list, and applying or rejecting each of themGavin's suggestions:Improving contended LWLocksPreparing for 8.2Make use of posix_fadvise for heap/index relations Larry Rosenman's Suggestion:suggestion:create unsigned integer type(s) (int2, int4 & int8).Relevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 240)
|
|
Jun 23 2006, 4:43 PM EDT
|
|
|
edit |
2 words added
1 word deleted
|
|
Change: column-level triggersEnumerating each of the outstanding patches on Bruce's list, and applying or rejecting each of themGavin's suggestions:Improving contended LWLocksPreparing for 8.2Make use of posix_fadvise for heap/index relations Larry Rosenman's Suggestion:create unsigned integer type(s) (int4(int2, int4 & int8).Relevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 240)
|
|
Jun 23 2006, 4:41 PM EDT
|
|
|
edit |
|
|
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 239)
|
|
Jun 23 2006, 3:34 PM EDT
|
|
|
edit |
10 words added
|
|
Change: for column-level triggersEnumerating each of the outstanding patches on Bruce's list, and applying or rejecting each of themGavin's suggestions:Improving contended LWLocksPreparing for 8.2Make use of posix_fadvise for heap/index relations Larry Rosenman's Suggestion:create unsigned integer type(s) (int4 & int8).Relevant links:PostgreSQL TODO List
View changes from previous version.
(Word count: 239)
|