aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* Change "WARN" message generated if a unique index is attempted on a table/keyMarc G. Fournier1997-02-25
| | | | containing non-unique data
* Added: UNIQUE feature to bulkload code.Vadim B. Mikheev1997-02-22
|
* Make the error message output by AllocateFile() if failes toMarc G. Fournier1997-02-20
| | | | | open Nulldev a *bit* more user friendly...or, at least, admin friendly...have it print strerror(errno) as well
* Fix for queries with 3 or more relations participating inVadim B. Mikheev1997-02-20
| | | | one clause.
* Prevent under/over flow of float8 constants in parser. Small regression fix.Bruce Momjian1997-02-19
|
* Various cleanups to satisfy -Werror, but there are some errors that I'mMarc G. Fournier1997-02-19
| | | | | not certain how to fix, so left them there and enabled -Wno-error for this directory for now
* rearrange ordering of headers os that postgres.h is firstMarc G. Fournier1997-02-19
|
* Remove WIN32 stuff, and improve conformance to configureMarc G. Fournier1997-02-19
|
* Add and install the pg_geqo.sample fileMarc G. Fournier1997-02-19
|
* Merge in GEQO OptimizerMarc G. Fournier1997-02-19
| | | | From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
* Delete -e option to postmaster, keep postgres -e option.Bruce Momjian1997-02-19
|
* Update btree patches that were missed.Bruce Momjian1997-02-18
|
* Clarify clearing of attribute stats memory.Bruce Momjian1997-02-18
|
* Oper_right added, broken with const. conversion.Bruce Momjian1997-02-14
|
* Add prototypes and remove unused variables from btree Fastbuild patch.Bruce Momjian1997-02-14
|
* Remove hardcoded 20000 and change to BootstrapObjectIdData.Bruce Momjian1997-02-14
|
* Remove WIN32 defines. They never worked.Bruce Momjian1997-02-14
|
* Fix naming from proc to prio to fix previous patch.Bruce Momjian1997-02-13
|
* Only allow NULL in the prpoer places.Bruce Momjian1997-02-13
|
* Improvements to the ultrix port, in particular a bunch of compilerMarc G. Fournier1997-02-13
| | | | | | quieting prototyping in port/ultrix4.h Submitted by: Erik Bertelsen <erik@sockdev.uni-c.dk>
* Various patches for nextstep by GregorHoffleitMarc G. Fournier1997-02-13
| | | | Replaced NEED_STRDUP by !HAVE_STRDUP
* Patch for:Marc G. Fournier1997-02-13
| | | | | | | | | The following patch to src/backend/libpq/pqpacket.c provides additional checking for bad packet length data. It was tested with the Linux telnet client, with netcat using the numbers.txt and by dumping random numbers into the port. Patch by: Alvaro Martinez Echevarria <alvaro@lander.es>
* Patch from Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1997-02-12
| | | | | | | | | | The following patches add to the backend a new debugging flag -K which prints a debug trace of all locking operations on user relations (those with oid greater than 20000). The code is compiled only if LOCK_MGR_DEBUG is defined, so the patch should be harmless if not explicitly enabled. I'm using the code to trace deadlock conditions caused by application queries using the command "$POSTMASTER -D $PGDATA -o '-d 1 -K 1'. The patches are for version 6.0 dated 970126.
* What looks like some *major* improvements to btree indexing...Marc G. Fournier1997-02-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Patches from: aoki@CS.Berkeley.EDU (Paul M. Aoki) i gave jolly my btree bulkload code a long, long time ago but never gave him a bunch of my bugfixes. here's a diff against the 6.0 baseline. for some reason, this code has slowed down somewhat relative to the insertion-build code on very small tables. don't know why -- it used to be within about 10%. anyway, here are some (highly unscientific!) timings on a dec 3000/300 for synthetic tables with 10k, 100k and 1000k tuples (basically, 1mb, 10mb and 100mb heaps). 'c' means clustered (pre-sorted) inputs and 'u' means unclustered (randomly ordered) inputs. the 10k table basically fits in the buffer pool, but the 100k and 1000k tables don't. as you can see, insertion build is fine if you've sorted your heaps on your index key or if your heap fits in core, but is absolutely horrible on unordered data (yes, that's 7.5 hours to index 100mb of data...) because of the zillions of random i/os. if it doesn't work for you for whatever reason, you can always turn it back off by flipping the FastBuild flag in nbtree.c. i don't have time to maintain it. good luck! baseline code: time psql -c 'create index c10 on k10 using btree (c int4_ops)' bttest real 8.6 time psql -c 'create index u10 on k10 using btree (b int4_ops)' bttest real 9.1 time psql -c 'create index c100 on k100 using btree (c int4_ops)' bttest real 59.2 time psql -c 'create index u100 on k100 using btree (b int4_ops)' bttest real 652.4 time psql -c 'create index c1000 on k1000 using btree (c int4_ops)' bttest real 636.1 time psql -c 'create index u1000 on k1000 using btree (b int4_ops)' bttest real 26772.9 bulkloading code: time psql -c 'create index c10 on k10 using btree (c int4_ops)' bttest real 11.3 time psql -c 'create index u10 on k10 using btree (b int4_ops)' bttest real 10.4 time psql -c 'create index c100 on k100 using btree (c int4_ops)' bttest real 59.5 time psql -c 'create index u100 on k100 using btree (b int4_ops)' bttest real 63.5 time psql -c 'create index c1000 on k1000 using btree (c int4_ops)' bttest real 636.9 time psql -c 'create index u1000 on k1000 using btree (b int4_ops)' bttest real 701.0
* Assign priorities when creating jobs in lock queue.Bruce Momjian1997-02-11
|
* Remove machine.h, since it wasn't doing anything that config.h wasn'tMarc G. Fournier1997-02-09
| | | | | | already doing Removed only reference to a machine.h I could find in c.h, to win32/machine.h
* Add attribute optimization statistics.Bruce Momjian1997-02-07
|
* Remove extra paren in ifdef.Bruce Momjian1997-02-06
|
* Various changes to improve/support MklinuxMarc G. Fournier1997-02-06
| | | | Submitted by: Tatsuo Ishii
* autoconf test for and set HAVE_VFORKMarc G. Fournier1997-02-06
|
* Get in there...Marc G. Fournier1997-02-05
|
* Test for existence of inet_aton on the system, and only include inet_aton.c ifMarc G. Fournier1997-02-04
| | | | | | required Pointed out by Brian E. Gallew
* Change references to NEED_RUSAGE to HAVE_RUSAGEMarc G. Fournier1997-02-03
| | | | Pointed out by:" Tatsuo Ishii <t-ishii@sra.co.jp>
* New func _vc_scanoneind: scan one index relation to update statisticVadim B. Mikheev1997-01-29
| | | | in pg_class if no one page was reapped by vacuum.
* Apply usage patches for European Dates patch from KeithMarc G. Fournier1997-01-27
|
* Slight change to nabstime.c so that configure is able to handle a systemMarc G. Fournier1997-01-27
| | | | | | | whereby timezone isn't an int, but tzset() exists... This isn't a definitive fix, as there is probably an easier way of fixing the bug...
* Convert MISSING_SYSCONF to !HAVE_SYSCONF for autoconfMarc G. Fournier1997-01-27
| | | | From: Keith Parks
* More removals for next/nextstep. Fix IPC lib for them.Bruce Momjian1997-01-26
|
* Change next to nextstep where missed.Bruce Momjian1997-01-26
|
* |From: Keith Parks <emkxp01@mtcc.demon.co.uk>Marc G. Fournier1997-01-26
| | | | | | | | | | | | | | | | | | | | | | |Subject: [PATCH] adding SYS_TIME just for fun. | |Hi, | |Whilst I was playing round with the European dates patch I noticed the sysfunc() |that allows you to do :- | |create table test ( da date); |insert into test values (SYS_DATE); | |and have the current system date inserted. | |So I thought it would be nice to have the SYS_TIME facility too. | |I've cloned the function and changed a few things and there you have it, |you can now do: | |create table test2 ( ti time); |insert into test2 values (SYS_TIME);
* Linux defines MAXINT in values.h, which causes an error when compiling.Marc G. Fournier1997-01-26
| | | | Wrap it in an #ifndef to prevent this
* Bring in a patch from Keith Parks to move the use of European datesMarc G. Fournier1997-01-26
| | | | | | from a #define to a run-time option '-e' Man page was updated to reflect new option
* Fix typo in struct name.Bruce Momjian1997-01-26
|
* would you mind committing the following changes for me? (the firstBruce Momjian1997-01-25
| | | | | bug causes compilation to fail on alpha, the second causes a compiler in this environment
* More autosize structure error checks.Bruce Momjian1997-01-25
|
* The check should be for getrusage(), not rusage() ... change the definesMarc G. Fournier1997-01-25
| | | | to reflect what configure is going to define when the time comes
* remove asm/bitops.h, as its causing more problems then it fixes.Marc G. Fournier1997-01-25
|
* Switch over NEED_RUSAGE to HAVE_RUSAGE for configureMarc G. Fournier1997-01-24
|
* Change NEED_SIG_JMP to HAVE_SIGSETJMP in preparation for configureMarc G. Fournier1997-01-24
|
* Another switch for configure: NEED_SYS_SELECT_H to HAVE_SYS_SELECT_HMarc G. Fournier1997-01-24
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 19:46:22 +0000