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

Commit Graph

  • a4f72d5940 Fix erroneous Assert() in syslogger process start in EXEC_BACKEND case, per ITAGAKI Takahiro. Also, rewrite syslogger_forkexec() in hopes of eliminating the confusion in the first place. Tom Lane 2007-09-22 18:19:24 +00:00
  • f316222930 Fix erroneous Assert() in syslogger process start in EXEC_BACKEND case, per ITAGAKI Takahiro. Also, rewrite syslogger_forkexec() in hopes of eliminating the confusion in the first place. Tom Lane 2007-09-22 18:19:18 +00:00
  • 245dd2bca7 Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:36:20 +00:00
  • a51302deb3 Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:36:14 +00:00
  • f0a06adfe7 Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:36:07 +00:00
  • 4de99f840b Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:36:00 +00:00
  • a9f08b41ac Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:35:52 +00:00
  • bbda96d76d Fix bogus calculation of potential output string length in translate(). Tom Lane 2007-09-22 05:35:42 +00:00
  • 571340a00e Parenthesize macro arguments safely. I see no bug among the current uses of PG_DETOAST_DATUM_SLICE, but it's clearly trouble waiting to happen. Tom Lane 2007-09-22 04:41:19 +00:00
  • 5e87ebb0c3 Although I'd misdiagnosed the reason for the recent failures on buildfarm member grebe, I see no reason to revert the 1-byte-header-friendly changes I made in varlena.c. Instead, tweak the code a little bit to get more advantage out of that. Tom Lane 2007-09-22 04:40:03 +00:00
  • 94470b9499 Doh --- what's really happening on buildfarm member grebe is that its malloc returns NULL for malloc(0). Defend against that case. Tom Lane 2007-09-22 04:37:53 +00:00
  • e152893305 Go back to using a separate method for doing ILIKE for single byte character encodings that doesn't involve calling lower(). This should cure the performance regression in this case complained of by Guillaume Smet. It still leaves the horrid performance for multi-byte encodings introduced in 8.2, but there's no obvious solution for that in sight. Andrew Dunstan 2007-09-22 03:58:34 +00:00
  • b5d1608b0a Fix varlena.c routines to allow 1-byte-header text values. This is now demonstrably necessary for text_substring() since regexp_split functions may pass it such a value; and we might as well convert the whole file at once. Per buildfarm results (though I wonder why most machines aren't showing a failure). Tom Lane 2007-09-22 00:36:38 +00:00
  • 7583f9a7ca Fix regex, LIKE, and some other second-rank text-manipulation functions to not cause needless copying of text datums that have 1-byte headers. Greg Stark, in response to performance gripe from Guillaume Smet and ITAGAKI Takahiro. Tom Lane 2007-09-21 22:52:52 +00:00
  • cc59049daf Improve handling of prune/no-prune decisions by storing a page's oldest unpruned XMAX in its header. At the cost of 4 bytes per page, this keeps us from performing heap_page_prune when there's no chance of pruning anything. Seems to be necessary per Heikki's preliminary performance testing. Tom Lane 2007-09-21 21:25:42 +00:00
  • 386a5d4268 Change tqual.c tests to use !TransactionIdIsCurrentTransactionId, rather than TransactionIdDidAbort, when handling the case that xmin is one of the current transaction's XIDs and the tuple has been deleted. xmax must also be one of the current transaction's XIDs, since no one else can see it yet, and it's cheaper to look at local state than shared state to find out if xmax aborted. Per an idea of Heikki's. Tom Lane 2007-09-21 18:24:28 +00:00
  • da072ab2ab Make some simple performance improvements in TransactionIdIsInProgress(). For XIDs of our own transaction and subtransactions, it's cheaper to ask TransactionIdIsCurrentTransactionId() than to look in shared memory. Also, the xids[] work array is always the same size within any given process, so malloc it just once instead of doing a palloc/pfree on every call; aside from being faster this lets us get rid of some goto's, since we no longer have any end-of-function pfree to do. Both ideas by Heikki. Tom Lane 2007-09-21 17:36:53 +00:00
  • bd0af827da Fix comments that misspelled TransactionIdIsInProgress, per Heikki. Tom Lane 2007-09-21 16:32:19 +00:00
  • 3e77c8c6c6 Removed superfluous ECPGfree() call. Michael Meskes 2007-09-21 10:59:27 +00:00
  • 017daed0dd If we're gonna provide an --enable-profiling configure option, surely it ought to know that you need -DLINUX_PROFILE on Linux. Tom Lane 2007-09-21 02:33:46 +00:00
  • 02185a0716 Insert a hack in pl/tcl to disable Tcl's built-in Notifier subsystem, which has a bad habit of launching multiple threads within the backend and thereby causing all kinds of havoc. Fortunately, we don't need it, and recent Tcl versions provide an easy way to disable it. Diagnosis and fix by Steve Marshall, Paul Bayer, and Doug Knight of WSI Corporation. Tom Lane 2007-09-21 00:30:49 +00:00
  • d22ae3ecc2 Solaris portability fix that was previously made in contrib/tsearch2 but got lost from the version committed to main tree. Per Greg Stark. Tom Lane 2007-09-20 23:27:11 +00:00
  • eb5f4d6c5c Revert ill-fated patch to release exclusive lock early after vacuum truncates a table. Introduces race condition, as shown by buildfarm failures. Tom Lane 2007-09-20 21:43:27 +00:00
  • 754838caa3 Done: Bruce Momjian 2007-09-20 18:54:19 +00:00
  • ad8fbb549a Cleanup items from csvlog changes, per ITAGAKI Takahiro. Andrew Dunstan 2007-09-20 18:19:08 +00:00
  • bab16af807 Fix msvc warnings, patch by Hannes Eder <Hannes@HannesEder.net> Teodor Sigaev 2007-09-20 18:10:57 +00:00
  • 282d2a03dd HOT updates. When we update a tuple without changing any of its indexed columns, and the new version can be stored on the same heap page, we no longer generate extra index entries for the new version. Instead, index searches follow the HOT-chain links to ensure they find the correct tuple version. Tom Lane 2007-09-20 17:56:33 +00:00
  • d5e6f4f828 Prevent corr() from returning the wrong results for negative correlation values. The previous coding essentially assumed that x = sqrt(x*x), which does not hold for x < 0. Neil Conway 2007-09-19 22:31:51 +00:00
  • bbf4fdc253 Prevent corr() from returning the wrong results for negative correlation values. The previous coding essentially assumed that x = sqrt(x*x), which does not hold for x < 0. Neil Conway 2007-09-19 22:31:48 +00:00
  • 4893eadc3c Remove tabs from SGML file. Bruce Momjian 2007-09-19 03:13:57 +00:00
  • 55613bf9cd Close previously open holes for invalidly encoded data to enter the database via builtin functions, as recently discussed on -hackers. Andrew Dunstan 2007-09-18 17:41:17 +00:00
  • 8544110042 Avoid possibly-unportable initializer, per buildfarm warning Teodor Sigaev 2007-09-18 15:03:23 +00:00
  • dc29d703d8 Doc reminder that integer pg version also needs updating. Bruce Momjian 2007-09-18 01:52:39 +00:00
  • 851745a97a Remove extra tab in postgresql.conf Bruce Momjian 2007-09-17 21:40:40 +00:00
  • 039dc49d55 Remove Assert(BgWriterShmem != NULL), which is rather pointless since we'd dump core anyway immediately afterward if it were null; and it seems to confuse some versions of icc into generating bad code. Per report from Sergey Koposov. Patched in HEAD only, for the moment, since this is only likely to affect developers. Tom Lane 2007-09-16 16:33:04 +00:00
  • ac5091b6ac Fix overflow in extract(epoch from interval) for intervals exceeding 68 years. Seems to have been introduced in 8.1 by careless SECS_PER_DAY search-and-replace. Tom Lane 2007-09-16 15:56:39 +00:00
  • eb4f4f5b7c Fix overflow in extract(epoch from interval) for intervals exceeding 68 years. Seems to have been introduced in 8.1 by careless SECS_PER_DAY search-and-replace. Tom Lane 2007-09-16 15:56:32 +00:00
  • 22d98e7934 Fix overflow in extract(epoch from interval) for intervals exceeding 68 years. Seems to have been introduced in 8.1 by careless SECS_PER_DAY search-and-replace. Tom Lane 2007-09-16 15:56:20 +00:00
  • 1aea75f047 Update release notes for last-minute fix. REL7_3_20 Tom Lane 2007-09-16 03:04:09 +00:00
  • 0a3b51efa0 Update release notes for last-minute fix. REL7_4_18 Tom Lane 2007-09-16 03:03:55 +00:00
  • 038f7e4afb Update release notes for last-minute fix. REL8_0_14 Tom Lane 2007-09-16 03:03:40 +00:00
  • 1498c45806 Update release notes for last-minute fix. REL8_1_10 Tom Lane 2007-09-16 03:03:27 +00:00
  • ee24168d2c Update release notes for last-minute fix. REL8_2_5 Tom Lane 2007-09-16 03:03:13 +00:00
  • e92da1a9d1 Update release notes for last-minute fix. Tom Lane 2007-09-16 03:03:00 +00:00
  • 2f2baf9299 Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:38:31 +00:00
  • 11a8925afd Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:38:25 +00:00
  • 60e3aafbbf Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:38:14 +00:00
  • be706260f0 Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:38:02 +00:00
  • 3d446c4767 Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:37:54 +00:00
  • 43b0c9182f Fix aboriginal mistake in lazy VACUUM's code for truncating away no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports. Tom Lane 2007-09-16 02:37:46 +00:00
  • 9a36a09f2e Update Japanese FAQ. Bruce Momjian 2007-09-15 00:58:19 +00:00
  • a93840e343 tag configure for 7.3.20 Marc G. Fournier 2007-09-15 00:26:05 +00:00
  • 2f2f9b9bae update configure for 7.4.18 Marc G. Fournier 2007-09-14 23:19:58 +00:00
  • b2f6211d19 tag configure for 8.0.14 Marc G. Fournier 2007-09-14 21:34:29 +00:00
  • cf45f1f4c0 update configure for 8.1.10 Marc G. Fournier 2007-09-14 20:23:46 +00:00
  • 67bc5b0ca3 update configure for 8.2.5 ... Marc G. Fournier 2007-09-14 20:18:26 +00:00
  • c16ffbc677 Add: Bruce Momjian 2007-09-14 19:02:46 +00:00
  • dc8a8a0463 Add: Bruce Momjian 2007-09-14 18:50:48 +00:00
  • 18cad61e67 Fix markup. Bruce Momjian 2007-09-14 18:39:58 +00:00
  • 637878cd85 Update pronunciation FAQ item. Bruce Momjian 2007-09-14 18:38:44 +00:00
  • 23221f4eea Update to mention alternate project name is "Postgres". Bruce Momjian 2007-09-14 18:29:59 +00:00
  • 63490ddf1e Remove GIN interface section, which is now documented in SGML. Bruce Momjian 2007-09-14 16:28:17 +00:00
  • b2acd633e4 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 16:15:35 +00:00
  • 038be7ea31 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 16:13:22 +00:00
  • b061801569 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 16:08:33 +00:00
  • d620f2d383 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 16:04:35 +00:00
  • 226b3129f5 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 16:01:03 +00:00
  • 7f9de5407a Fix GSS API pointer checking. Bruce Momjian 2007-09-14 15:58:02 +00:00
  • 8ea2d503b6 Fix markup that doesn't work in back branches. Tom Lane 2007-09-14 15:57:27 +00:00
  • 12afe7bc76 Document atan2() as y/x, rather than x/y, to conform to general usage. Bruce Momjian 2007-09-14 15:53:48 +00:00
  • dc3fa6afb0 Minor editorialization on release notes. Tom Lane 2007-09-14 15:51:59 +00:00
  • b75ac35bfd Minor editorialization on release notes. Tom Lane 2007-09-14 15:51:47 +00:00
  • 42765a29f9 Minor editorialization on release notes. Tom Lane 2007-09-14 15:51:31 +00:00
  • 0fcc0224fe Minor editorialization on release notes. Tom Lane 2007-09-14 15:51:18 +00:00
  • b7bddb3442 Minor editorialization on release notes. Tom Lane 2007-09-14 15:51:04 +00:00
  • 9b2afa90bf Minor editorialization on release notes. Tom Lane 2007-09-14 15:50:51 +00:00
  • 4b836d8312 Add some links for escape strings. Bruce Momjian 2007-09-14 14:54:25 +00:00
  • f6a168e2c3 Add LDAP URL documentation. Bruce Momjian 2007-09-14 14:31:22 +00:00
  • d915af072f Fix missed version-stamping. Tom Lane 2007-09-14 14:05:52 +00:00
  • 13e26073bd Update documentation to mention that autovacuum also does analyze so we don't need to recommend nightly analyzes anymore unless autovacuum is off. Bruce Momjian 2007-09-14 13:43:03 +00:00
  • 7e82fa8b7a Clarify tar documentation about return error codes. Bruce Momjian 2007-09-14 13:26:36 +00:00
  • fc79628641 Clarify tar documentation about return error codes. Bruce Momjian 2007-09-14 13:26:22 +00:00
  • ae36e0d589 Update tsearch include location in example. Bruce Momjian 2007-09-14 13:21:30 +00:00
  • 17aae41afd Add tsearch tab completion support: Bruce Momjian 2007-09-14 04:25:24 +00:00
  • c0f2b109bc This is small patch fixes a spi example (PG_MODULE_MAGIC is required as of PostgreSQL 8.2) and provides a link to compiling and linking section. Bruce Momjian 2007-09-14 04:18:27 +00:00
  • 6f5d343405 Update GNU tar error code documentation. Bruce Momjian 2007-09-14 04:16:44 +00:00
  • edc18429bd Update GNU tar error code documentation. Bruce Momjian 2007-09-14 04:15:50 +00:00
  • 6c9e4d7e08 Mentino that PAM doesn't work for Unix system authentication because of the problems non-root reading /etc/shadow. Bruce Momjian 2007-09-14 03:53:54 +00:00
  • 62c42d82aa Remove ill-considered (not to mention undocumented) attempt to make contrib/intarray's GIN opclass override the built-in default. Per bug #3048 and other complaints. Tom Lane 2007-09-14 03:25:37 +00:00
  • 2d6cb170d4 Remove ill-considered (not to mention undocumented) attempt to make contrib/intarray's GIN opclass override the built-in default. Per bug #3048 and other complaints. Tom Lane 2007-09-14 03:25:31 +00:00
  • aa33bdd783 Update documented error text. Bruce Momjian 2007-09-14 02:43:18 +00:00
  • dfe2e3f7a5 Clarify age() 'months' calculation documentation. Bruce Momjian 2007-09-14 00:52:45 +00:00
  • f307fe4c9b Update documentation to emphasize autovacuum rather than administrator-scheduled vacuums. Bruce Momjian 2007-09-13 23:43:35 +00:00
  • cfa22b8d20 Translation updates Peter Eisentraut 2007-09-13 21:15:37 +00:00
  • eae9062283 Translation updates Peter Eisentraut 2007-09-13 21:10:01 +00:00
  • 7feaeb809c Translation updates Peter Eisentraut 2007-09-13 21:04:12 +00:00
  • 93bba446ce Translation updates Peter Eisentraut 2007-09-13 20:56:32 +00:00
  • cc6dcf4c08 Translation updates Peter Eisentraut 2007-09-13 20:49:39 +00:00
  • 3e805fdcf7 Fix typo in typecasting. patch from ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> Teodor Sigaev 2007-09-13 06:54:35 +00:00
  • ebeec05f8a Update Japanese FAQ, backpatch. Bruce Momjian 2007-09-13 03:34:23 +00:00