- 10 1月, 2007 1 次提交
-
-
由 Bruce Momjian 提交于
Bill Moran
-
- 21 11月, 2006 1 次提交
-
-
由 Tom Lane 提交于
recent discussion in which majority opinion was that this is a more widely useful setting than the previous default of PANIC.
-
- 06 11月, 2006 1 次提交
-
-
由 Tom Lane 提交于
in PITR scenarios. We now WAL-log the replacement of old XIDs with FrozenTransactionId, so that such replacement is guaranteed to propagate to PITR slave databases. Also, rather than relying on hint-bit updates to be preserved, pg_clog is not truncated until all instances of an XID are known to have been replaced by FrozenTransactionId. Add new GUC variables and pg_autovacuum columns to allow management of the freezing policy, so that users can trade off the size of pg_clog against the amount of freezing work done. Revise the already-existing code that forces autovacuum of tables approaching the wraparound point to make it more bulletproof; also, revise the autovacuum logic so that anti-wraparound vacuuming is done per-table rather than per-database. initdb forced because of changes in pg_class, pg_database, and pg_autovacuum catalogs. Heikki Linnakangas, Simon Riggs, and Tom Lane.
-
- 05 10月, 2006 1 次提交
-
-
由 Tom Lane 提交于
-
- 04 10月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
postgresql.conf. - shared_buffers = 32000kB => 32MB - temp_buffers = 8000kB => 8MB - wal_buffers = 8 => 64kB The code of initdb was a bit modified to write MB-unit values. Values greater than 8000kB are rounded out to MB. GUC_UNIT_XBLOCKS is added for wal_buffers. It is like GUC_UNIT_BLOCKS, but uses XLOG_BLCKSZ instead of BLCKSZ. Also, I cleaned up the test of GUC_UNIT_* flags in preparation to add more unit flags in less bits. ITAGAKI Takahiro
-
- 03 10月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
stats_start_collector and stats_row_level to also be on David Wheeler
-
- 26 9月, 2006 1 次提交
-
-
由 Tom Lane 提交于
-
- 23 9月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
match what SHOW displays as default value, to make the user experience uniform.
-
- 15 9月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
comment alignment on most systems.
-
- 03 9月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
--- was part of autovacuum default 'on' patch that was reverted, but we want this part. Peter Eisentraut
-
由 Bruce Momjian 提交于
-
- 29 8月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
-
- 28 8月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
Threshold and scale factor are cut in half for more aggressive behavior.
-
- 18 8月, 2006 1 次提交
-
-
由 Tom Lane 提交于
than N seconds apart. This allows a simple, if not very high performance, means of guaranteeing that a PITR archive is no more than N seconds behind real time. Also make pg_current_xlog_location return the WAL Write pointer, add pg_current_xlog_insert_location to return the Insert pointer, and fix pg_xlogfile_name_offset to return its results as a two-element record instead of a smashed-together string, as per recent discussion. Simon Riggs
-
- 16 8月, 2006 1 次提交
-
-
由 Tom Lane 提交于
such as debugging and performance measurement. This consists of two features: a table of "rendezvous variables" that allows separately-loaded shared libraries to communicate, and a new GUC setting "local_preload_libraries" that allows libraries to be loaded into specific sessions without explicit cooperation from the client application. To make local_preload_libraries as flexible as possible, we do not restrict its use to superusers; instead, it is restricted to load only libraries stored in $libdir/plugins/. The existing LOAD command has also been modified to allow non-superusers to LOAD libraries stored in this directory. This patch also renames the existing GUC variable preload_libraries to shared_preload_libraries (after a suggestion by Simon Riggs) and does some code refactoring in dfmgr.c to improve clarity. Korry Douglas, with a little help from Tom Lane.
-
- 03 8月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
'mod' and 'all', which is not the right order. SGML documentation order was correct. Report from Chander Ganesan.
-
- 25 7月, 2006 1 次提交
-
-
由 Tom Lane 提交于
configuration files that can be altered by a DBA. The australian_timezones GUC setting disappears, replaced by a timezone_abbreviations setting (set this to 'Australia' to get the effect of australian_timezones). The list of zone names defined by default has undergone a bit of cleanup, too. Documentation still needs some work --- in particular, should we fix Table B-4, or just get rid of it? Joachim Wieland, with some editorializing by moi.
-
- 24 7月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
editing and reformatting.
-
- 28 6月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
for every command, default to on.
-
由 Bruce Momjian 提交于
-
- 19 6月, 2006 1 次提交
-
-
由 Tom Lane 提交于
current commands; instead, store current-status information in shared memory. This substantially reduces the overhead of stats_command_string and also ensures that pg_stat_activity is fully up to date at all times. Per my recent proposal.
-
- 05 6月, 2006 2 次提交
-
-
由 Tom Lane 提交于
This shouldn't affect simple indexscans much, while for bitmap scans that are touching a lot of index rows, this seems to bring the estimates more in line with reality. Per recent discussion.
-
由 Tom Lane 提交于
assumed that a sequential page fetch has cost 1.0. This patch doesn't in itself change the system's behavior at all, but it opens the door to people adopting other units of measurement for EXPLAIN costs. Also, if we ever decide it's worth inventing per-tablespace access cost settings, this change provides a workable intellectual framework for that.
-
- 22 5月, 2006 1 次提交
-
-
由 Tom Lane 提交于
parser will allow "\'" to be used to represent a literal quote mark. The "\'" representation has been deprecated for some time in favor of the SQL-standard representation "''" (two single quote marks), but it has been used often enough that just disallowing it immediately won't do. Hence backslash_quote allows the settings "on", "off", and "safe_encoding", the last meaning to allow "\'" only if client_encoding is a valid server encoding. That is now the default, and the reason is that in encodings such as SJIS that allow 0x5c (ASCII backslash) to be the last byte of a multibyte character, accepting "\'" allows SQL-injection attacks as per CVE-2006-2314 (further details will be published after release). The "on" setting is available for backward compatibility, but it must not be used with clients that are exposed to untrusted input. Thanks to Akio Ishida and Yasuo Ohgaki for identifying this security issue.
-
- 12 5月, 2006 1 次提交
-
-
由 Tom Lane 提交于
throw warnings for 100%-SQL-standard constructs, clean up some minor infelicities, try to un-break ecpg to the best of my ability. (It's not clear how ecpg is going to find out the setting of standard_conforming_strings, though.) I think pg_dump still needs work, too.
-
- 07 3月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
escape_string_warning = on
-
由 Bruce Momjian 提交于
Kevin Grittner
-
- 24 12月, 2005 1 次提交
-
-
由 Tom Lane 提交于
postgresql.conf.sample too.
-
- 23 12月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
SET.
-
- 18 11月, 2005 1 次提交
-
-
由 Tom Lane 提交于
functionality, but I still need to make another pass looking at places that incidentally use arrays (such as ACL manipulation) to make sure they are null-safe. Contrib needs work too. I have not changed the behaviors that are still under discussion about array comparison and what to do with lower bounds.
-
- 10 11月, 2005 2 次提交
-
-
由 Andrew Dunstan 提交于
add missing quote mark to ident_file sample line - per Hiroshi Saito
-
由 Tom Lane 提交于
-
- 09 10月, 2005 1 次提交
-
-
由 Tom Lane 提交于
to call krb5_sname_to_principal() always. Also, use krb_srvname rather than the hardwired string 'postgres' as the appl_version string in the krb5_sendauth/recvauth calls, to avoid breaking compatibility with PG 8.0. Magnus Hagander
-
- 20 9月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 12 9月, 2005 1 次提交
-
-
由 Tom Lane 提交于
to drop connections unceremoniously. Also some other marginal cleanups: don't query getsockopt() repeatedly if it fails, and avoid having the apparent definition of struct Port depend on which system headers you might have included or not. Oliver Jowett and Tom Lane.
-
- 03 9月, 2005 2 次提交
-
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
Darcy Buskermolen
-
- 30 8月, 2005 2 次提交
-
-
由 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.
-
- 23 8月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
Also improve wording.
-