hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-04-13 23:56:56 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • de1172fa06 Default to thread safety on, and support more CPU options. Also make sure that a CPU option is actually chosen. Magnus Hagander 2007-10-02 19:01:45 +00:00
  • 5a0d31d3dc Made new test also work without threading enabled. Michael Meskes 2007-10-02 14:01:57 +00:00
  • b5efdbac5c No idea where this file came from. Michael Meskes 2007-10-02 09:51:41 +00:00
  • 0c2eb200d6 ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> added thread-safe descriptor handling Michael Meskes 2007-10-02 09:50:00 +00:00
  • f1d37a9997 Cope with ERR_set_mark() and ERR_pop_to_mark() not existing in older OpenSSL libraries --- just don't call them if they're not there. This might possibly lead to misleading error messages, but we'll just have to live with that. Tom Lane 2007-10-02 00:25:20 +00:00
  • eb9f280ca7 Add catalogs.sgml documentation for text search catalogs. Tom Lane 2007-10-01 21:10:40 +00:00
  • ec4b6a81f6 Use BIO functions to avoid passing FILE * pointers to OpenSSL functions. This fixes potential crashes on old versions of OpenSSL and the requirement on "Applink" in new versions when building with MSVC and using different runtimes. Magnus Hagander 2007-10-01 20:30:06 +00:00
  • c2862e3cad Add some examples. D'Arcy J.M. Cain 2007-10-01 19:06:48 +00:00
  • 5a95c560f0 Add note warning against use of pre-8.4 multithreaded Tcl. Tom Lane 2007-10-01 16:43:28 +00:00
  • b526462f9e Avoid assuming that struct varattrib_pointer doesn't get padded by the compiler --- at least on ARM, it does. I suspect that the varvarlena patch has been creating larger-than-intended toast pointers all along on ARM, but it wasn't exposed until the latest tweak added some Asserts that calculated the expected size in a different way. We could probably have fixed this by adding __attribute__((packed)) as is done for ItemPointerData, but struct varattrib_pointer isn't really all that useful anyway, so it seems cleanest to just get rid of it and have only struct varattrib_1b_e. Per results from buildfarm member quagga. Tom Lane 2007-10-01 16:25:56 +00:00
  • b8ce3d3494 Build with /GS on 64-bit to work with modern Platform SDK. Magnus Hagander 2007-10-01 14:32:02 +00:00
  • 8ddeb48cd5 Update pgcvslog text to simply "<branch>" Bruce Momjian 2007-10-01 13:04:55 +00:00
  • 4164e6636e Enable __FUNCTION__ on MSVC builds. Magnus Hagander 2007-10-01 10:54:29 +00:00
  • ca87db23ea Fix a minor typo. D'Arcy J.M. Cain 2007-10-01 06:52:42 +00:00
  • 2d5dfd9516 Fixup for new pgcvslog feature. Bruce Momjian 2007-10-01 03:01:38 +00:00
  • 7d4dd3ab41 Have pgcvslog mark back-branch commits with "<back-patch>". Bruce Momjian 2007-10-01 02:59:03 +00:00
  • 27b8922221 Add an extra header byte to TOAST-pointer datums to represent their size explicitly. This means a TOAST pointer takes 18 bytes instead of 17 --- still smaller than in 8.2 --- which seems a good tradeoff to ensure we won't have painted ourselves into a corner if we want to support multiple types of TOAST pointer later on. Per discussion with Greg Stark. Tom Lane 2007-09-30 19:54:58 +00:00
  • 3ff0018c2e In hopes of un-breaking the buildfarm, add missing file from ITAGAKI Takahiro's patch. Tom Lane 2007-09-30 17:50:56 +00:00
  • ab051bd293 Adjust recovery PS display as agreed with Simon: 'waiting for XXX' while the restore_command does its thing, then 'recovering XXX' while processing the segment file. These operations are heavyweight enough that an extra PS display set shouldn't bother anyone. Tom Lane 2007-09-30 17:28:56 +00:00
  • 47d2347167 Properly mark mergeable/hashable equality operators (found by opr_sanity testing). Combine the formerly independent opclasses for the various ISN types into opfamilies. The latter causes some extra bleating from opr_sanity, since the module doesn't provide complete sets of cross-type operators, but it's still a good idea because it will give the planner more information to work with. The missing cross-type operators no longer pose a risk of unexpected planner errors in 8.3, so there's no need to insist on filling them in (and I gather it wouldn't be very sound semantically to add them all). Tom Lane 2007-09-30 17:13:19 +00:00
  • f8203f908e Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-30 15:52:06 +00:00
  • 60e83cec57 Applied another patch by ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> to get memory allocation thread-safe. He also did some cleaning up. Michael Meskes 2007-09-30 11:38:48 +00:00
  • ae57efed4a Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-30 00:03:47 +00:00
  • 2e0c47e5bf Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-29 23:48:22 +00:00
  • d80d8acbce Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-29 23:43:18 +00:00
  • 92266303e8 Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-29 23:38:17 +00:00
  • 591abe1b72 Remove bogus commutator marking --- the module doesn't actually supply any commutator operator for =(chkpass,text), so this was creating a shell operator that would fail on use. Found by opr_sanity testing. Tom Lane 2007-09-29 23:32:42 +00:00
  • 24ad7d4628 Support functions for index opclasses should be immutable. Found by running opr_sanity on contrib modules. Tom Lane 2007-09-29 23:24:39 +00:00
  • 77ccbe64dd Make recovery show the current input WAL segment name in the startup process' PS display. After a suggestion by Simon (not exactly his patch though). Tom Lane 2007-09-29 18:32:56 +00:00
  • c008a275c2 Disallow CLUSTER using an invalid index (that is, one left over from a failed CREATE INDEX CONCURRENTLY). Such an index might not have entries for every heap row and thus clustering with it would result in silent data loss. The scenario requires a pretty foolish DBA, but still ... Tom Lane 2007-09-29 18:05:28 +00:00
  • f6a54b8c42 Disallow CLUSTER using an invalid index (that is, one left over from a failed CREATE INDEX CONCURRENTLY). Such an index might not have entries for every heap row and thus clustering with it would result in silent data loss. The scenario requires a pretty foolish DBA, but still ... Tom Lane 2007-09-29 18:05:20 +00:00
  • 34b44c3ba2 Improve consistency of the error messages generated when you try to use ALTER TABLE on a composite type or ALTER TYPE on a table's rowtype. We already rejected these cases, but the error messages were a bit random and didn't always provide a HINT to use the other command type. Tom Lane 2007-09-29 17:18:58 +00:00
  • d218e2332b Defend against openssl libraries that fail on keys longer than 128 bits; which is the case at least on some Solaris versions. Marko Kreen Tom Lane 2007-09-29 15:50:07 +00:00
  • e6022e7470 In the release checklist, mention packagers will see the minor upgrade numbering for additional functions. Bruce Momjian 2007-09-29 12:19:16 +00:00
  • bdee83e7e4 Add chklocale.c to pgport files for msvc builds, per buildfarm failures. Magnus Hagander 2007-09-29 07:15:33 +00:00
  • edc4d5edbe Defend against openssl libraries that fail on keys longer than 128 bits; which is the case at least on some Solaris versions. Marko Kreen Tom Lane 2007-09-29 02:18:21 +00:00
  • 6e7e0b5350 Defend against openssl libraries that fail on keys longer than 128 bits; which is the case at least on some Solaris versions. Marko Kreen Tom Lane 2007-09-29 02:18:15 +00:00
  • ef00409020 Make archive recovery always start a new timeline, rather than only when a recovery stop time was used. This avoids a corner-case risk of trying to overwrite an existing archived copy of the last WAL segment, and seems simpler and cleaner all around than the original definition. Per example from Jon Colverson and subsequent analysis by Simon. Tom Lane 2007-09-29 01:36:39 +00:00
  • 9618af7b27 Make archive recovery always start a new timeline, rather than only when a recovery stop time was used. This avoids a corner-case risk of trying to overwrite an existing archived copy of the last WAL segment, and seems simpler and cleaner all around than the original definition. Per example from Jon Colverson and subsequent analysis by Simon. Tom Lane 2007-09-29 01:36:29 +00:00
  • 4ef631fe2c Make archive recovery always start a new timeline, rather than only when a recovery stop time was used. This avoids a corner-case risk of trying to overwrite an existing archived copy of the last WAL segment, and seems simpler and cleaner all around than the original definition. Per example from Jon Colverson and subsequent analysis by Simon. Tom Lane 2007-09-29 01:36:19 +00:00
  • b46bd55a6c Make archive recovery always start a new timeline, rather than only when a recovery stop time was used. This avoids a corner-case risk of trying to overwrite an existing archived copy of the last WAL segment, and seems simpler and cleaner all around than the original definition. Per example from Jon Colverson and subsequent analysis by Simon. Tom Lane 2007-09-29 01:36:10 +00:00
  • b37e1770c5 Make use of additional chklocale.c entries to reject locales that we cannot support. Tom Lane 2007-09-29 00:14:40 +00:00
  • d5459671a3 Teach chklocale.c about a few names for frontend-only encodings, since this will allow initdb to reject attempts to initdb in a locale that uses such an encoding. We'll probably find out more such names during beta ... Tom Lane 2007-09-29 00:01:43 +00:00
  • 1f32999039 On OS X, assume that an empty-string result for nl_langinfo(CODESET) means UTF-8. Per examination of /usr/share/locale in 10.4.10. Tom Lane 2007-09-28 23:36:06 +00:00
  • 304750f8d0 Update TCL comment: Bruce Momjian 2007-09-28 22:33:20 +00:00
  • 70b9b9b788 Change initdb and CREATE DATABASE to actively reject attempts to create databases with encodings that are incompatible with the server's LC_CTYPE locale, when we can determine that (which we can on most modern platforms, I believe). C/POSIX locale is compatible with all encodings, of course, so there is still some usefulness to CREATE DATABASE's ENCODING option, but this will insulate us against all sorts of recurring complaints caused by mismatched settings. Tom Lane 2007-09-28 22:25:49 +00:00
  • ae0b90f223 Remove: Bruce Momjian 2007-09-28 21:32:29 +00:00
  • 834f45014b Tweak initdb's text search configuration selection code so it can cope with LANG settings like 'es_ES@euro'. Tom Lane 2007-09-28 15:25:44 +00:00
  • c0a8276061 exclude contrib/tsearch2 from regression tests. Andrew Dunstan 2007-09-28 00:14:58 +00:00
  • 3396d1c695 Turn build and vcregress .bat files into pure one line wrappers for the perl scripts. Remove the now superfluous getregress.pl. Andrew Dunstan 2007-09-27 21:13:11 +00:00
  • aedc5ed571 Fix typos in two comments. Spotted by Brendan Jurd Tom Lane 2007-09-27 21:01:59 +00:00
  • ffda674769 Tweak pgbench.c to remove the hidden assumption that a WIN32 machine couldn't possibly HAVE_GETOPT. I believe this is the most appropriate form of the patch submitted 2007-08-07 by Hiroshi Saito, though not having a Windows build environment I won't know for sure till I see the buildfarm results. Tom Lane 2007-09-27 20:39:43 +00:00
  • 314ed5de6d Define the FRONTEND symbol in postgres_fe.h, which allows us to eliminate duplicative -DFRONTEND flags from many Makefiles. We still need Makefile control of the symbol in a few places that compile frontend-or-backend src/port/ files, but it's a lot cleaner than before. Tom Lane 2007-09-27 19:53:44 +00:00
  • 77c166ba6c Add virtual transaction IDs to CSVLOG output, so that messages coming from the same transaction can be identified even when no regular XID was assigned. This seems essential after addition of the lazy-XID patch. Also some minor code cleanup in write_csvlog(). Tom Lane 2007-09-27 18:15:36 +00:00
  • 3f850ee9aa Fix Assert failure in ExpandColumnRefStar --- what I thought was a can't happen condition can happen given incorrect input. The real problem is that gram.y should try harder to distinguish * from "*" --- the latter is a legal column name per spec, and someday we ought to treat it that way. However fixing that is too invasive for a back-patch, and it's too late for the 8.3 cycle too. So just reduce the Assert to a plain elog for now. Per report from NikhilS. Tom Lane 2007-09-27 17:42:09 +00:00
  • a62a359ba2 Fix Assert failure in ExpandColumnRefStar --- what I thought was a can't happen condition can happen given incorrect input. The real problem is that gram.y should try harder to distinguish * from "*" --- the latter is a legal column name per spec, and someday we ought to treat it that way. However fixing that is too invasive for a back-patch, and it's too late for the 8.3 cycle too. So just reduce the Assert to a plain elog for now. Per report from NikhilS. Tom Lane 2007-09-27 17:42:03 +00:00
  • 03a91e0d10 Lowercase all mentions of "PostgreSQL" in URLs, per Magnus. Bruce Momjian 2007-09-27 06:14:47 +00:00
  • 84fe8990ae Some small tuptoaster improvements from Greg Stark. Avoid unnecessary decompression of an already-compressed external value when we have to copy it; save a few cycles when a value is too short for compression; and annotate various lines that are currently unreachable. Tom Lane 2007-09-26 23:29:10 +00:00
  • f18dfc4835 Minor improvements in backup and recovery: Tom Lane 2007-09-26 22:36:30 +00:00
  • 80963144ad Rename "PostgreSQL" to "Postgres" in 3 places. Bruce Momjian 2007-09-26 20:38:28 +00:00
  • 9692324734 Rename "PostgreSQL" to "Postgres" in 7 places in the FAQ. Bruce Momjian 2007-09-26 20:36:50 +00:00
  • b83e11639b Adjust the new memory limit in the lazy vacuum code to use MaxHeapTuplesPerPage tuples per page instead of fixed 200, to better cope with systems that use a different block size. Alvaro Herrera 2007-09-26 20:16:28 +00:00
  • cdf0231c88 Create a function variable "join_search_hook" to let plugins override the join search order portion of the planner; this is specifically intended to simplify developing a replacement for GEQO planning. Patch by Julius Stroffek, editorialized on by me. I renamed make_one_rel_by_joins to standard_join_search and make_rels_by_joins to join_search_one_level to better reflect their place within this scheme. Tom Lane 2007-09-26 18:51:51 +00:00
  • 149af068ff Properly pass -c parameter to ecpg when building regression tests. Per Michael. Magnus Hagander 2007-09-26 11:19:09 +00:00
  • d49b20fbe6 Applied patch by ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> to get prepare thread-safe. Michael Meskes 2007-09-26 10:57:01 +00:00
  • 45cd13c8ab Fix crash of to_tsvector() function on huge input: compareWORD() function didn't return correct result for word position greate than limit. Teodor Sigaev 2007-09-26 10:44:54 +00:00
  • 76e114a458 Fix crash of to_tsvector() function on huge input: compareWORD() function didn't return correct result for word position greate than limit. Teodor Sigaev 2007-09-26 10:39:15 +00:00
  • bc16ca2746 Fix crash of to_tsvector() function on huge input: compareWORD() function didn't return correct result for word position greate than limit. Teodor Sigaev 2007-09-26 10:30:53 +00:00
  • d77a9018fa Fix crash of to_tsvector() function on huge input: compareWORD() function didn't return correct result for word position greate than limit. Teodor Sigaev 2007-09-26 10:17:34 +00:00
  • 689df1bc77 Fix crash of to_tsvector() function on huge input: compareWORD() function didn't return correct result for word position greate than limit. Teodor Sigaev 2007-09-26 10:09:57 +00:00
  • 10e1b9df5c Add: Bruce Momjian 2007-09-26 08:47:43 +00:00
  • 1b57b8bfdc Document that libpq's PQntuples() might overflow. Bruce Momjian 2007-09-26 08:45:50 +00:00
  • 6f21c57a97 In the integer-datetimes case, date2timestamp and date2timestamptz need to check for overflow because the legal range of type date is actually wider than timestamp's. Problem found by Neil Conway. Tom Lane 2007-09-26 01:10:42 +00:00
  • 93407d3998 Use SYSV semaphores rather than POSIX on Darwin >= 6.0 (i.e., OS X 10.2 and up), per Chris Marcellino. This avoids consuming O(N^2) file descriptors to support N backends. Tests suggest it's about a wash for small installations, but large ones would have a problem. Tom Lane 2007-09-26 00:32:46 +00:00
  • f828f878e9 Change on-disk representation of NUMERIC datatype so that the sign_dscale word comes before the weight instead of after. This will allow future binary-compatible extension of the representation to support compact formats, as discussed on pgsql-hackers around 2007/06/18. The reason to do it now is that we've already pretty well broken any chance of simple in-place upgrade from 8.2 to 8.3, but it's possible that 8.3 to 8.4 (or whenever we get around to squeezing NUMERIC) could otherwise be data-compatible. Tom Lane 2007-09-25 22:21:55 +00:00
  • 7a315a09dc Dept. of second thoughts: fix loop in BgBufferSync so that the exit when bgwriter_lru_maxpages is exceeded leaves the loop variables in the expected state. In the original coding, we'd fail to advance next_to_clean, causing that buffer to be probably-uselessly rechecked next time, and also have an off-by-one idea of the number of buffers scanned. Tom Lane 2007-09-25 22:11:48 +00:00
  • 6f5c38dcd0 Just-in-time background writing strategy. This code avoids re-scanning buffers that cannot possibly need to be cleaned, and estimates how many buffers it should try to clean based on moving averages of recent allocation requests and density of reusable buffers. The patch also adds a couple more columns to pg_stat_bgwriter to help measure the effectiveness of the bgwriter. Tom Lane 2007-09-25 20:03:38 +00:00
  • 588901df84 Small string tweaks Peter Eisentraut 2007-09-25 16:29:34 +00:00
  • e5b5739a2d Use proper search for contrib makefiles in vcregress.pl Andrew Dunstan 2007-09-24 21:42:34 +00:00
  • 3f2a191b44 fix typo in vcregress.pl Andrew Dunstan 2007-09-24 21:14:54 +00:00
  • a1b14ae1dd Add comments re text <-> bytea internal equivalence in convert routines. Andrew Dunstan 2007-09-24 16:38:24 +00:00
  • 82467e4e70 Use correct PG_GETARG macro in pg_convert Andrew Dunstan 2007-09-24 14:59:37 +00:00
  • 45cbdaa038 Avoid having autovacuum read pgstats data too many times in quick succession. This is problematic for the autovac launcher when there are many databases, so we keep data for a full second before reading it again. Alvaro Herrera 2007-09-24 04:12:01 +00:00
  • 46dcd202ef Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Alvaro Herrera 2007-09-24 03:53:12 +00:00
  • 9e439d9f66 Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Alvaro Herrera 2007-09-24 03:53:06 +00:00
  • 189f9a5bb2 Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Alvaro Herrera 2007-09-24 03:53:02 +00:00
  • 5853662630 Reduce the size of memory allocations by lazy vacuum when processing a small table, by allocating just enough for a hardcoded number of dead tuples per page. The current estimate is 200 dead tuples per page. Alvaro Herrera 2007-09-24 03:52:55 +00:00
  • 48f7e64395 Simplify and rename some GUC variables, per various recent discussions: Tom Lane 2007-09-24 03:12:23 +00:00
  • 02138357ff Remove "convert 'blah' using conversion_name" facility, because if it produces text it is an encoding hole and if not it's incompatible with the spec, whatever the spec means (which we're not sure about anyway). Andrew Dunstan 2007-09-24 01:29:30 +00:00
  • c3b193a5c3 Replace linear searches with binary searches in pg_dump's code to lookup objects by OID. Per gripe from nikitathespider. Tom Lane 2007-09-23 23:39:36 +00:00
  • aabb7000dc Add perl replacements for build.bat and vcregress.bat. In due course the .bat files will be altered to become tiny wrappers for these scripts, and one or two other .bat files will disappear. Andrew Dunstan 2007-09-23 21:52:56 +00:00
  • f71c7b9dfd Fix bugs in XML binary I/O functions. Heikki and Tom Tom Lane 2007-09-23 21:36:42 +00:00
  • a8da5761a3 Restrict overly broad searches, and fix typo, in recent fix. Per Hannes Eder. Andrew Dunstan 2007-09-23 20:32:40 +00:00
  • ea72d37ff7 Make autovacuum report the start time of its current activity in pg_stat_activity. Per gripe from Jim Nasby. Tom Lane 2007-09-23 20:07:33 +00:00
  • 1b3d400cac TransactionIdIsInProgress can skip scanning the ProcArray if the target XID is later than latestCompletedXid, per Florian Pflug. Also some minor improvements in the XIDCACHE_DEBUG code --- make sure each call of TransactionIdIsInProgress is counted one way or another. Tom Lane 2007-09-23 18:50:38 +00:00
  • d16f270e59 Typo fix from Brendan Jurd. Bruce Momjian 2007-09-23 18:06:47 +00:00
  • 33b9c8bd68 Temporarily modify tsearch regression tests to suppress notice that comes out at erratic times, because it is creating a totally unacceptable level of noise in our buildfarm results. This patch can be reverted when and if the code is fixed to not issue notices during cache reload events. Tom Lane 2007-09-23 15:58:58 +00:00
  • 7125687511 Fix cost estimates for EXISTS subqueries that are evaluated as initPlans (because they are uncorrelated with the immediate parent query). We were charging the full run cost to the parent node, disregarding the fact that only one row need be fetched for EXISTS. While this would only be a cosmetic issue in most cases, it might possibly affect planning outcomes if the parent query were itself a subquery to some upper query. Per recent discussion with Steve Crawford. Tom Lane 2007-09-22 21:36:40 +00:00
  • 576b8903f7 Replace calls to external dir program with perlish globs and File::Find calls. Fixes complaint fron Hannes Eder, whose environment found a different dir program. Andrew Dunstan 2007-09-22 20:38:10 +00:00
  • 90c156f0d1 Document the translations from Postgres message severity levels to syslog and eventlog severity levels, per suggestion from Josh Drake. Also, some wordsmithing for the csvlog documentation. Tom Lane 2007-09-22 19:10:44 +00:00