git.postgresql.org Git - postgresql.git/log
From: Massimo Dal Zotto <dz@cs.unitn.it>
Subject: [HACKERS] lock debug trace
This is an update to my previous patches for lock debugging, already applied
to the current sources. It adds some improvements in the output messages and
some more output in WaitOnLock(). I have used with success to trace a nasty
deadlock condition on pg_listener.
From: Andrew Martin <martin@biochemistry.ucl.ac.uk>
Just noticed that the psql man page is missing the -T option for specifying
HTML table options.
Date/Time updates from Thomas...
Date/Time updates from Thomas...
> There are some minor fixes to the GEQO.
> Please apply them to the direcory "backend/optimizer/geqo".
> Two new files with different crossover techniques are included.
> Standard procedure is optimization by means of "geqo_erx.c"
> (Edge Recombination Crossover).
From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
Last of Dan's hidden tar balls :)
Missed another tar file... :(
Missing bits from Dan's patches...sorry :(
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] timestamp type
OK, last one. This patch adds an ANSI SQL 'timestamp' type.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] password authentication
This patch adds support for plaintext password authentication. To use
it, you add a line like
host all 0.0.0.0 0.0.0.0 password pg_pwd.conf
to your pg_hba.conf, where 'pg_pwd.conf' is the name of a file containing
the usernames and password hashes in the format of the first two fields
of a Unix /etc/passwd file. (Of course, you can use a specific database
name or IP instead.)
Then, to connect with a password through libpq, you use the PQconnectdb()
function, specifying the "password=" tag in the connect string and also
adding the tag "authtype=password".
I also added a command-line switch '-u' to psql that tells it to prompt
for a username and password and use password authentication.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] linux/alpha patches
These patches lay the groundwork for a Linux/Alpha port. The port doesn't
actually work unless you tweak the linker to put all the pointers in the
first 32 bits of the address space, but it's at least a start. It
implements the test-and-set instruction in Alpha assembly, and also fixes
a lot of pointer-to-integer conversions, which is probably good anyway.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] linux/alpha patches
These patches lay the groundwork for a Linux/Alpha port. The port doesn't
actually work unless you tweak the linker to put all the pointers in the
first 32 bits of the address space, but it's at least a start. It
implements the test-and-set instruction in Alpha assembly, and also fixes
a lot of pointer-to-integer conversions, which is probably good anyway.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] equal column and table name patch
This fixes a bug where selects fail when there is a column with the same
name as the table it's a part of.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] better access control error messages
This patch replaces the 'no such class or insufficient privilege' with
distinct error messages that tell you whether the table really doesn't
exist or whether access was denied.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] backend Makefile patch
This patch cleans up backend/Makefile a little bit, and prevents it from
relinking the backend binary when no changes have been made.
From: Dan McGuirk <mcguirk@indirect.com>
Subject: [HACKERS] abort failed transaction patch
This patch allows you to end a transaction that has failed on an error
using the 'ABORT' statement without generating another error message.
(By default you get an error unless you use 'END' to terminate the
transaction, which has already been aborted anyway.)
Add in the sunos4 portname to configure detection
Add missing paren.
Massimo's Deadlock patches w/o the #ifdefs
Vacuum cleanups from Massimo.
Add prototypes for oracle-compat functions. Rename geo-*.c adt to geo_*.c
Fix vacuum crash Vadim found.
Reverse patch for Vadims problem.
Add man page for oracle compatibility functions
By Edmund
Move nextstep into problem/bug section.
Fix vacuum bug Vadim found with text fields.
Not understandable fix of strange bug in vacuum statistic functions.
This is a set of single row character functions, defined for the datatype
text, which are supposed to behave exactly as their Oracle counterparts.
From: Edmund Mergl <E.Mergl@bawue.de>
Fix the prototype for on_exitpg()
Patch from Martin due to changes in joinrels.c
New TODO.
Prevent SIGPIPE from crashing server, by Dan McGuirk.
Change debug to pretty-print tree, recommended by Darren King.
flex 2.5.3 warning from Andrew Martin.
Apply date patch from tiemann@cygnus.com,Michael Tiemann.
Remove _PAGE_SIZE_ as recommended by Darren King.
Remove case-sensitive identifiers. Thanks for Dan McGuirk for a reversal patch.
Change machine/limits.h to limits.h.
Small regress cleanup.
Fix example so it works.
Substitute defines for numeric constants in type ids.
Use INT4OID instead of 23.
Make sure anything configure related is removed on a distclean
Create a distclean make directive to handle cleaning out configure
generated files, that shouldn't be removed on a make clean
Pointed out by half the hackers mailing list :)
Remove second 'all' directive
Pointed out by Bruce
Allow update x =-3, not just x = -3.
Remove old READMEs.
Remove SUBSYS.o in port/ on clean.
Remove win32 port directory. Forgot to do it earlier.
Updated FAQ
Fix, I think, the stdup.o problem reported on those systems without
it.
Change "WARN" message generated if a unique index is attempted on a table/key
containing non-unique data
Added: UNIQUE feature to bulkload code.
Make the error message output by AllocateFile() if failes to
open Nulldev a *bit* more user friendly...or, at least, admin
friendly...have it print strerror(errno) as well
Add in port hpux to configure
Pointed out by: Mark Hollomon <mhh@nortel.ca>
Fix for queries with 3 or more relations participating in
one clause.
Prevent under/over flow of float8 constants in parser. Small regression fix.
Disable GEQO...it seems to be broken as shown by the message to
bugs@postgresql.org concerning updates
Various cleanups to satisfy -Werror, but there are some errors that I'm
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 first
Remove WIN32 stuff, and improve conformance to configure
Didn't *quite* work the way I thought it would...default'd to clean,
not make all :( Fixed...
Add a clean target so that the root directory gets cleared of all
the "configure" related files on a make clean
Removed a ',' that didn't belong in the timezone test case
Pointed out by: afc@teri.superlink.net
Add v6.1/Enhancements Section...or at least start it
And, make sure that initdb.sh copies the pg_geqo.sample file to
${DATADIR}. The file is left as pg_geqo.sample, since, unlike
pg_hba.conf, it isn't a required file...but this way ppl know that
its there, and that its where it is required, if they choose to
use it
Add and install the pg_geqo.sample file
Add the GEQO Todo file too
Add the GEQO README file to the docs distribution
Merge in GEQO Optimizer
From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de>
Delete -e option to postmaster, keep postgres -e option.
Update btree patches that were missed.
Clarify clearing of attribute stats memory.
Oper_right added, broken with const. conversion.
Add prototypes and remove unused variables from btree Fastbuild patch.
Remove hardcoded 20000 and change to BootstrapObjectIdData.
Remove WIN32 defines. They never worked.
Fix naming from proc to prio to fix previous patch.
Only allow NULL in the prpoer places.
Bring in Leo's <lsh@lubrizol.com> massive changes to libpq++
Improvements to the ultrix port, in particular a bunch of compiler
quieting prototyping in port/ultrix4.h
Submitted by: Erik Bertelsen <erik@sockdev.uni-c.dk>
Had configure check for strdup, but didn't have it set HAVE_STRDUP
Fixed
Various patches for nextstep by GregorHoffleit
Replaced NEED_STRDUP by !HAVE_STRDUP
Patch for:
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>
Removed a reference to DATADIR that still existed
Patch from Massimo Dal Zotto <dz@cs.unitn.it>
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.
Make sure we have an irix port
Pointed out by: Dave Morrison (mirrison@mail.phy.ornl.gov)
What looks like some *major* improvements to btree indexing...
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.
Add comment for questionable 5 padding.
Fix \? syntax for copy command.
Remove machine.h, since it wasn't doing anything that config.h wasn't
already doing
Removed only reference to a machine.h I could find in c.h, to win32/machine.h
Try to further reduce the PORT dependencies.
Essentially, config.h now includes an 'os.h', which is created via
configure by linking a "port.h" file from the port directory to the
include directory.
Going to try to merge backend/port in similar ways
Remove NO_{SIGPROCMASK,SETSID,WAITPID} from nextstep port, since they
aren't doing anything anyway
Changes to configure/config.h.in to check for:
sigprocmask, setsid and waitpid
Especially for nextstep systems
Awaiting for a context diff from Gregor to complete changes for the nextstep
port
Various fixes suggested by Gregor Hoffleit
Add a check to configure for strdup
Remove all the '-ltermcap' checks from psql/Makefile
Have {psql,pg_dump}/Makefile modified if strdup doesn't exist on the system
|I took a look at this and I think pg_dump mishandles arrays of ints and floats
|by neglecting to quote them.
|
|I have made a minor change to pg_dump.c that will fix this.
|
|Dates are dumped and restored OK with pg_dump in V6
|
|We'll still need to fix the dump in both cases if the original dump is from V1.09.
From Keith Parks
Add missing paren for hpux.
Oops, the port is ultrix4, not ultrix
Pointed out by: Erik Bertelsen
Add in netbsd*) to configure
Pointed out by D'Arcy
Add attribute optimization statistics.
This is the main PostgreSQL git repository.
RSS
Atom