- 09 2月, 2011 7 次提交
-
-
由 Tom Lane 提交于
This patch adds the server infrastructure to support extensions. There is still one significant loose end, namely how to make it play nice with pg_upgrade, so I am not yet committing the changes that would make all the contrib modules depend on this feature. In passing, fix a disturbingly large amount of breakage in AlterObjectNamespace() and callers. Dimitri Fontaine, reviewed by Anssi Kääriäinen, Itagaki Takahiro, Tom Lane, and numerous others
-
由 Peter Eisentraut 提交于
This adds collation support for columns and domains, a COLLATE clause to override it per expression, and B-tree index support. Peter Eisentraut reviewed by Pavel Stehule, Itagaki Takahiro, Robert Haas, Noah Misch
-
由 Heikki Linnakangas 提交于
-
由 Simon Riggs 提交于
-
由 Simon Riggs 提交于
new recovery.conf parameter recovery_target_name allows PITR to specify named points as recovery targets. Jaime Casanova, reviewed by Euler Taveira de Oliveira, plus minor edits
-
由 Simon Riggs 提交于
Status check functions only. Also, new recovery.conf parameter to pause_at_recovery_target, default on. Simon Riggs, reviewed by Fujii Masao
-
由 Heikki Linnakangas 提交于
-
- 08 2月, 2011 6 次提交
-
-
由 Simon Riggs 提交于
If the standby was streaming when trigger file arrives, check also in the archive for additional WAL files. This is a corner case since it is unlikely that we would trigger a failover while the master is still available and sending data to standby, while at the same time running in archive mode and also while the streaming standby has fallen behind archive. Someone would eventually be unlucky; we must plug all gaps however small. Fujii Masao
-
由 Simon Riggs 提交于
FK constraints that are marked NOT VALID may later be VALIDATED, which uses an ShareUpdateExclusiveLock on constraint table and RowShareLock on referenced table. Significantly reduces lock strength and duration when adding FKs. New state visible from psql. Simon Riggs, with reviews from Marko Tiikkaja and Robert Haas
-
由 Heikki Linnakangas 提交于
about uninitialized field you get on some compilers.
-
由 Robert Haas 提交于
Waiting for relation locks can lead to starvation - it pins down an autovacuum worker for as long as the lock is held. But if we're doing an anti-wraparound vacuum, then we still wait; maintenance can no longer be put off. To assist with troubleshooting, if log_autovacuum_min_duration >= 0, we log whenever an autovacuum or autoanalyze is skipped for this reason. Per a gripe by Josh Berkus, and ensuing discussion.
-
由 Heikki Linnakangas 提交于
I thought we didn't need that, but then I remembered that it added a new SLRU subdirectory, pg_serial. While we're at it, document what pg_serial is.
-
由 Heikki Linnakangas 提交于
Until now, our Serializable mode has in fact been what's called Snapshot Isolation, which allows some anomalies that could not occur in any serialized ordering of the transactions. This patch fixes that using a method called Serializable Snapshot Isolation, based on research papers by Michael J. Cahill (see README-SSI for full references). In Serializable Snapshot Isolation, transactions run like they do in Snapshot Isolation, but a predicate lock manager observes the reads and writes performed and aborts transactions if it detects that an anomaly might occur. This method produces some false positives, ie. it sometimes aborts transactions even though there is no anomaly. To track reads we implement predicate locking, see storage/lmgr/predicate.c. Whenever a tuple is read, a predicate lock is acquired on the tuple. Shared memory is finite, so when a transaction takes many tuple-level locks on a page, the locks are promoted to a single page-level lock, and further to a single relation level lock if necessary. To lock key values with no matching tuple, a sequential scan always takes a relation-level lock, and an index scan acquires a page-level lock that covers the search key, whether or not there are any matching keys at the moment. A predicate lock doesn't conflict with any regular locks or with another predicate locks in the normal sense. They're only used by the predicate lock manager to detect the danger of anomalies. Only serializable transactions participate in predicate locking, so there should be no extra overhead for for other transactions. Predicate locks can't be released at commit, but must be remembered until all the transactions that overlapped with it have completed. That means that we need to remember an unbounded amount of predicate locks, so we apply a lossy but conservative method of tracking locks for committed transactions. If we run short of shared memory, we overflow to a new "pg_serial" SLRU pool. We don't currently allow Serializable transactions in Hot Standby mode. That would be hard, because even read-only transactions can cause anomalies that wouldn't otherwise occur. Serializable isolation mode now means the new fully serializable level. Repeatable Read gives you the old Snapshot Isolation level that we have always had. Kevin Grittner and Dan Ports, reviewed by Jeff Davis, Heikki Linnakangas and Anssi Kääriäinen
-
- 07 2月, 2011 6 次提交
-
-
由 Itagaki Takahiro 提交于
We forgot to adjust it when we changed relistemp to relpersistence.
-
由 Andrew Dunstan 提交于
-
由 Itagaki Takahiro 提交于
They are extracted from COPY API patch. suggested by Noah Misch
-
由 Bruce Momjian 提交于
-
由 Andrew Dunstan 提交于
String are converted to UTF8 on the way into perl and to the database encoding on the way back. This avoids a number of observed anomalies, and ensures Perl a consistent view of the world. Some minor code cleanups are also accomplished. Alex Hunsaker, reviewed by Andy Colson.
-
由 Bruce Momjian 提交于
using an itemized list.
-
- 06 2月, 2011 3 次提交
-
-
由 Bruce Momjian 提交于
done for a few other macros in that file, for other reasons. I also remove pgindent/README mention of the file.
-
由 Magnus Hagander 提交于
-
由 Robert Haas 提交于
If the foreign table's rowtype is being used as the type of a column in another table, we can't just up and change its data type. This was already checked for composite types and ordinary tables, but we previously failed to enforce it for foreign tables.
-
- 05 2月, 2011 8 次提交
-
-
由 Bruce Momjian 提交于
longjump.
-
由 Andrew Dunstan 提交于
-
由 Bruce Momjian 提交于
-
由 Robert Haas 提交于
Make sure it's clear that the prohibition on adding a column with a default when the rowtype is used elsewhere is intentional, and be a bit more explicit about the other cases where we perform this check.
-
由 Robert Haas 提交于
It's full of backend-specific error reporting, so it's neither possible nor necessary for this to be used from frontend code.
-
由 Bruce Momjian 提交于
libpq doc mentions.
-
由 Robert Haas 提交于
This isn't kosher, and doesn't play nicely with my recent changes to the Makefile in this directory.
-
由 Robert Haas 提交于
Remove the claim that ALTER TABLE .. SET DATA TYPE is the fastest way of rewriting a table, since it no longer is. Noah Misch and Robert Haas, based on a suggestion from Tom Lane.
-
- 04 2月, 2011 10 次提交
-
-
由 Robert Haas 提交于
Per buildfarm.
-
由 Robert Haas 提交于
This fixes make distprep, and seems more robust in other ways as well. Some special handling is required because errcodes.txt is needed by some stuff in src/port, but just by src/backend as is the case for the other generated headers. While I'm at it, fix a few other things that were overlooked in the original patch.
-
由 Magnus Hagander 提交于
Another case of <xref linkend> in the documentation that builds INSTALL, which is not allowed.
-
由 Robert Haas 提交于
More fallout from ddfe26f6. Report by Fujii Masao.
-
由 Magnus Hagander 提交于
In the hope of unbreaking the buildfarm
-
由 Robert Haas 提交于
My commit ddfe26f6 of 2010-02-03 broke it. Per buildfarm.
-
由 Robert Haas 提交于
-
由 Robert Haas 提交于
src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a big chunk of errcodes.sgml are now automatically generated from a single file, src/backend/utils/errcodes.txt. Jan Urbański, reviewed by Tom Lane.
-
由 Robert Haas 提交于
Along the way, be more consistent about the wording we use here.
-
由 Bruce Momjian 提交于
Satoshi Nagayasu
-