hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-07 12:47:00 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 2e964aee75 Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't change content (at least not supposed to). Bruce Momjian 2005-03-11 21:47:44 +00:00
  • b9de4a26cf Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't change content (at least not supposed to). Bruce Momjian 2005-03-11 21:46:54 +00:00
  • caad817d1c Add fprintf() custom version to libpgport. Bruce Momjian 2005-03-11 19:13:43 +00:00
  • 3bc6bdf322 Define snprintf() to call pg_snprintf() so our own snprintf-like implementation doesn't export out via libpq and get used by a user application. Bruce Momjian 2005-03-11 17:20:35 +00:00
  • 6521cd9ae1 Add 'static' to initdb.c file-global variables. Bruce Momjian 2005-03-11 15:36:27 +00:00
  • c5159bc0c0 Mark file-global function and variables as static. Bruce Momjian 2005-03-11 15:25:31 +00:00
  • db48396a8a Fix typos. Bruce Momjian 2005-03-11 13:09:39 +00:00
  • 85ecedf1d8 Fix typos. Bruce Momjian 2005-03-11 11:59:16 +00:00
  • e185618f5d Fix typos. Bruce Momjian 2005-03-11 11:43:45 +00:00
  • 7e3a8d9a83 Fix typo. Bruce Momjian 2005-03-11 11:42:03 +00:00
  • c129c16492 Slight refactoring and optimization of some code in WaitOnLock(). Neil Conway 2005-03-11 03:52:06 +00:00
  • a258a1bba8 Add: Bruce Momjian 2005-03-11 03:45:25 +00:00
  • 595ed2a855 Make the behavior of HAVING without GROUP BY conform to the SQL spec. Formerly, if such a clause contained no aggregate functions we mistakenly treated it as equivalent to WHERE. Per spec it must cause the query to be treated as a grouped query of a single group, the same as appearance of aggregate functions would do. Also, the HAVING filter must execute after aggregate function computation even if it itself contains no aggregate functions. Tom Lane 2005-03-10 23:21:26 +00:00
  • 609e32b929 Add spinlock support for Itanium processor with Intel compiler. Bruce Momjian 2005-03-10 21:41:01 +00:00
  • 164adc4d39 Refactor fork()-related code. We need to do various housekeeping tasks before we can invoke fork() -- flush stdio buffers, save and restore the profiling timer on Linux with LINUX_PROFILE, and handle BeOS stuff. This patch moves that code into a single function, fork_process(), instead of duplicating it at the various callsites of fork(). Neil Conway 2005-03-10 07:14:03 +00:00
  • e829f82223 Add comma. Bruce Momjian 2005-03-08 13:27:31 +00:00
  • 3716e12808 Fix markup of URL. Bruce Momjian 2005-03-08 03:52:57 +00:00
  • 2b26458a91 Add URL for patches queues. Bruce Momjian 2005-03-08 01:15:33 +00:00
  • 4cd2fd66f8 Unbreak out-of-tree builds, by fixing a typo. Neil Conway 2005-03-07 23:18:06 +00:00
  • 30c1aa06bc Replace an instance of $Id$ and an instance of $Header$ with $PostgreSQL$ Neil Conway 2005-03-07 22:59:43 +00:00
  • 30854a53fe Properly implement "Response files" for bcc. Add URL's to describe the feature for Win32 and bcc. Bruce Momjian 2005-03-07 21:11:07 +00:00
  • 61b640e35c Properly implement "Response files" for bcc. Add URL's to describe the feature for Win32 and bcc. Bruce Momjian 2005-03-07 21:10:58 +00:00
  • a52b4fb131 Adjust creation/destruction of TupleDesc data structure to reduce the number of palloc calls. This has a salutory impact on plpgsql operations with record variables (which create and destroy tupdescs constantly) and probably helps a bit in some other cases too. Tom Lane 2005-03-07 04:42:17 +00:00
  • e3d7de6b99 Rename canonical encodings, per Peter: Bruce Momjian 2005-03-07 04:30:55 +00:00
  • c6ad5c2eb4 Here's a tiny fix for a harmless typo in catalog.c: Neil Conway 2005-03-07 04:15:34 +00:00
  • 1fcfa038ce Add a note that regression test row ordering differences can be caused by non-default planner parameter settings. Tom Lane 2005-03-07 02:00:28 +00:00
  • 849074f9ae Revise hash join code so that we can increase the number of batches on-the-fly, and thereby avoid blowing out memory when the planner has underestimated the hash table size. Hash join will now obey the work_mem limit with some faithfulness. Per my recent proposal (hash aggregate part isn't done yet though). Tom Lane 2005-03-06 22:15:05 +00:00
  • 989a17a68c Prevent rank change in case of duplicate search terms Teodor Sigaev 2005-03-05 16:19:33 +00:00
  • 10d3c07875 Prevent rank change in case of duplicate search terms Teodor Sigaev 2005-03-05 16:17:47 +00:00
  • 31b6d840f6 Prevent rank change in case of duplicate search terms Teodor Sigaev 2005-03-05 15:48:32 +00:00
  • 5d5087363d Replace the BufMgrLock with separate locks on the lookup hashtable and the freelist, plus per-buffer spinlocks that protect access to individual shared buffer headers. This requires abandoning a global freelist (since the freelist is a global contention point), which shoots down ARC and 2Q as well as plain LRU management. Adopt a clock sweep algorithm instead. Preliminary results show substantial improvement in multi-backend situations. Tom Lane 2005-03-04 20:21:07 +00:00
  • 4e8af8d273 Replace ARC cache management algorithm with the similar but slightly simpler 2Q algorithm, to avoid possible problems with the pending patent on ARC. Testing so far suggests that there is little if any performance loss from doing this. Tom Lane 2005-03-03 16:47:43 +00:00
  • 5592a6cf46 Move snprintf int64 compatibility letters into a NOT_USED block. Bruce Momjian 2005-03-02 23:56:53 +00:00
  • 5c2e68ba6b Fix misspelling of sysctl, per Stefan Hans. Tom Lane 2005-03-02 19:58:54 +00:00
  • 8ba5169abd Use test && test rather than test -a, per Peter. Bruce Momjian 2005-03-02 15:42:35 +00:00
  • f8aca046bb Fix for %I64d snprintf. Bruce Momjian 2005-03-02 15:32:39 +00:00
  • 022ece2cf1 snprintf() %I64d code fix. Bruce Momjian 2005-03-02 15:07:09 +00:00
  • bb7a3a740c Use our own snprintf() only if NLS is enabled, and support %qd and %I64d. Bruce Momjian 2005-03-02 14:48:22 +00:00
  • 70d4a9343f Prevent large allocation in snprintf to hold positional parameters. Allocated size based on format string. Bruce Momjian 2005-03-02 05:22:22 +00:00
  • 3104a92866 Another go at making pred_test() handle all reasonable combinations of AND and OR clauses. The key point here is that an OR on the predicate side has to be treated gingerly: we may be able to prove that the OR is implied even when no one of its components is implied. For example (x OR y) implies (x OR y OR z) even though no one of x, y, or z can be individually proven. This code handles both the example shown recently by Sergey Koshcheyev and the one shown last October by Dawid Kuroczko. Tom Lane 2005-03-02 04:10:53 +00:00
  • 47ea7148e3 Fix snprintf on Win32: Bruce Momjian 2005-03-02 03:21:52 +00:00
  • 9989e90490 Make port snprintf.c finally thread-safe. Bruce Momjian 2005-03-02 00:02:13 +00:00
  • 87aafa1600 SGML improvements to the DML chapter. Neil Conway 2005-03-01 23:45:00 +00:00
  • 89dcff555f Release proclock immediately in RemoveFromWaitQueue() if it represents no held locks. This maintains the invariant that proclocks are present only for procs that are holding or awaiting a lock; when this is not true, LockRelease will fail. Per report from Stephen Clouse. Tom Lane 2005-03-01 21:15:26 +00:00
  • 3f16b38a23 Release proclock immediately in RemoveFromWaitQueue() if it represents no held locks. This maintains the invariant that proclocks are present only for procs that are holding or awaiting a lock; when this is not true, LockRelease will fail. Per report from Stephen Clouse. Tom Lane 2005-03-01 21:15:10 +00:00
  • a2ad04f4b0 Release proclock immediately in RemoveFromWaitQueue() if it represents no held locks. This maintains the invariant that proclocks are present only for procs that are holding or awaiting a lock; when this is not true, LockRelease will fail. Per report from Stephen Clouse. Tom Lane 2005-03-01 21:14:59 +00:00
  • ccba1d0c9c Allow Trace_lock_oidmin to be set to zero; this is a reasonable representation of not wanting tracing to be limited by object OID. Tom Lane 2005-03-01 20:23:34 +00:00
  • e1662cb6b8 Simplify/clean up code for varlena types Teodor Sigaev 2005-03-01 15:40:04 +00:00
  • 03b8efa540 Make snprintf() use already-defined int64/uint64 typedefs rather than defining its own. Bruce Momjian 2005-03-01 05:47:28 +00:00
  • 5edb76d4fc Done: Bruce Momjian 2005-03-01 05:00:20 +00:00
  • bfc2942321 Adjust OR indexscan logic to not generate redundant condition-free OR indexscans involving partial indexes. These would always be dominated by a simple indexscan on such an index, so there's no point in considering them. Fixes overoptimism in a patch I applied last October. Tom Lane 2005-03-01 01:40:39 +00:00
  • 95871703e3 Adjust OR indexscan logic to not generate redundant condition-free OR indexscans involving partial indexes. These would always be dominated by a simple indexscan on such an index, so there's no point in considering them. Fixes overoptimism in a patch I applied last October. Tom Lane 2005-03-01 01:40:05 +00:00
  • 295dd338c3 And while we are on it, I would like to submit minor changes to make snprintf() vsnprintf() and printf() functions in src/port/snprintf.c thread-safe. Bruce Momjian 2005-03-01 00:38:11 +00:00
  • 3da9fd8544 Revert the logic for expanding AND/OR conditions in pred_test() to what it was in 7.4, and add some comments explaining why it has to be this way. I broke it for OR'd index predicates in a fit of code cleanup last summer. Per example from Sergey Koshcheyev. Tom Lane 2005-03-01 00:25:45 +00:00
  • 4e89bae704 Revert the logic for expanding AND/OR conditions in pred_test() to what it was in 7.4, and add some comments explaining why it has to be this way. I broke it for OR'd index predicates in a fit of code cleanup last summer. Per example from Sergey Koshcheyev. Tom Lane 2005-03-01 00:24:52 +00:00
  • 5c4a91c295 Un-break configure snprintf tests (partly my fault, partly Bruce's). Tom Lane 2005-02-28 20:55:18 +00:00
  • f1430ce063 Move PGAC_FUNC_PRINTF_ARG_CONTROL to just above snprintf 64-bit tests so its output can be used to select the proper printf outputs. Bruce Momjian 2005-02-28 20:36:05 +00:00
  • 949ab3c9b3 snprintf.c has no sys/ioctl.h. Trivial patch below: Bruce Momjian 2005-02-28 14:16:16 +00:00
  • 484f0464ff Implement max() and min() aggregates for array types. Patch from Koju Iijima, reviewed by Neil Conway. Catalog version number bumped, regression tests updated. Neil Conway 2005-02-28 03:45:24 +00:00
  • 517872c566 Because the change to gettext. Needs a bunch of new includes. Patch follows: Bruce Momjian 2005-02-27 22:57:17 +00:00
  • c5a7a6a3dc Tab indent all actions in bcc32.mak, and do it on win32.mak too for consistency. Backpatch only bcc32.mak to 8.0.X. Bruce Momjian 2005-02-27 22:39:52 +00:00
  • ba6b067ce8 Tab indent all actions in bcc32.mak, and do it on win32.mak too for consistency. Backpatch only bcc32.mak to 8.0.X. Bruce Momjian 2005-02-27 22:38:29 +00:00
  • 2573029e52 Further fix int64/float8 time/timetz Teodor Sigaev 2005-02-27 09:28:07 +00:00
  • 5285b35763 Add explicit casts between int4 and boolean. Patch from Sean Chittenden, editorializing by Neil Conway. Catalog version bumped. Neil Conway 2005-02-27 08:31:30 +00:00
  • 2d22f16132 Rename planner stats detail to avoid label confict. Bruce Momjian 2005-02-27 01:17:34 +00:00
  • 76fa5e6e18 Cause Win32 to output to the event log rather than stderr by default. Bruce Momjian 2005-02-27 01:02:57 +00:00
  • afbc30e5d4 Allow Win32 to support the O_SYNC open flag as an wal_sync_method method. Bruce Momjian 2005-02-27 00:53:29 +00:00
  • 234d50812c Add documentation on how statistics are used by the planner. Bruce Momjian 2005-02-27 00:49:28 +00:00
  • 1d5b814be9 Further fix time/timetz... Teodor Sigaev 2005-02-27 00:11:35 +00:00
  • 4f51368bad Add routines to dbsize to return the index size and total relation size. Improve documentation. Bruce Momjian 2005-02-26 23:31:15 +00:00
  • f55339577b Adjust OS-specific kernel settings to mention old and new BSD methods of adjusting values: Bruce Momjian 2005-02-26 23:19:05 +00:00
  • 9f312cde26 Backpatch clarification of PGPASSWORD to 8.0.X. Bruce Momjian 2005-02-26 18:50:44 +00:00
  • 0fc4ecf935 Finish up the flat-files project: get rid of GetRawDatabaseInfo() hack in favor of looking at the flat file copy of pg_database during backend startup. This should finally eliminate the various corner cases in which backend startup fails unexpectedly because it isn't able to distinguish live and dead tuples in pg_database. Simplify locking on pg_database to be similar to the rules used with pg_shadow and pg_group, and eliminate FlushRelationBuffers operations that were used only to reduce the odds of failure of GetRawDatabaseInfo. initdb forced due to addition of a trigger to pg_database. Tom Lane 2005-02-26 18:43:34 +00:00
  • ffef9a9de4 Clarify PGPASSWORD usage: Bruce Momjian 2005-02-26 18:39:04 +00:00
  • 891497d3a9 Correct overstatement in locking docs: we said ExclusiveLock is never taken automatically, but this is only true with respect to user tables. Tom Lane 2005-02-26 18:37:17 +00:00
  • 0060023c3d State PGPASSWORD is "not recommended" rather than "depricated". Bruce Momjian 2005-02-26 14:21:40 +00:00
  • 5553d6572a In accordance to http://www.pgsql.ru/db/mw/msg.html?mid=2045361 Teodor Sigaev 2005-02-25 16:13:29 +00:00
  • a72fd004ba Add linking from /port to bcc makefile. Bruce Momjian 2005-02-25 15:57:41 +00:00
  • 33b92a78da Add linking from /port to bcc makefile. Bruce Momjian 2005-02-25 15:57:33 +00:00
  • 1c8fbd9b25 Fix float8->int64 transformation Teodor Sigaev 2005-02-25 14:04:39 +00:00
  • ea90a93a46 Fix float8->int64 transformation Teodor Sigaev 2005-02-25 14:03:04 +00:00
  • 93aa22fc8e Please find enclosed a patch, per Dennis Bj<C3><B6>rklund, that uses -f for input files rather than <. This makes error messages, &c. more expressive. Bruce Momjian 2005-02-25 04:56:01 +00:00
  • 6b80ca2f06 Fix plpgsql error message for dropped temporary tables. Bruce Momjian 2005-02-25 04:18:27 +00:00
  • e49da4855c Clarify object ownership language to prevent confusion with database ownership. Bruce Momjian 2005-02-25 02:34:56 +00:00
  • 0c6568424a Updatge wording. Bruce Momjian 2005-02-25 00:45:30 +00:00
  • 4a68e59418 Backpatch FAQ to 8.0.X. Bruce Momjian 2005-02-25 00:33:45 +00:00
  • 3debf968ef Fix markup. Bruce Momjian 2005-02-25 00:32:55 +00:00
  • 026a8510a3 Fix HTML markup and add NULL sorting item to existing NULL FAQ item. Bruce Momjian 2005-02-25 00:32:15 +00:00
  • d2557833e9 Add: Bruce Momjian 2005-02-25 00:24:10 +00:00
  • 0b58d30168 Add wording about UTF8: Bruce Momjian 2005-02-24 23:39:29 +00:00
  • 0ae430a207 Done: Bruce Momjian 2005-02-24 14:14:41 +00:00
  • 13227910e4 We aren't supposed to try to run test programs until after we've verified that AC_TRY_RUN works. Tom Lane 2005-02-24 02:12:15 +00:00
  • e71d09a472 Clean up printf arg-control test, per Kurt Roeckx. Tom Lane 2005-02-24 01:34:45 +00:00
  • 41994145d4 My patch this morning was overly hasty; revert code to original state. Tom Lane 2005-02-24 01:11:40 +00:00
  • 406a942820 Minor code cleanup: remove a variable that was assigned to but never subsequently referenced. Neil Conway 2005-02-23 23:27:54 +00:00
  • 3350b3740e This patch optimizes the md5_text() function (which is used to implement the md5() SQL-level function). The old code did the following: Neil Conway 2005-02-23 22:46:17 +00:00
  • b9a87e5219 Un-break plpgsql build by removing unwanted _() usage. This would be a completely inappropriate place to apply localization anyway. Tom Lane 2005-02-23 16:23:07 +00:00
  • e3267b6517 Properly undef _(x) gettext macro. Bruce Momjian 2005-02-23 04:34:21 +00:00
  • 510f058932 Document that only a table's owner may TRUNCATE it. Per Keith Worthington. Tom Lane 2005-02-22 19:06:49 +00:00
  • 777745435c Document that only a table's owner may TRUNCATE it. Per Keith Worthington. Tom Lane 2005-02-22 19:06:35 +00:00