| Commit message (Collapse) | Author | Age |
... | |
| |
|
|
|
|
| |
per recent discussions.
|
|
|
|
| |
isn't loaded into the database.
|
|
|
|
|
| |
feature they complain about isn't a feature or cannot be implemented without
definitional changes.
|
| |
|
|
|
|
| |
system headers on Unixware.
|
|
|
|
|
|
|
|
| |
sequence every time it's called is bogus --- it interferes with user
control over the seed, and actually decreases randomness overall
(because a seed based on time(NULL) is pretty predictable). If you really
want a reproducible result from geqo, do 'set seed = 0' before planning
a query.
|
|
|
|
|
| |
by recent IPv6 changes, and since it's redundant with a kernel-level check
anyway, it seems not worth trying to fix it. Per recent discussions.
|
|
|
|
| |
set HAVE_IPV6. Per recent discussions.
|
|
|
|
|
|
|
| |
on either name or inode; otherwise load_external_function() won't do
anything. At least on Linux, it appears that recompiling a shlib leads
to a new file with a different inode, so the old code failed to detect
a match.
|
|
|
|
|
| |
error. There is no point in providing some kind of forward compatibility
now, because no one can tell what a future implementation will look like.
|
|
|
|
| |
returned by getaddrinfo_all will have enough room for an IPv6 address.
|
|
|
|
| |
that have IPv4-embedded-in-IPv6 addresses. Per idea of Andreas Pflug.
|
|
|
|
|
| |
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
|
|
|
|
|
|
|
|
| |
pghackers. This fixes the problem recently reported by Markus KrÌutner
(hash bucket split corrupts the state of scans being done concurrently),
and I believe it also fixes all the known problems with deadlocks in
hash index operations. Hash indexes are still not really ready for prime
time (since they aren't WAL-logged), but this is a step forward.
|
|
|
|
| |
grantees.
|
|
|
|
|
| |
administrator has not turned it on, and fix other PGC_USERLIMIT
variables.
|
| |
|
| |
|
|
|
|
| |
accordingly.
|
| |
|
|
|
|
| |
From Karel Zak.
|
|
|
|
|
|
|
|
| |
killed items; just skip to the next item immediately. Only check for
key equality when we reach a non-killed item or the end of the index
page. This saves key comparisons when there are lots of killed items,
as for example in a heavily-updated table that's not been vacuumed lately.
Seems to be a win for pgbench anyway.
|
|
|
|
|
|
|
|
|
|
| |
config file if it exists. This was already discussed as being a good
idea, and now seems the cleanest way to deal with initdb-time failures
on machines with small SHMMAX. (The submitted patches instead modified
initdb.sh to pass the correct sizing parameters, but that would still
leave standalone backends prone to failure later. An admin who needs
to use a standalone backend has enough trouble already, he shouldn't
have to manually configure its shmem settings...)
|
|
|
|
|
|
|
|
|
| |
layout; therefore, this change forces REINDEX of hash indexes (though
not a full initdb). Widen hashm_ntuples to double so that hash space
management doesn't get confused by more than 4G entries; enlarge the
allowed number of free-space-bitmap pages; replace the useless bshift
field with a useful bmshift field; eliminate 4 bytes of wasted space
in the per-page special area.
|
| |
|
|
|
|
|
|
|
| |
scheme. A pleasant side effect is that it is *much* faster when deleting
a large fraction of the indexed tuples, because of elimination of
redundant hash_step activity induced by hash_adjscans. Various other
continuing code cleanup.
|
|
|
|
|
|
| |
libpq, talking to an old server, should assume SQL_ASCII as the default
client encoding, because that is what the server will actually use (not
the server encoding).
|
|
|
|
|
|
|
|
|
| |
yet). Fix a couple of bugs that would only appear if multiple bitmap pages
are used, including a buffer reference leak and incorrect computation of bit
indexes. Get rid of 'overflow address' concept, which accomplished nothing
except obfuscating the code and creating a risk of failure due to limited
range of offset field. Rename some misleadingly-named fields and routines,
and improve documentation.
|
|
|
|
|
|
| |
explanation of the remarkably confusing page addressing scheme.
The file also includes my planned-but-not-yet-implemented revision
of the hash index locking scheme.
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
| |
SQLSTATE error codes required by SQL99 (invalid format, datetime field
overflow, interval field overflow, invalid time zone displacement value).
Also emit a HINT about DateStyle in cases where it seems appropriate.
Per recent gripes.
|
| |
|
| |
|
|
|
|
| |
only scan plans. Per observation from Rod Taylor.
|
| |
|
|
|
|
|
|
|
| |
lumping them into ERRCODE_UNDEFINED_OBJECT/ERRCODE_DUPLICATE_OBJECT.
This seems reasonable since 'object' was meant to refer to 'object in the
database' and a file is outside the database. Per request from Dave
Cramer.
|
|
|
|
|
|
|
| |
interesting info in verbose mode about the analyzed relation (pages,
rows per block and rows).
Mark Kirkwood
|
|
|
|
|
|
| |
max_connections at initdb time. Get rid of DEF_NBUFFERS and DEF_MAXBACKENDS
macros, which aren't doing anything useful anymore, and put more likely
defaults into postgresql.conf.sample.
|
|
|
|
|
| |
ACT and ACST were already present. AMT and AMST conflict with the
existing entries for Armenia; no change there for the moment.
|
|
|
|
|
| |
syntax '040506' for '04:05:06', as well as '0405' for '04:05:00'. This
has been broken since 7.2 but was only recently complained of.
|
|
|
|
|
|
|
| |
perform a timestamp-to-date coercion. Instead both routines share a
subroutine that delivers the parsing result as a struct tm. This avoids
problems with timezone dependency of to_date's result, and should be
at least marginally faster too.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
| |
expr_lists. This appears to be the only remaining O(N^2) bottleneck
in processing many-way 'x IN (a,b,c,...)' conditions.
|