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

Commit Graph

  • f085ee088e Release wording updates for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 13:01:44 +00:00
  • def3f81fa1 Update FAQ to mention most recent release for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 04:16:09 +00:00
  • 6f4baccdb1 Update FAQ to mention most recent release for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 04:04:50 +00:00
  • 447b2b9220 Update FAQ to mention most recent release for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 04:04:41 +00:00
  • d62b0e2c1d Update FAQ to mention most recent release for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 04:04:30 +00:00
  • eaeacaf374 Update FAQ to mention most recent release for releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 04:04:14 +00:00
  • 90e4b46998 Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 03:07:32 +00:00
  • 4938f2d6c0 Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 03:06:50 +00:00
  • 416dcc4927 Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 03:06:46 +00:00
  • f199177461 Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 03:06:37 +00:00
  • af6b2e30a4 Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 03:06:28 +00:00
  • ca3f095b98 Update FAQ for 8.2.4. Bruce Momjian 2007-04-19 03:05:10 +00:00
  • fe48792a11 Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:47:52 +00:00
  • 3116c2f7c3 Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:47:36 +00:00
  • 05465579c3 Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:47:17 +00:00
  • a7ce947b63 Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:47:01 +00:00
  • 9057d27f5d Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:46:46 +00:00
  • 28ecd60233 Release note updates for 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19. Bruce Momjian 2007-04-19 02:46:29 +00:00
  • 2875fe6b7c Translation updates Peter Eisentraut 2007-04-18 21:13:57 +00:00
  • fdfc58e34c Translation updates Peter Eisentraut 2007-04-18 20:57:58 +00:00
  • 0f96720312 Translation updates Peter Eisentraut 2007-04-18 20:45:10 +00:00
  • 05cd021c30 Remove tabs from SGML source files. Bruce Momjian 2007-04-18 20:44:53 +00:00
  • d3753aad55 Translation updates Peter Eisentraut 2007-04-18 20:01:39 +00:00
  • ef23a77441 Enable configurable log of autovacuum actions. Initial patch from Simon Riggs, additional code and docs by me. Per discussion. Alvaro Herrera 2007-04-18 16:44:18 +00:00
  • 432ea3cffd Enable building of 64-bit libpq using visual studio 8 and the win32.mak file. Enable building with kerberos support using the win32.mak file. Magnus Hagander 2007-04-18 13:50:09 +00:00
  • 9e53f83c75 Item not done, per Pavel: Bruce Momjian 2007-04-18 13:31:17 +00:00
  • 62d25256f1 Change default build to release, to be consistent with unix build. Make it possible to set the default from builenv.bat. Magnus Hagander 2007-04-18 10:14:06 +00:00
  • 5574c9f3a5 Silence mingw compiler warning Magnus Hagander 2007-04-18 08:32:40 +00:00
  • 65c531df04 Update docs/error message for CSV quote/escape --- must be ASCII. Backpatch doc change to 8.2.X. Bruce Momjian 2007-04-18 02:29:39 +00:00
  • c228448910 Update docs/error message for CSV quote/escape --- must be ASCII. Backpatch doc change to 8.2.X. Bruce Momjian 2007-04-18 02:28:22 +00:00
  • 4029a5af9b Update error message for COPY with a multi-byte delimiter. Bruce Momjian 2007-04-18 00:38:57 +00:00
  • 4e93443455 Document that the COPY delimiter must be an ASCII byte, rather than a multi-byte value. It can also be a single-byte encoded character if the client and server versions match. Bruce Momjian 2007-04-18 00:18:31 +00:00
  • 739425dbe3 Document that the COPY delimiter must be an ASCII byte, rather than a multi-byte value. It can also be a single-byte encoded character if the client and server versions match. Bruce Momjian 2007-04-18 00:17:56 +00:00
  • f30a72dcdb Update TODO for plpgsql cursors: Bruce Momjian 2007-04-17 23:54:32 +00:00
  • 836feeda9c Fix condition for whether end_heap_rewrite must fsync, per Heikki. Tom Lane 2007-04-17 21:29:31 +00:00
  • 097a200d89 Also done for PL/pgSQL: Bruce Momjian 2007-04-17 21:22:51 +00:00
  • f672b875ae Done: Bruce Momjian 2007-04-17 21:22:13 +00:00
  • e6facb3b95 Add warning about TODO item: Bruce Momjian 2007-04-17 20:50:34 +00:00
  • 4942ee656a Don't assume rd_smgr stays open across all of a rewriteheap operation; doing so can result in crash if an sinval reset occurs meanwhile. I believe this explains intermittent buildfarm failures in cluster test. Tom Lane 2007-04-17 20:49:39 +00:00
  • 6c2c6682f6 Not easy, per Alvaro: Bruce Momjian 2007-04-17 20:47:55 +00:00
  • 400e512a38 Rewrite choose_bitmap_and() to make it more robust in the presence of competing alternatives for indexes to use in a bitmap scan. The former coding took estimated selectivity as an overriding factor, causing it to sometimes choose indexes that were much slower to scan than ones with a slightly worse selectivity. It was also too narrow-minded about which combinations of indexes to consider ANDing. The rewrite makes it pay more attention to index scan cost than selectivity; this seems sane since it's impossible to have very bad selectivity with low cost, whereas the reverse isn't true. Also, we now consider each index alone, as well as adding each index to an AND-group led by each prior index, for a total of about O(N^2) rather than O(N) combinations considered. This makes the results much less dependent on the exact order in which the indexes are considered. It's still a lot cheaper than an O(2^N) exhaustive search. A prefilter step eliminates all but the cheapest of those indexes using the same set of WHERE conditions, to keep the effective value of N down in scenarios where the DBA has created lots of partially-redundant indexes. Tom Lane 2007-04-17 20:03:16 +00:00
  • 2edda80720 Rewrite choose_bitmap_and() to make it more robust in the presence of competing alternatives for indexes to use in a bitmap scan. The former coding took estimated selectivity as an overriding factor, causing it to sometimes choose indexes that were much slower to scan than ones with a slightly worse selectivity. It was also too narrow-minded about which combinations of indexes to consider ANDing. The rewrite makes it pay more attention to index scan cost than selectivity; this seems sane since it's impossible to have very bad selectivity with low cost, whereas the reverse isn't true. Also, we now consider each index alone, as well as adding each index to an AND-group led by each prior index, for a total of about O(N^2) rather than O(N) combinations considered. This makes the results much less dependent on the exact order in which the indexes are considered. It's still a lot cheaper than an O(2^N) exhaustive search. A prefilter step eliminates all but the cheapest of those indexes using the same set of WHERE conditions, to keep the effective value of N down in scenarios where the DBA has created lots of partially-redundant indexes. Tom Lane 2007-04-17 20:03:10 +00:00
  • 2e824a8ea9 Rewrite choose_bitmap_and() to make it more robust in the presence of competing alternatives for indexes to use in a bitmap scan. The former coding took estimated selectivity as an overriding factor, causing it to sometimes choose indexes that were much slower to scan than ones with a slightly worse selectivity. It was also too narrow-minded about which combinations of indexes to consider ANDing. The rewrite makes it pay more attention to index scan cost than selectivity; this seems sane since it's impossible to have very bad selectivity with low cost, whereas the reverse isn't true. Also, we now consider each index alone, as well as adding each index to an AND-group led by each prior index, for a total of about O(N^2) rather than O(N) combinations considered. This makes the results much less dependent on the exact order in which the indexes are considered. It's still a lot cheaper than an O(2^N) exhaustive search. A prefilter step eliminates all but the cheapest of those indexes using the same set of WHERE conditions, to keep the effective value of N down in scenarios where the DBA has created lots of partially-redundant indexes. Tom Lane 2007-04-17 20:03:03 +00:00
  • 2b99411df2 Fix erroneous column counts in some documentation tables. Brian Gough Tom Lane 2007-04-17 17:30:35 +00:00
  • a7664ca3eb And remove 'em again ... Tom Lane 2007-04-17 01:06:28 +00:00
  • 91c62e211b Temporarily re-add derived files, in hopes of straightening out their CVS status. Tom Lane 2007-04-17 01:05:10 +00:00
  • ff663c9606 Don't write timing output in quiet mode. Magnus Hagander 2007-04-16 20:16:11 +00:00
  • e434c9ab3d Don't write timing output in quiet mode. Magnus Hagander 2007-04-16 20:16:02 +00:00
  • 0fd9735296 Don't write timing output in quiet mode. Magnus Hagander 2007-04-16 20:15:53 +00:00
  • a648d71001 Don't write timing output in quiet mode. Magnus Hagander 2007-04-16 20:15:46 +00:00
  • 2ee5d945f9 Don't write timing output in quiet mode. Magnus Hagander 2007-04-16 20:15:38 +00:00
  • 274dfdb513 Tweak clean_encoding_name() API to avoid need to cast away const. Kris Jurka Tom Lane 2007-04-16 18:50:49 +00:00
  • aeb5417633 Fix pg_dump to not crash if -t or a similar switch is used to select a serial sequence for dumping without also selecting its owning table. Make it not try to emit ALTER SEQUENCE OWNED BY in this situation. Per report from Michael Nolan. Tom Lane 2007-04-16 18:42:17 +00:00
  • 6ee2a3be4a Fix pg_dump to not crash if -t or a similar switch is used to select a serial sequence for dumping without also selecting its owning table. Make it not try to emit ALTER SEQUENCE OWNED BY in this situation. Per report from Michael Nolan. Tom Lane 2007-04-16 18:42:10 +00:00
  • de9effb55f Enable IPV6 for all MSVC builds, including the VC6 libpq-only build. Magnus Hagander 2007-04-16 18:39:19 +00:00
  • e2a186b03c Add a multi-worker capability to autovacuum. This allows multiple worker processes to be running simultaneously. Also, now autovacuum processes do not count towards the max_connections limit; they are counted separately from regular processes, and are limited by the new GUC variable autovacuum_max_workers. Alvaro Herrera 2007-04-16 18:30:04 +00:00
  • 42dc4b66e6 Make plancache store cursor options so it can pass them to planner during a replan. I had originally thought this was not necessary, but the new SPI facilities create a path whereby queries planned with non-default options can get into the cache, so it is necessary. Tom Lane 2007-04-16 18:21:07 +00:00
  • f01b196597 Support scrollable cursors (ie, 'direction' clause in FETCH) in plpgsql. Pavel Stehule, reworked a bit by Tom. Tom Lane 2007-04-16 17:21:24 +00:00
  • 66888f7424 Expose more cursor-related functionality in SPI: specifically, allow access to the planner's cursor-related planning options, and provide new FETCH/MOVE routines that allow access to the full power of those commands. Small refactoring of planner(), pg_plan_query(), and pg_plan_queries() APIs to make it convenient to pass the planning options down from SPI. Tom Lane 2007-04-16 01:14:58 +00:00
  • fa92d21a48 Avoid running build_index_pathkeys() in situations where there cannot possibly be any useful pathkeys --- to wit, queries with neither any join clauses nor any ORDER BY request. It's nearly free to check for this case and it saves a useful fraction of the planning time for simple queries. Tom Lane 2007-04-15 20:09:28 +00:00
  • f97d4a267a Add --with-libxslt configure option Andrew Dunstan 2007-04-15 12:48:24 +00:00
  • 6041b92238 Make JOHAB client only encoding per discussions in pgsql-hackers "Server-side support of all encodings" around 2007/3/26. initdb required. Tatsuo Ishii 2007-04-15 10:56:30 +00:00
  • bf47e3e419 Fix description how to create conversion function. Tatsuo Ishii 2007-04-15 10:49:26 +00:00
  • 1656cb76f7 revert change to build xml2 until a better fix is found Andrew Dunstan 2007-04-14 12:57:07 +00:00
  • 1b75d634a6 Update TODO: Bruce Momjian 2007-04-13 23:23:22 +00:00
  • bf3b8d8ad8 Allow \timing in psql to have a better resolution than ~15ms on Windows. Magnus Hagander 2007-04-13 20:40:59 +00:00
  • 5b464e1196 Update Win32 FAQ HTML version to match corrected text version. Bruce Momjian 2007-04-13 20:00:10 +00:00
  • 6506a584cc Enable building contrib/xml2 if configured using --with-libxml. If this breaks things due to missing libxslt, then I'll have to revert it, but let's see if it breaks the buildfarm. Andrew Dunstan 2007-04-13 18:50:01 +00:00
  • 15ebfeec2d Add O_DIRECT support on Windows. Magnus Hagander 2007-04-13 10:30:30 +00:00
  • 85bbf01e08 Minor fixes for the EXPLAIN reference page. Mention the fact that EXPLAIN ANALYZE can sometimes be significantly slower than running the same query normally, and make some minor markup improvements. Neil Conway 2007-04-12 22:39:21 +00:00
  • 6df6d8e361 Fixes for RESET SESSION patch, per Alvaro. Fix a typo in the RESET ref page (sorry, my fault!), and simplify the coding of ResetTempTableNamespace(). Neil Conway 2007-04-12 22:34:45 +00:00
  • c0e42e9325 Done: Bruce Momjian 2007-04-12 19:38:26 +00:00
  • e98de00da3 Rearrange mdsync() looping logic to avoid the problem that a sufficiently fast flow of new fsync requests can prevent mdsync() from ever completing. This was an unforeseen consequence of a patch added in Mar 2006 to prevent the fsync request queue from overflowing. Problem identified by Heikki Linnakangas and independently by ITAGAKI Takahiro; fix based on ideas from Takahiro-san, Heikki, and Tom. Tom Lane 2007-04-12 17:11:07 +00:00
  • 366e9eea24 Rearrange mdsync() looping logic to avoid the problem that a sufficiently fast flow of new fsync requests can prevent mdsync() from ever completing. This was an unforeseen consequence of a patch added in Mar 2006 to prevent the fsync request queue from overflowing. Problem identified by Heikki Linnakangas and independently by ITAGAKI Takahiro; fix based on ideas from Takahiro-san, Heikki, and Tom. Tom Lane 2007-04-12 17:11:00 +00:00
  • 995ba280c1 Rearrange mdsync() looping logic to avoid the problem that a sufficiently fast flow of new fsync requests can prevent mdsync() from ever completing. This was an unforeseen consequence of a patch added in Mar 2006 to prevent the fsync request queue from overflowing. Problem identified by Heikki Linnakangas and independently by ITAGAKI Takahiro; fix based on ideas from Takahiro-san, Heikki, and Tom. Tom Lane 2007-04-12 17:10:55 +00:00
  • 6c6b8f028a Cancel pending fsync requests during WAL replay of DROP DATABASE, per bug report from David Darville. Back-patch as far as 8.1, which may or may not have the problem but it seems a safe change anyway. Tom Lane 2007-04-12 15:04:47 +00:00
  • 707964b6a8 Cancel pending fsync requests during WAL replay of DROP DATABASE, per bug report from David Darville. Back-patch as far as 8.1, which may or may not have the problem but it seems a safe change anyway. Tom Lane 2007-04-12 15:04:41 +00:00
  • ebb6bae539 Cancel pending fsync requests during WAL replay of DROP DATABASE, per bug report from David Darville. Back-patch as far as 8.1, which may or may not have the problem but it seems a safe change anyway. Tom Lane 2007-04-12 15:04:35 +00:00
  • b60ddffa93 Install debugger symbols (in their own directory) Magnus Hagander 2007-04-12 12:46:20 +00:00
  • 4dd3365086 Enable IPV6 when building with MSVC. Magnus Hagander 2007-04-12 07:03:00 +00:00
  • d13e903bea RESET SESSION, plus related new DDL commands. Patch from Marko Kreen, reviewed by Neil Conway. This patch adds the following DDL command variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and DEALLOCATE ALL. RESET SESSION is intended for use by connection pool software and the like, in order to reset a client session to something close to its initial state. Neil Conway 2007-04-12 06:53:49 +00:00
  • e6e47f278d Update text, per Greg Stark: Bruce Momjian 2007-04-11 21:02:31 +00:00
  • 226a100568 Code review for btree page split WAL reduction patch. Make it actually work (original code *always* created a full-page image for the left page, thus leaving the intended savings unrealized), avoid risk of not having enough room on the page during xlog restore, squeeze out another couple bytes in the xlog record, clean up neglected comments. Tom Lane 2007-04-11 20:47:38 +00:00
  • f7424b0d4b Add: Bruce Momjian 2007-04-10 01:33:39 +00:00
  • 170fa82b1a Add: Bruce Momjian 2007-04-10 01:22:12 +00:00
  • 56218fbc48 Minor tweaking of index special-space definitions so that the various index types can be reliably distinguished by examining the special space on an index page. Per my earlier proposal, plus the realization that there's no need for btree's vacuum cycle ID to cycle through every possible 16-bit value. Restricting its range a little costs nearly nothing and eliminates the possibility of collisions. Memo to self: remember to make bitmap indexes play along with this scheme, assuming that patch ever gets accepted. Tom Lane 2007-04-09 22:04:08 +00:00
  • 485d9ca96f Add URL for: Bruce Momjian 2007-04-09 21:18:29 +00:00
  • 6e09df9d26 Add cancel handlers so it's possible to Ctrl-C clusterdb, reindexdb and vacuumdb. ITAGAKI Takahiro, with minor fixes from me. Magnus Hagander 2007-04-09 18:21:22 +00:00
  • eb19be2e0f Fix spelling: SYMETRIC -> SYMMETRIC Peter Eisentraut 2007-04-09 07:40:23 +00:00
  • bbed5ba914 Done: Bruce Momjian 2007-04-08 02:17:02 +00:00
  • e51ac1b899 Minor editorialization on CLUSTER reference page. Tom Lane 2007-04-08 02:07:35 +00:00
  • 7b78474da3 Make CLUSTER MVCC-safe. Heikki Linnakangas Tom Lane 2007-04-08 01:26:33 +00:00
  • 2fca2c05e7 Add -F option to set fillfactor for tellers, accounts and branches. Patch contributed by Pavan Deolasee. Along with Japanese doc modification by Tatsuo Ishii. Tatsuo Ishii 2007-04-08 01:15:07 +00:00
  • c218c0bfda Done: Bruce Momjian 2007-04-08 00:36:08 +00:00
  • e55c8e36ae Support syntax "CLUSTER table USING index", which is more logical. Bruce Momjian 2007-04-08 00:26:34 +00:00
  • d7e2de6629 Add note that TRUNCATE is not MVCC-safe. Tom Lane 2007-04-07 17:12:15 +00:00
  • b0194ab110 Add the usage count statistics to the information available in contrib/pgbuffercache. Bruce Momjian 2007-04-07 16:09:14 +00:00
  • 627939c337 Backpatch doc change SYMETRIC -> SYMMETRIC, for 8.2.X. Bruce Momjian 2007-04-07 15:43:47 +00:00
  • 5695f38f74 Slight wording improvement. Bruce Momjian 2007-04-07 04:04:56 +00:00
  • 64ee1a8a55 Fix a few typos in the docs. Neil Conway 2007-04-07 03:58:08 +00:00