- 05 Sep, 2005 3 commits
-
-
Tom Lane authored
has to recopy the input plan node's targetlist if it removes a SubqueryScan node just below the non-projecting node. For simplicity I made it recopy always. Per bug report from Allan Wang and Michael Fuhr.
-
Andrew Dunstan authored
Suggestion by Darcy Buskermolen, reworded by me.
-
Bruce Momjian authored
exactly match the client version number, and warn about major version mismatches.
-
- 04 Sep, 2005 1 commit
-
-
Alvaro Herrera authored
-
- 03 Sep, 2005 2 commits
-
-
Tom Lane authored
Propagate hack that's in dirmod.c to copydir.c.
-
Bruce Momjian authored
< cmin/cmax pair and is stored in local memory. > cmin/cmax pair and is stored in local memory. Another idea is to > store both cmin and cmax only in local memory.
-
- 02 Sep, 2005 15 commits
-
-
Bruce Momjian authored
-
Tom Lane authored
-
Bruce Momjian authored
< have its heap and index files truncated. One issue is < that no other backend should be able to add to the table < at the same time, which is something that is currently < allowed. > removed or have its heap and index files truncated. One > issue is that no other backend should be able to add to > the table at the same time, which is something that is > currently allowed.
-
Bruce Momjian authored
> o Allow COPY on a newly-created table to skip WAL logging 450a452,456 > On crash recovery, the table involved in the COPY would > have its heap and index files truncated. One issue is > that no other backend should be able to add to the table > at the same time, which is something that is currently > allowed.
-
Bruce Momjian authored
< o Allow COPY into an empty table to skip WAL logging > o Allow COPY into an new table to skip WAL logging
-
Bruce Momjian authored
Darcy Buskermolen
-
Bruce Momjian authored
> * 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 authored
< 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 authored
> o Allow COPY into an empty table to skip WAL logging
-
Tom Lane authored
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 authored
a local array isn't guaranteed to have any particular alignment, and so it could slow down the data transfer.
-
Bruce Momjian authored
* 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 authored
under 'Populating a Database'.
-
Tom Lane authored
material in the EXPLAIN section, update examples to match current reality, show examples of bitmap indexscans as well as plain ones.
-
Bruce Momjian authored
< * 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.
-
- 01 Sep, 2005 6 commits
-
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
context since the previous AllocSetReset. Original patch by Atsushi Ogawa, editorialized on a little bit by Tom Lane.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
- 30 Aug, 2005 9 commits
-
-
Bruce Momjian authored
> * Eventually enable escape_string_warning and standard_conforming_strings
-
Bruce Momjian authored
Gavin Sherry
-
Tom Lane authored
fit into a 512K shared memory segment.
-
Tom Lane authored
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 authored
-
Tom Lane authored
per Bruce's suggestion.
-
Tom Lane authored
Per report from Jaime Casanova.
-
Tom Lane authored
-
Tom Lane authored
reality.
-
- 29 Aug, 2005 4 commits
-
-
Tom Lane authored
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 authored
it can be done right. Allow explicit use of absolute DataDir path. Per Dave Page.
-
Tom Lane authored
-
Bruce Momjian authored
will use pthreadGC2. Dave Page
-