1. 05 Jan, 2006 7 commits
    • Bruce Momjian's avatar
      Add: · 6d41b144
      Bruce Momjian authored
      >
      > 	* Allow SERIAL sequences to inherit permissions from the base table?
      6d41b144
    • Bruce Momjian's avatar
      Update: · db6cb1a9
      Bruce Momjian authored
      <   stable logging probably can not have indexes.  [wallog]
      >   stable logging probably can not have indexes.  [walcontrol]
      db6cb1a9
    • Bruce Momjian's avatar
      Update wording: · ac9e14d0
      Bruce Momjian authored
      <   STABLE | DEFAULT ].  [wallog]
      >   STABLE | DEFAULT ].  Tables using non-default logging should not use
      >   referential integrity with default-logging tables, and tables using
      >   stable logging probably can not have indexes.  [wallog]
      ac9e14d0
    • Bruce Momjian's avatar
      Update wording: · e7893db5
      Bruce Momjian authored
      <   the table. Another option is to avoid transaction logging entirely
      <   and truncate or drop the table on crash recovery.  These should be
      <   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      <   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      >   the table.  This would affect COPY, and perhaps INSERT/UPDATE too.
      >   Another option is to avoid transaction logging entirely and truncate
      >   or drop the table on crash recovery.  These should be implemented
      >   using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP | TRUNCATE |
      >   STABLE | DEFAULT ].  [wallog]
      e7893db5
    • Bruce Momjian's avatar
      Add: · 1b736817
      Bruce Momjian authored
      >
      > * Allow control over which tables are WAL-logged
      >
      >   Allow tables to bypass WAL writes and just fsync() dirty pages on
      >   commit.  To do this, only a single writer can modify the table, and
      >   writes must happen only on new pages.  Readers can continue accessing
      >   the table. Another option is to avoid transaction logging entirely
      >   and truncate or drop the table on crash recovery.  These should be
      >   implemented using ALTER TABLE, e.g. ALTER TABLE PERSISTENCE [ DROP |
      >   TRUNCATE | STABLE | DEFAULT ].  [wallog]
      1b736817
    • Bruce Momjian's avatar
      Update item: · 3002492f
      Bruce Momjian authored
      < * %Remove behavior of postmaster -o after making postmaster/postgres
      <   flags unique
      > * %Remove behavior of postmaster -o
      3002492f
    • Bruce Momjian's avatar
      Done: · 9be5beb9
      Bruce Momjian authored
      > * -Remove BeOS and QNX-specific code
      9be5beb9
  2. 30 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 7211ff7d
      Bruce Momjian authored
      > * Make CLUSTER preserve recently-dead tuples per MVCC requirements
      7211ff7d
  3. 29 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Update: · e135d963
      Bruce Momjian authored
      < * Add missing rtree optimizer selectivity
      > * Improve selectivity functions for geometric operators
      e135d963
  4. 28 Dec, 2005 2 commits
    • Bruce Momjian's avatar
      Update: · 6fa33572
      Bruce Momjian authored
      < * Add missing optimizer selectivities for date, r-tree, etc
      > * Add missing rtree optimizer selectivity
      6fa33572
    • Bruce Momjian's avatar
      Done: · 1b184c99
      Bruce Momjian authored
      < * %Make row-wise comparisons work per SQL spec
      > * -Make row-wise comparisons work per SQL spec
      1b184c99
  5. 26 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 5c9a46f6
      Bruce Momjian authored
      * %Make row-wise comparisons work per SQL spec
      
        Right now, '(a, b) < (1, 2)' is processed as 'a < 1 and b < 2', but
        the SQL standard requires it to be processed as a column-by-column
        comparison, so the proper comparison is '(a < 1) OR (a = 1 AND b < 2)'.
      5c9a46f6
  6. 22 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Update item: · 2f1a78e2
      Bruce Momjian authored
      >
      >   A more complex solution would be to save multiple plans for different
      >   cardinality and use the appropriate plan based on the EXECUTE values.
      >
      2f1a78e2
  7. 17 Dec, 2005 7 commits
    • Bruce Momjian's avatar
      Remove item: · 25af534e
      Bruce Momjian authored
      < * Allow star join optimizations
      <
      <   While our bitmap scan allows multiple indexes to be joined to get
      <   to heap rows, a star joins allows multiple dimension _tables_ to
      <   be joined to index into a larger main fact table.  The join is
      <   usually performed by either creating a cartesian product of all
      <   the dimmension tables and doing a single join on that product or
      <   using subselects to create bitmaps of each dimmension table match
      <   and merge the bitmaps to perform the join on the fact table.  Some
      <   of these algorithms might be patented.
      25af534e
    • Bruce Momjian's avatar
      Update: · 3282b633
      Bruce Momjian authored
      < * Flush cached query plans when the dependent objects change or
      <   when the cardinality of parameters changes dramatically
      > * Flush cached query plans when the dependent objects change,
      >   when the cardinality of parameters changes dramatically, or
      >   when new ANALYZE statistics are available
      3282b633
    • Bruce Momjian's avatar
      Add mention of possible patent problems with star joins, per Joshua · 16843ba3
      Bruce Momjian authored
      Drake:
      
      <   and merge the bitmaps to perform the join on the fact table.
      >   and merge the bitmaps to perform the join on the fact table.  Some
      >   of these algorithms might be patented.
      16843ba3
    • Bruce Momjian's avatar
      Add: · 9e9a844f
      Bruce Momjian authored
      * Allow star join optimizations
      
        While our bitmap scan allows multiple indexes to be joined to get
        to heap rows, a star joins allows multiple dimension _tables_ to
        be joined to index into a larger main fact table.  The join is
        usually performed by either creating a cartesian product of all
        the dimmension tables and doing a single join on that product or
        using subselects to create bitmaps of each dimmension table match
        and merge the bitmaps to perform the join on the fact table.
      9e9a844f
    • Bruce Momjian's avatar
      Add more function to TODO: · 927f5768
      Bruce Momjian authored
      < * %Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
      > * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),
      >   pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
      927f5768
    • Bruce Momjian's avatar
      Update: · eae75beb
      Bruce Momjian authored
      < * Flush cached query plans when the dependent objects change
      > * Flush cached query plans when the dependent objects change or
      >   when the cardinality of parameters changes dramatically
      eae75beb
    • Bruce Momjian's avatar
      Add: · 56ea9ad1
      Bruce Momjian authored
      > * Allow the count returned by SELECT, etc to be to represent as an int64
      >   to allow a higher range of values
      56ea9ad1
  8. 16 Dec, 2005 2 commits
  9. 12 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Update wording, query -> statement: · baf4e187
      Bruce Momjian authored
      < * %Allow pooled connections to list all prepared queries
      > * %Allow pooled connections to list all prepared statements
      28c28
      <   the queries prepared in the current session.
      >   the statements prepared in the current session.
      143c143
      < 	  o Allow a warm standby system to also allow read-only queries
      > 	  o Allow a warm standby system to also allow read-only statements
      404c404
      < * Add GUC to issue notice about queries that use unjoined tables
      > * Add GUC to issue notice about statements that use unjoined tables
      490c490
      < 	  Another idea would be to allow actual SELECT queries in a COPY.
      > 	  Another idea would be to allow actual SELECT statements in a COPY.
      554c554
      < 	o Allow function argument names to be queries from PL/PgSQL
      > 	o Allow function argument names to be statements from PL/PgSQL
      591c591
      < 	o Improve psql's handling of multi-line queries
      > 	o Improve psql's handling of multi-line statements
      < 	  Currently, while \e saves a single query as one entry, interactive
      < 	  queries are saved one line at a time.  Ideally all queries
      > 	  Currently, while \e saves a single statement as one entry, interactive
      > 	  statements are saved one line at a time.  Ideally all statements
      665c665
      < 	o Allow query results to be automatically batched to the client
      > 	o Allow statement results to be automatically batched to the client
      667c667
      < 	  Currently, all query results are transfered to the libpq
      > 	  Currently, all statement results are transfered to the libpq
      672c672
      < 	  One complexity is that a query like SELECT 1/col could error
      > 	  One complexity is that a statement like SELECT 1/col could error
      739c739
      < * Allow queries across databases or servers with transaction
      > * Allow statements across databases or servers with transaction
      <   inheritance, allow it to work for UPDATE and DELETE queries, and allow
      <   it to be used for all queries with little performance impact
      >   inheritance, allow it to work for UPDATE and DELETE statements, and allow
      >   it to be used for all statements with little performance impact
      876c876
      < * Consider automatic caching of queries at various levels:
      > * Consider automatic caching of statements at various levels:
      947c947
      <   a single session using multiple threads to execute a query faster.
      >   a single session using multiple threads to execute a statement faster.
      1025c1025
      < * Log queries where the optimizer row estimates were dramatically
      > * Log statements where the optimizer row estimates were dramatically
      1146c1146
      < 	  of result sets using new query protocol
      > 	  of result sets using new statement protocol
      baf4e187
  10. 11 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Remove item: · c1059314
      Bruce Momjian authored
      < * Add GUC variable to run a command on database panic or
      <   smart/fast/immediate shutdown
      c1059314
  11. 09 Dec, 2005 3 commits
  12. 08 Dec, 2005 2 commits
    • Bruce Momjian's avatar
      Add Teodor: · d22ec676
      Bruce Momjian authored
      > * Teodor is Teodor Sigaev <teodor@sigaev.ru>
      d22ec676
    • Bruce Momjian's avatar
      Remove a few people: · 0fba659e
      Bruce Momjian authored
      < * Claudio is Claudio Natoli <claudio.natoli@memetrics.com>
      1166d1164
      < * Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
      0fba659e
  13. 07 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Update: · 10a2df28
      Bruce Momjian authored
      <   at initdb time or optionally later.
      >   at initdb time or optionally later.  Consider O_SYNC when
      >   O_DIRECT exists.
      10a2df28
  14. 06 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Add: · 371879ca
      Bruce Momjian authored
      > * Add GUC variable to run a command on database panic or
      >   smart/fast/immediate shutdown
      371879ca
  15. 04 Dec, 2005 4 commits
    • Bruce Momjian's avatar
      Update: · 99552287
      Bruce Momjian authored
      < 	  Win32 API, and we have to make sure MinGW handles it.
      > 	  Win32 API, and we have to make sure MinGW handles it.  Another
      > 	  option is to wait for the MinGW project to fix it, or use the
      > 	  code from the LibGW32C project as a guide.
      99552287
    • Bruce Momjian's avatar
      Add: · 8752479d
      Bruce Momjian authored
      > 	o Add long file support for binary pg_dump output
      >
      > 	  While Win32 supports 64-bit files, the MinGW API does not,
      > 	  meaning we have to build an fseeko replacement on top of the
      > 	  Win32 API, and we have to make sure MinGW handles it.
      8752479d
    • Bruce Momjian's avatar
      Add: · bedb5fc3
      Bruce Momjian authored
      > * Add SPI_gettypmod() to return the typemod for a TupleDesc
      bedb5fc3
    • Bruce Momjian's avatar
      Add for autovacuum: · 49bbff0f
      Bruce Momjian authored
      > 	o Consider logging activity either to the logs or a system view
      49bbff0f
  16. 03 Dec, 2005 1 commit
    • Bruce Momjian's avatar
      Item removed: · eb339c78
      Bruce Momjian authored
      < * Add function to return the thread safety status of libpq and ecpg
      eb339c78
  17. 02 Dec, 2005 2 commits
    • Bruce Momjian's avatar
      Remove idea of increasing NUMERIC length: · 5ab25988
      Bruce Momjian authored
      < * Change NUMERIC to enforce the maximum precision, and increase it
      > * Change NUMERIC to enforce the maximum precision
      5ab25988
    • Bruce Momjian's avatar
      Add calcluation of bitmap storage capacity. · 9322a047
      Bruce Momjian authored
      <   be cleared when a heap tuple is expired.  Another idea is to maintain
      <   a bitmap of heap pages where all rows are visible to all backends,
      <   and allow index lookups to reference that bitmap to avoid heap
      <   lookups, perhaps the same bitmap we might add someday to determine
      <   which heap pages need vacuuming.
      >   be cleared when a heap tuple is expired.
      >
      >   Another idea is to maintain a bitmap of heap pages where all rows
      >   are visible to all backends, and allow index lookups to reference
      >   that bitmap to avoid heap lookups, perhaps the same bitmap we might
      >   add someday to determine which heap pages need vacuuming.  Frequently
      >   accessed bitmaps would have to be stored in shared memory.  One 8k
      >   page of bitmaps could track 512MB of heap pages.
      9322a047
  18. 01 Dec, 2005 2 commits
    • Bruce Momjian's avatar
      Add all heap page rows visible bitmap idea: · 113ece8f
      Bruce Momjian authored
      <   the heap.  One way to allow this is to set a bit to index tuples
      >   the heap.  One way to allow this is to set a bit on index tuples
      <   be cleared when a heap tuple is expired.
      <
      >   be cleared when a heap tuple is expired.  Another idea is to maintain
      >   a bitmap of heap pages where all rows are visible to all backends,
      >   and allow index lookups to reference that bitmap to avoid heap
      >   lookups, perhaps the same bitmap we might add someday to determine
      >   which heap pages need vacuuming.
      113ece8f
    • Bruce Momjian's avatar
      Add MERGE TODO.detail: · 915fb7f6
      Bruce Momjian authored
      >   [merge]
      378a380
      >   [merge]
      915fb7f6