- 18 12月, 2005 6 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * 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.
-
由 Bruce Momjian 提交于
< * 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
-
由 Bruce Momjian 提交于
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.
-
由 Bruce Momjian 提交于
* 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.
-
- 17 12月, 2005 10 次提交
-
-
由 Bruce Momjian 提交于
< * %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()
-
由 Bruce Momjian 提交于
< * 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
-
由 Bruce Momjian 提交于
J.Kuwamura
-
由 Bruce Momjian 提交于
J.Kuwamura
-
由 Bruce Momjian 提交于
> * Allow the count returned by SELECT, etc to be to represent as an int64 > to allow a higher range of values
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Alvaro Herrera 提交于
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
-
- 16 12月, 2005 1 次提交
-
-
由 Tom Lane 提交于
file. The original code probed the PGPROC array separately for each PID, which was not good for large numbers of backends: not only is the runtime O(N^2) but most of it is spent holding ProcArrayLock. Instead, take the lock just once and copy the active PIDs into an array, then use qsort and bsearch so that the lookup time is more like O(N log N).
-
- 15 12月, 2005 2 次提交
-
-
由 Tom Lane 提交于
messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr.
-
由 Tom Lane 提交于
example from Jim Dew. Add some simple regression tests, since this is an area we seem to break regularly :-(
-
- 12 12月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * %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
-
由 Teodor Sigaev 提交于
- tsvector_(in|out) - tsquery_(in|out) - to_tsvector - to_tsquery, plainto_tsquery - 'simple' dictionary
-
由 Tom Lane 提交于
reduce contention for the former single LockMgrLock. Per my recent proposal. I set it up for 16 partitions, but on a pgbench test this gives only a marginal further improvement over 4 partitions --- we need to test more scenarios to choose the number of partitions.
-
- 11 12月, 2005 3 次提交
-
-
由 Neil Conway 提交于
Patch from Pavel Stehule, minor fixups by myself.
-
由 Bruce Momjian 提交于
< * Add GUC variable to run a command on database panic or < smart/fast/immediate shutdown
-
由 Tom Lane 提交于
that simplify_boolean_equality() may leave behind. This is only relevant if the user writes something a bit silly, like CASE x=y WHEN TRUE THEN. Per example from Michael Fuhr; may or may not explain bug #2106.
-
- 10 12月, 2005 9 次提交
-
-
由 Tom Lane 提交于
Sync HEAD and 8.1 branches of pgbench.
-
由 Bruce Momjian 提交于
< * Allow installing to directories containing spaces > * -Allow installing to directories containing spaces
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
Also minor improvements to 8.1.1 release notes.
-
由 Bruce Momjian 提交于
integrity actions. Stephan Szabo
-
由 Bruce Momjian 提交于
has been that way for a long time.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
introduced a copy-and-pasteo while trying to simplify the code.
-
由 Bruce Momjian 提交于
* -Have initdb set the input DateStyle (MDY or DMY) based on locale
-
- 09 12月, 2005 4 次提交
-
-
由 Peter Eisentraut 提交于
datestyle parameter of the new cluster accordingly.
-
由 Bruce Momjian 提交于
However, Another problem newly occurred. This solves the problem of snprintf and vsnprintf. Patch to HEAD and 8.1.X. Hiroshi Saito
-
由 Bruce Momjian 提交于
Win32 library files.
-
由 Tom Lane 提交于
the data defining the semantics of a lock method (ie, conflict resolution table and ancillary data, which is all constant) and the hash tables storing the current state. The only thing we give up by this is the ability to use separate hashtables for different lock methods, but there is no need for that anyway. Put some extra fields into the LockMethod definition structs to clean up some other uglinesses, like hard-wired tests for DEFAULT_LOCKMETHOD and USER_LOCKMETHOD. This commit doesn't do anything about the performance issues we were discussing, but it clears away some of the underbrush that's in the way of fixing that.
-