- 30 Oct, 2008 3 commits
-
-
Tom Lane authored
Argentina, Brazil, Mauritius, Syria).
-
Peter Eisentraut authored
-
Tom Lane authored
Per gripe from Kevin Grittner. Backpatch to 8.3, where the bug was introduced.
-
- 29 Oct, 2008 8 commits
-
-
Peter Eisentraut authored
-
Peter Eisentraut authored
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>
-
Bruce Momjian authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
been optional.
-
Peter Eisentraut authored
align strings in the --help output. Do this through our abstraction layer to eliminate redundancy and randomness in configure.in.
-
Peter Eisentraut authored
-
Tom Lane authored
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.
-
- 28 Oct, 2008 5 commits
-
-
Tom Lane authored
via a tuplestore instead of value-per-call. Refactor a few things to reduce ensuing code duplication with nodeFunctionscan.c. This represents the reasonably noncontroversial part of my proposed patch to switch SQL functions over to returning tuplestores. For the moment, SQL functions still do things the old way. However, this change enables PL SRFs to be called in targetlists (observe changes in plperl regression results).
-
Tom Lane authored
didn't actually work, because nodeRecursiveunion.c creates the underlying tuplestore with backward scan disabled; which is a decision that we shouldn't reverse because of performance cost. We could imagine adding signaling from WorkTableScan to RecursiveUnion about whether backward scan is needed ... but in practice it'd be a waste of effort, because there simply isn't any current or plausible future scenario where WorkTableScan would be called on to scan backward. So just dike out the code that claims to support it.
-
Tom Lane authored
written to temp files by tuplesort.c and tuplestore.c. This saves 2 bytes per row for 32-bit machines, and 6 bytes per row for 64-bit machines, which seems worth the slight additional uglification of the tuple read/write routines.
-
Peter Eisentraut authored
Also, since WITH is now a reserved word, simplify the token merging code to only deal with WITH_TIME. by Tom Lane and myself
-
Magnus Hagander authored
This breaks compatibility with pre-7.2 versions.
-
- 27 Oct, 2008 9 commits
-
-
Alvaro Herrera authored
-
Alvaro Herrera authored
they are freezing a nonzero amount anyway.
-
Magnus Hagander authored
-
Tom Lane authored
recursion when we are unable to convert a localized error message to the client's encoding. We've been over this ground before, but as reported by Ibrar Ahmed, it still didn't work in the case of conversion failures for the conversion-failure message itself :-(. Fix by installing a "circuit breaker" that disables attempts to localize this message once we get into recursion trouble. Patch all supported branches, because it is in fact broken in all of them; though I had to add some missing translations to the older branches in order to expose the failure in the particular test case I was using.
-
Magnus Hagander authored
after each other (since we already add a newline on each, this makes them multiline). Previously a new error would just overwrite the old one, so for example any error caused when trying to connect with SSL enabled would be overwritten by the error message form the non-SSL connection when using sslmode=prefer.
-
Peter Eisentraut authored
-
Magnus Hagander authored
libpq events code. Hiroshi Saito
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- 26 Oct, 2008 1 commit
-
-
Tom Lane authored
treat Var and non-Var IN-list items differently. Only non-Var items are candidates to go into an ANY(ARRAY) construct --- we put all Vars as separate OR conditions on the grounds that that leaves more scope for optimization. Per suggestion from Robert Haas.
-
- 25 Oct, 2008 2 commits
-
-
Tom Lane authored
only the outer side can be pushed down rather than having to be evaluated at the join.
-
Tom Lane authored
into an OR of equality comparisons, rather than x = ANY(ARRAY[...]), when there are Vars in the right-hand side. This avoids a performance regression compared to pre-8.2 releases, in cases where the OR form can be optimized into scans of multiple indexes. Limit the possible downside by preferring this form only when the list isn't very long (I set the cutoff at 32 elements, which is a bit arbitrary but in the right ballpark). Per discussion with Jim Nasby. In passing, also make it try the OR form if it cannot select a common type for the array elements; we've seen a complaint or two about how the OR form worked for such cases and ARRAY doesn't.
-
- 24 Oct, 2008 5 commits
-
-
Tom Lane authored
recent proposal. In typical cases, we now need 12 bytes per insert or delete event and 16 bytes per update event; previously we needed 40 bytes per event on 32-bit hardware and 80 bytes per event on 64-bit hardware. Even in the worst case usage pattern with a large number of distinct triggers being fired in one query, usage is at most 32 bytes per event. It seems to be a bit faster than the old code as well, due to reduction of palloc overhead. This commit doesn't address the TODO item of allowing the event list to spill to disk; rather it's trying to stave off the need for that. However, it probably makes that task a bit easier by reducing the data structure's dependency on pointers. It would now be practical to dump an event list to disk by "chunks" instead of individual events.
-
Magnus Hagander authored
-
Magnus Hagander authored
end-user documentation that lives in the actual documentation.
-
Magnus Hagander authored
to the old set of SSL patches. Hasn't been updated since, and we keep the TODOs in the "real" TODO list, really...
-
Magnus Hagander authored
of copy/paste:d emails. Much of the contents had already been migrated into the main documentation, some was out of date and some just plain wrong. Keep the "protocol-flowchart" which can still be useful.
-
- 23 Oct, 2008 7 commits
-
-
Magnus Hagander authored
-
Tom Lane authored
in their targetlists had better reset ps_TupFromTlist during ReScan calls. There's no need to back-patch here since nodeAgg and nodeGroup didn't even pretend to support SRFs in prior releases.
-
Tom Lane authored
used long ago, but in the current code the ecxt_outertuple field of ExprContext is doing all the work. Spotted by Ran Tang.
-
Magnus Hagander authored
* make LDAP use this instead of the hacky previous method to specify the DN to bind as * make all auth options behave the same when they are not compiled into the server * rename "ident maps" to "user name maps", and support them for all auth methods that provide an external username This makes a backwards incompatible change in the format of pg_hba.conf for the ident, PAM and LDAP authentication methods.
-
Peter Eisentraut authored
(INCLUDING/EXCLUDING DEFAULTS)
-
Peter Eisentraut authored
-
Tom Lane authored
inputs is unique or nearly so), make eqjoinsel() clamp the ndistinct estimates to be not more than the estimated number of rows coming from the input relations. This allows the estimate to change in response to the selectivity of restriction conditions on the inputs. This is a pretty narrow patch and maybe we should be more aggressive about similarly clamping ndistinct in other cases; but I'm worried about double-counting the effects of the restriction conditions. However, it seems to help for the case exhibited by Grzegorz Jaskiewicz (antijoin against a small subset of a relation), so let's try this for awhile.
-