- 31 1月, 2008 1 次提交
-
-
由 Tom Lane 提交于
synchronized-scanning behavior, and make pg_dump disable sync scans so that it will reliably preserve row ordering. Per recent discussions.
-
- 28 1月, 2008 1 次提交
-
-
由 Tom Lane 提交于
in particular correct the obsolete claim that it can't be changed once any plans have been cached.
-
- 21 1月, 2008 1 次提交
-
-
由 Tom Lane 提交于
-
- 12 12月, 2007 1 次提交
-
-
由 Alvaro Herrera 提交于
-
- 11 12月, 2007 1 次提交
-
-
由 Alvaro Herrera 提交于
with the logged event. CSV logs are now a first-class citizen along plain text logs in that they carry much of the same information. Per complaint from depesz on bug #3799.
-
- 28 11月, 2007 2 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
Joshua D. Drake
-
- 19 11月, 2007 1 次提交
-
-
由 Tom Lane 提交于
ambiguity and say what the default value is.
-
- 10 11月, 2007 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Magnus Hagander 提交于
to validate the realm of the connecting user. By default it's empty meaning no verification, which is the way Kerberos authentication has traditionally worked in PostgreSQL.
-
- 06 11月, 2007 1 次提交
-
-
由 Bruce Momjian 提交于
multi-statement transaction.
-
- 02 11月, 2007 1 次提交
-
-
由 Bruce Momjian 提交于
parameter name makes more sense.
-
- 20 10月, 2007 1 次提交
-
-
由 Tom Lane 提交于
the syslog configuration file (at least not on most known Unixen). I dunno why we hadn't had that info in the docs all along ...
-
- 10 10月, 2007 1 次提交
-
-
由 Neil Conway 提交于
per Guillaume Lelarge.
-
- 28 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
the same transaction can be identified even when no regular XID was assigned. This seems essential after addition of the lazy-XID patch. Also some minor code cleanup in write_csvlog().
-
- 27 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
- create a separate archive_mode GUC, on which archive_command is dependent - %r option in recovery.conf sends last restartpoint to recovery command - %r used in pg_standby, updated README - minor other code cleanup in pg_standby - doc on Warm Standby now mentions pg_standby and %r - log_restartpoints recovery option emits LOG message at each restartpoint - end of recovery now displays last transaction end time, as requested by Warren Little; also shown at each restartpoint - restart archiver if needed to carry away WAL files at shutdown Simon Riggs
-
- 26 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
buffers that cannot possibly need to be cleaned, and estimates how many buffers it should try to clean based on moving averages of recent allocation requests and density of reusable buffers. The patch also adds a couple more columns to pg_stat_bgwriter to help measure the effectiveness of the bgwriter. Greg Smith, building on his own work and ideas from several other people, in particular a much older patch from Itagaki Takahiro.
-
- 24 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
* stats_start_collector goes away; we always start the collector process, unless prevented by a problem with setting up the stats UDP socket. * stats_reset_on_server_start goes away; it seems useless in view of the availability of pg_stat_reset(). * stats_block_level and stats_row_level are merged into a single variable "track_counts", which controls all reports sent to the collector process. * stats_command_string is renamed to track_activities. * log_autovacuum is renamed to log_autovacuum_min_duration to better reflect its meaning. The log_autovacuum change is not a compatibility issue since it didn't exist before 8.3 anyway. The other changes need to be release-noted.
-
- 23 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
syslog and eventlog severity levels, per suggestion from Josh Drake. Also, some wordsmithing for the csvlog documentation.
-
- 10 9月, 2007 2 次提交
- 06 9月, 2007 1 次提交
-
-
由 Tom Lane 提交于
rows will normally never obtain an XID at all. We already did things this way for subtransactions, but this patch extends the concept to top-level transactions. In applications where there are lots of short read-only transactions, this should improve performance noticeably; not so much from removal of the actual XID-assignments, as from reduction of overhead that's driven by the rate of XID consumption. We add a concept of a "virtual transaction ID" so that active transactions can be uniquely identified even if they don't have a regular XID. This is a much lighter-weight concept: uniqueness of VXIDs is only guaranteed over the short term, and no on-disk record is made about them. Florian Pflug, with some editorialization by Tom.
-
- 22 8月, 2007 1 次提交
-
-
由 Tom Lane 提交于
syncing the existing docs with the final syntax decisions.
-
- 21 8月, 2007 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 19 8月, 2007 2 次提交
-
-
由 Andrew Dunstan 提交于
-
由 Andrew Dunstan 提交于
redirect_stderr to logging_collector. Original patch from Arul Shaji, subsequently modified by Greg Smith, and then heavily modified by me.
-
- 14 8月, 2007 1 次提交
-
-
由 Tom Lane 提交于
thorough testing of async-commit mode from the buildfarm. This patch MUST get reverted before 8.3 release!
-
- 04 8月, 2007 1 次提交
-
-
由 Tom Lane 提交于
displayed in the postmaster log. This avoids Windows-specific problems with localized time zone names that are in the wrong encoding, and generally seems like a good idea to forestall other potential platform-dependent issues. To preserve the existing behavior that all backends will log in the same time zone, create a new GUC variable log_timezone that can only be changed on a system-wide basis, and reference log-related calculations to that zone instead of the TimeZone variable. This fixes the issue reported by Hiroshi Saito that timestamps printed by xlog.c startup could be improperly localized on Windows. We still need a simpler patch for that problem in the back branches, however.
-
- 03 8月, 2007 1 次提交
-
-
由 Andrew Dunstan 提交于
so that we will be able to create a cookie for all processes for CSVlogs. It is set wherever MyProcPid is set. Take the opportunity to remove the now unnecessary session-only restriction on the %s and %c escapes in log_line_prefix.
-
- 02 8月, 2007 1 次提交
-
-
由 Tom Lane 提交于
before reporting a transaction committed. Data consistency is still guaranteed (unlike setting fsync = off), but a crash may lose the effects of the last few transactions. Patch by Simon, some editorialization by Tom.
-
- 24 7月, 2007 2 次提交
-
-
由 Tom Lane 提交于
and fsync WAL at convenient intervals. For the moment it just tries to offload this work from backends, but soon it will be responsible for guaranteeing a maximum delay before asynchronously-committed transactions will be flushed to disk. This is a portion of Simon Riggs' async-commit patch, committed to CVS separately because a background WAL writer seems like it might be a good idea independently of the async-commit feature. I rebased walwriter.c on bgwriter.c because it seemed like a more appropriate way of handling signals; while the startup/shutdown logic in postmaster.c is more like autovac because we want walwriter to quit before we start the shutdown checkpoint.
-
由 Alvaro Herrera 提交于
I/O utilization, per discussion. While at it, lower the autovacuum vacuum and analyze threshold values to 50 tuples. It is a bit higher (i.e. more conservative) than what I originally proposed but much better than the old values for small tables.
-
- 18 7月, 2007 1 次提交
-
-
由 Magnus Hagander 提交于
-
- 01 7月, 2007 1 次提交
-
-
由 Tom Lane 提交于
by Heikki and a little bit by me.
-
- 28 6月, 2007 1 次提交
-
-
由 Tom Lane 提交于
over a fairly long period of time, rather than being spat out in a burst. This happens only for background checkpoints carried out by the bgwriter; other cases, such as a shutdown checkpoint, are still done at full speed. Remove the "all buffers" scan in the bgwriter, and associated stats infrastructure, since this seems no longer very useful when the checkpoint itself is properly throttled. Original patch by Itagaki Takahiro, reworked by Heikki Linnakangas, and some minor API editorialization by me.
-
- 23 6月, 2007 1 次提交
-
-
由 Tom Lane 提交于
provide visual separation from the rest of the log line; I've been noticing lately that quite a few newbies fail to figure this out for themselves. Also a little editorial cleanup of the log_line_prefix description.
-
- 20 6月, 2007 1 次提交
-
-
由 Tom Lane 提交于
within a signal handler (this might be safe given the relatively narrow code range in which the interrupt is enabled, but it seems awfully risky); do issue more informative log messages that tell what is being waited for and the exact length of the wait; minor other code cleanup. Greg Stark and Tom Lane
-
- 08 6月, 2007 1 次提交
-
-
由 Tom Lane 提交于
for each temp file, rather than once per sort or hashjoin; this allows spreading the data of a large sort or join across multiple tablespaces. (I remain dubious that this will make any difference in practice, but certain people insisted.) Arrange to cache the results of parsing the GUC variable instead of recomputing from scratch on every demand, and push usage of the cache down to the bottommost fd.c level.
-
- 04 6月, 2007 1 次提交
-
-
由 Tom Lane 提交于
tablespace(s) in which to store temp tables and temporary files. This is a list to allow spreading the load across multiple tablespaces (a random list element is chosen each time a temp object is to be created). Temp files are not stored in per-database pgsql_tmp/ directories anymore, but per-tablespace directories. Jaime Casanova and Albert Cervera, with review by Bernd Helmle and Tom Lane.
-
- 18 5月, 2007 1 次提交
-
-
由 Neil Conway 提交于
-