- 03 9月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
> * Use UTF8 encoding for NLS messages so all server encodings can > read them properly < o %Add support for Unicode < < To fix this, the data needs to be converted to/from UTF16/UTF8 < so the Win32 wcscoll() can be used, and perhaps other functions < like towupper(). However, UTF8 already works with normal < locales but provides no ordering or character set classes.
-
由 Bruce Momjian 提交于
< could only see committed rows from another transaction. However, > could only see rows from another completed transaction. However, 981c981 < proper visibility of the row, for example, for cursors. > proper visibility of the row's cmin, for example, for cursors.
-
由 Bruce Momjian 提交于
> o Allow COPY into an empty table to skip WAL logging
-
由 Tom Lane 提交于
on a page, as suggested by ITAGAKI Takahiro. Also, change a few places that were using some other estimates of max-items-per-page to consistently use MaxOffsetNumber. This is conservatively large --- we could have used the new MaxHeapTuplesPerPage macro, or a similar one for index tuples --- but those places are simply declaring a fixed-size buffer and assuming it will work, rather than actively testing for overrun. It seems safer to size these buffers in a way that can't overflow even if the page is corrupt.
-
由 Tom Lane 提交于
a local array isn't guaranteed to have any particular alignment, and so it could slow down the data transfer.
-
- 02 9月, 2005 9 次提交
-
-
由 Bruce Momjian 提交于
* Merge xmin/xmax/cmin/cmax back into three header fields Before subtransactions, there used to be only three fields needed to store these four values. This was possible because only the current transaction looks at the cmin/cmax values. If the current transaction created and expired the row the fields stored where xmin (same as xmax), cmin, cmax, and if the transaction was expiring a row from a another transaction, the fields stored were xmin (cmin was not needed), xmax, and cmax. Such a system worked because a transaction could only see committed rows from another transaction. However, subtransactions can see rows from outer transactions, and once the subtransaction completes, the outer transaction continues, requiring the storage of all four fields. With subtransactions, an outer transaction can create a row, a subtransaction expire it, and when the subtransaction completes, the outer transaction still has to have proper visibility of the row, for example, for cursors. One possible solution is to create a phantom cid which represents a cmin/cmax pair and is stored in local memory.
-
由 Tom Lane 提交于
under 'Populating a Database'.
-
由 Tom Lane 提交于
material in the EXPLAIN section, update examples to match current reality, show examples of bitmap indexscans as well as plain ones.
-
由 Bruce Momjian 提交于
< * Maintain a map of recently-expired rows < < This allows vacuum to target specific pages for possible free space < without requiring a sequential scan. < Update entry: > One complexity is that index entries still have to be vacuumed, and > doing this without an index scan (by using the heap values to find the > index entry) might be slow and unreliable, especially for user-defined > index functions.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
context since the previous AllocSetReset. Original patch by Atsushi Ogawa, editorialized on a little bit by Tom Lane.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 01 9月, 2005 1 次提交
-
-
由 Tom Lane 提交于
-
- 31 8月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
> * Eventually enable escape_string_warning and standard_conforming_strings
-
由 Bruce Momjian 提交于
Gavin Sherry
-
- 30 8月, 2005 9 次提交
-
-
由 Tom Lane 提交于
fit into a 512K shared memory segment.
-
由 Tom Lane 提交于
assert-enabled builds). This is a temporary measure to see if we can learn anything about those intermittent stats test failures in the buildfarm.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
per Bruce's suggestion.
-
由 Tom Lane 提交于
Per report from Jaime Casanova.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
reality.
-
由 Tom Lane 提交于
saves nearly 700kB in the default shared memory segment size, which seems worthwhile, and it is a feature that many users won't use anyway. Per Heikki's argument, there is no point in a compromise value --- those who are using 2PC at all will probably want it at least equal to max_connections. But we can't set it to zero by default without breaking the prepared_xacts regression test.
-
由 Tom Lane 提交于
it can be done right. Allow explicit use of absolute DataDir path. Per Dave Page.
-
- 29 8月, 2005 11 次提交
-
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
will use pthreadGC2. Dave Page
-
由 Tom Lane 提交于
SYNC instruction.
-
由 Tom Lane 提交于
got an empty bitmap after any step; the remaining subplans can no longer affect the result. Per a suggestion from Ilia Kantor.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * Add function to return the thread safety status of libpq and ecpg
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
to cope with a group name when dumping from a pre-8.1 installation. Per report from Stefan Kaltenbrunner.
-
- 28 8月, 2005 3 次提交
-
-
由 Tom Lane 提交于
are cases where it appears to have zero run cost.
-
由 Tom Lane 提交于
so that the latter estimates the number of groups that grouping will produce. This is needed because it is primarily query_planner that makes the decision between fast-start and fast-finish plans, and in the original coding it was unable to make more than a crude rule-of-thumb choice when the query involved grouping. This revision helps us make saner choices for queries like SELECT ... GROUP BY ... LIMIT, as in a recent example from Mark Kirkwood. Also move the responsibility for canonicalizing sort_pathkeys and group_pathkeys into query_planner; this information has to be available anyway to support the first change, and doing it this way lets us get rid of compare_noncanonical_pathkeys entirely.
-
由 Tom Lane 提交于
-