| Commit message (Collapse) | Author | Age |
... | |
|
|
|
|
| |
if their source or target types match the pattern (using the same definition
of "match" as \dT does). Per recent discussion.
|
|
|
|
|
| |
index column numbers needs to handle the case where you have more than
one scankey on the same index column. toast_fetch_datum_slice() needs it.
|
| |
|
|
|
|
| |
to only apply if present Oid is invalid, per second thought from TGL
|
|
|
|
| |
from KaiGai Kohei
|
| |
|
|
|
|
|
|
| |
Hopefully this will forestall future confusion about their roles.
Jonah Harris
|
| |
|
|
|
|
| |
Jonah Harris
|
|
|
|
|
| |
the proc->argnames array has to be initialized to zero immediately on creation,
since the error recovery path will try to free its elements.
|
|
|
|
| |
Author: Robert Haas <robertmhaas@gmail.com>
|
| |
|
|
|
|
|
| |
almost certainly represents user error. Per a gripe from Sebastian Böhm
and subsequent discussion.
|
|
|
|
| |
code beautification.
|
| |
|
|
|
|
|
|
|
| |
data type. This patch takes the approach of allowing an optional hyphen after
each group of four hex digits.
Author: Robert Haas <robertmhaas@gmail.com>
|
|
|
|
| |
stable not immutable, since it depends on system catalog contents.
|
|
|
|
|
|
| |
by splitting it into three functions with better-defined behaviors.
Zdenek Kotala
|
| |
|
| |
|
|
|
|
|
|
|
|
| |
from COMMITTED to SUBCOMMITTED during recovery. This wasn't previously
possible, but it is now due to the recent changes on clog commit protocol for
subtransactions.
Simon Riggs
|
|
|
|
|
|
|
|
| |
to dump sequence values cope with sequences outside the search path and/or
having names that need quoting. No back-patch needed because these are new
problems in 8.4.
Kris Jurka (also a little bit of code beautification by tgl)
|
|
|
|
| |
longstanding note in the source that this patch removes.
|
|
|
|
| |
Brendan Jurd
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
upon requests from backends, rather than on a fixed 500msec cycle. (There's
still throttling logic to ensure it writes no more often than once per
500msec, though.) This should result in a significant reduction in stats file
write traffic in typical scenarios where the stats are demanded only
infrequently.
This approach also means that the former difficulty with changing
stats_temp_directory on-the-fly has gone away, so remove the caution about
that as well as the thrashing we did to minimize the trouble window.
In passing, also fix pgstat_report_stat() so that we will send a stats
message if we have function call stats but not table stats to report;
this fixes a bug in the recent patch to support function-call stats.
Martin Pihlak
|
|
|
|
|
|
|
|
|
| |
allowed different processes to have different addresses for the shmem segment
in quite a long time, but there were still a few places left that used the
old coding convention. Clean them up to reduce confusion and improve the
compiler's ability to detect pointer type mismatches.
Kris Jurka
|
|
|
|
|
|
|
|
|
|
|
| |
and heap_deformtuple in favor of the newer functions heap_form_tuple et al
(which do the same things but use bool control flags instead of arbitrary
char values). Eliminate the former duplicate coding of these functions,
reducing the deprecated functions to mere wrappers around the newer ones.
We can't get rid of them entirely because add-on modules probably still
contain many instances of the old coding style.
Kris Jurka
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
| |
it just return void instead of sometimes returning a TupleTableSlot. SQL
functions don't need that anymore, and noplace else does either. Eliminating
the return value also means one less hassle for the ExecutorRun hook functions
that will be supported beginning in 8.4.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
on non-full-page-image WAL records, and quite arbitrarily, only if there's
less than 20% free space on the page after the insert/update (not on HOT
updates, though). The 20% cutoff should avoid most of the overhead, when
replaying a bulk insertion, for example, while ensuring that pages that
are full are marked as full in the FSM.
This is mostly to avoid the nasty worst case scenario, where you replay
from a PITR archive, and the FSM information in the base backup is really
out of date. If there was a lot of pages that the outdated FSM claims to
have free space, but don't actually have any, the first unlucky inserter
after the recovery would traverse through all those pages, just to find
out that they're full. We didn't have this problem with the old FSM
implementation, because we simply threw the FSM information away on a
non-clean shutdown.
|
|
|
|
|
|
|
|
|
| |
RETURNING clause, not just a SELECT as formerly.
A side effect of this patch is that when a set-returning SQL function is used
in a FROM clause, performance is improved because the output is collected into
a tuplestore within the function, rather than using the less efficient
value-per-call mechanism.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
functions into one ReadBufferExtended function, that takes the strategy
and mode as argument. There's three modes, RBM_NORMAL which is the default
used by plain ReadBuffer(), RBM_ZERO, which replaces ZeroOrReadBuffer, and
a new mode RBM_ZERO_ON_ERROR, which allows callers to read corrupt pages
without throwing an error. The FSM needs the new mode to recover from
corrupt pages, which could happend if we crash after extending an FSM file,
and the new page is "torn".
Add fork number to some error messages in bufmgr.c, that still lacked it.
|
| |
|
| |
|
|
|
|
| |
(also backported to 8.3)
|
|
|
|
|
|
|
|
| |
in the Global\ namespace, because it caused permission errors on
a lot of platforms.
We need to come up with something better for 8.4, but for now
revert to the pre-8.3.4 behaviour.
|
|
|
|
| |
Argentina, Brazil, Mauritius, Syria).
|
|
|
|
| |
Per gripe from Kevin Grittner. Backpatch to 8.3, where the bug was introduced.
|
| |
|
|
|
|
|
|
|
| |
This basically takes some build system code that was previously labeled
"Solaris" and ties it to the compiler rather than the operating system.
Author: Julius Stroffek <Julius.Stroffek@Sun.COM>
|
| |
|
|
|
|
| |
been optional.
|
| |
|
|
|
|
|
|
|
|
| |
backwards scan could actually happen. In particular, pass a flag to
materialize-mode SRFs that tells them whether they need to require random
access. In passing, also suppress unneeded backward-scan overhead for a
Portal's holdStore tuplestore. Per my proposal about reducing I/O costs for
tuplestores.
|