- 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.
-
- 21 8月, 2005 2 次提交
-
-
由 Tom Lane 提交于
in postgresql.conf.sample, mark custom_variable_classes as SIGHUP not POSTMASTER to agree with the documentation (I can't see a reason it has to be POSTMASTER so I think the docs are right).
-
由 Tom Lane 提交于
to 'Size' (that is, size_t), and install overflow detection checks in it. This allows us to remove the former arbitrary restrictions on NBuffers etc. It won't make any difference in a 32-bit machine, but in a 64-bit machine you could theoretically have terabytes of shared buffers. (How efficiently we could manage 'em remains to be seen.) Similarly, num_temp_buffers, work_mem, and maintenance_work_mem can be set above 2Gb on a 64-bit machine. Original patch from Koichi Suzuki, additional work by moi.
-
- 19 8月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
the right to stand out.
-
- 12 8月, 2005 1 次提交
-
-
由 Tom Lane 提交于
delay and limit, both as global GUCs and as table-specific entries in pg_autovacuum. stats_reset_on_server_start is now OFF by default, but a reset is forced if we did WAL replay. XID-wrap vacuums do not ANALYZE, but do FREEZE if it's a template database. Alvaro Herrera
-
- 09 8月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
-