| Commit message (Collapse) | Author | Age |
... | |
|
|
|
|
|
| |
will use pthreadGC2.
Dave Page
|
|
|
|
| |
SYNC instruction.
|
|
|
|
|
| |
got an empty bitmap after any step; the remaining subplans can no longer
affect the result. Per a suggestion from Ilia Kantor.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
| |
to cope with a group name when dumping from a pre-8.1 installation.
Per report from Stefan Kaltenbrunner.
|
|
|
|
| |
are cases where it appears to have zero run cost.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
so that the latter estimates the number of groups that grouping will
produce. This is needed because it is primarily query_planner that
makes the decision between fast-start and fast-finish plans, and in the
original coding it was unable to make more than a crude rule-of-thumb
choice when the query involved grouping. This revision helps us make
saner choices for queries like SELECT ... GROUP BY ... LIMIT, as in a
recent example from Mark Kirkwood. Also move the responsibility for
canonicalizing sort_pathkeys and group_pathkeys into query_planner;
this information has to be available anyway to support the first change,
and doing it this way lets us get rid of compare_noncanonical_pathkeys
entirely.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
to copy the whole plan tree before invoking adjust_plan_varnos(); else
if there is any multiply-linked substructure, the latter might increment
some Var's varno twice. Previously there were some retail copyObject
calls inside adjust_plan_varnos, but it seems a lot safer to just dup the
whole tree first. Also, set_inner_join_references was trying to avoid
work by not recursing if a BitmapHeapScan's bitmapqualorig contained no
outer references; which was OK at the time the code was written, I think,
but now that create_bitmap_scan_plan removes duplicate clauses from
bitmapqualorig it is possible for that field to be NULL while outer
references still remain in the qpqual and/or contained indexscan nodes.
For safety, always recurse even if the BitmapHeapScan looks to be outer
reference free. Per reports from Michael Fuhr and Oleg Bartunov.
|
|
|
|
|
| |
the reference I consulted yesterday said SC does a SYNC, but apparently
this is not true on newer MIPS processors, so be safe.
|
|
|
|
| |
but for sure it's not any more broken than the prior version.
|
|
|
|
| |
code as we use on other platforms when encoding is not UTF8.
|
|
|
|
| |
definitions on recent Linux systems, per Martin Pitt.
|
| |
|
|
|
|
|
|
| |
the parent table, even if the command that creates them is executed by
someone else (such as a superuser or a member of the owning role).
Per gripe from Michael Fuhr.
|
|
|
|
| |
cover more error codes. Per Petr Jelinek.
|
|
|
|
| |
constrained GCC inline version. Thiemo Seufer, by way of Martin Pitt.
|
|
|
|
|
|
|
|
|
| |
in interval_mul and interval_div. This avoids an optimization bug
in A Certain Company's compiler (and given their explanation, I wouldn't
be surprised if other compilers blow it too). Besides the code seems
more clear this way --- in the original formulation, you had to mentally
recognize the common subexpression in order to understand what was going
on.
|
| |
|
|
|
|
|
|
| |
IPv6 is obsoleted by recent Windows patch. Perform the runtime test
whenever HAVE_IPV6 is set. This should be OK since initdb can get
getaddrinfo from libpgport if needed.
|
| |
|
| |
|
|
|
|
|
| |
has to be tested dynamically if we want to make portable executables.
Chuck McDevitt and Andrew Dunstan.
|
|
|
|
|
| |
This might be overly conservative, but we know it does not work on amd64.
Per buildfarm results.
|
| |
|
| |
|
|
|
|
| |
'my' where appropriate. Michael Fuhr
|
| |
|
|
|
|
|
| |
fly. Fix problem with incompletely duplicated setup code. Andrew Dunstan,
from an idea of Michael Fuhr's.
|
|
|
|
|
| |
is not adequately tested yet, but let's get it into beta1 so it can be
tested. Magnus Hagander and Tom Lane.
|
|
|
|
|
|
| |
triggers exist but are all disabled. Problem noted by Gavin Sherry in
original discussion of enable/disable trigger patch, but was never
addressed.
|
|
|
|
|
| |
- Remove stary character from string quoting.
- Fixed check to report missing varchar pointer implementation.
|
|
|
|
|
|
| |
use these instead of its previous hack of changing pg_class.reltriggers.
Documentation is lacking, will add that later.
Patch by Satoshi Nagayasu, review and some extra work by Tom Lane.
|
| |
|
|
|
|
|
|
|
|
| |
Windows. The test itself is bypassed in configure as discussed, and
libpq has been updated appropriately to allow it to build in thread-safe
mode.
Dave Page
|
|
|
|
|
| |
functional difference really, but make use of stuff added to the planner
since this code was touched last.
|
| |
|
| |
|
| |
|
|
|
|
| |
Per Alvaro.
|
|
|
|
|
|
|
|
|
| |
after the fact. Fix bug with incorrect test for whether we are at end
of logfile segment. Arrange for writes triggered by XLogInsert's
is-cache-more-than-half-full test to synchronize with the cache boundaries,
so that in long transactions we tend to write alternating halves of the
cache rather than randomly chosen portions of it; this saves one more
write syscall per cache load.
|
| |
|
|
|
|
|
|
|
| |
erroring out as it has done for the last couple weeks. Document that this
form is now ignored because indexes can't usefully have different owners
from their parent tables. Fix pg_dump to not generate ALTER OWNER commands
for indexes.
|
|
|
|
|
|
| |
discussion of getting around this by relaxing the checks made for regular
users, but I'm disinclined to toy with the security model right now,
so just special-case it for superusers where needed.
|
|
|
|
| |
Also improve wording.
|
|
|
|
|
|
|
|
|
| |
not accepting queries).
errmsg("database is not accepting queries to avoid
wraparound data loss in database \"%s\"",
errhint("Stop the postmaster and use a standalone
backend to VACUUM database \"%s\".",
|