summaryrefslogtreecommitdiff
path: root/src/backend/storage
Commit message (Collapse)AuthorAgeFilesLines
* Rearrange handling of MAXBACKENDS a little bit. The default settingTom Lane1999-02-214-40/+44
| | | | | | | | | of MAXBACKENDS is now 1024, since all it's costing is about 32 bytes of memory per array slot. configure's --with-maxbackends switch now controls DEF_MAXBACKENDS which is simply the default value of the postmaster's -N switch. Thus, the out-of-the-box configuration will still limit you to 64 backends, but you can go up to 1024 backends simply by restarting the postmaster with a different -N switch --- no rebuild required.
* Reorder startup ops so that if preallocation of semas fails,Tom Lane1999-02-192-5/+13
| | | | postmaster will release whatever it did get before dying.
* Allow maximum number of backends to be set at configure timeTom Lane1999-02-194-33/+74
| | | | | | | | | (--with-maxbackends). Add a postmaster switch (-N backends) that allows the limit to be reduced at postmaster start time. (You can't increase it, sorry to say, because there are still some fixed-size arrays.) Grab the number of semaphores indicated by min(MAXBACKENDS, -N) at postmaster startup, so that this particular form of bogus configuration is exposed immediately rather than under heavy load.
* Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian1999-02-1326-77/+77
|
* Large object write-into-middle fix from Tatsuo Ishii.Bruce Momjian1999-02-041-2/+8
|
* Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian1999-02-035-27/+16
|
* Add TEMP tables/indexes. Add COPY pfree(). Other cleanups.Bruce Momjian1999-02-022-15/+10
|
* The following patch finishes primary key support. Previously, whenBruce Momjian1999-01-211-2/+2
| | | | | | | | | | | | | | | | | | | | a field was labelled as a primary key, the system automatically created a unique index on the field. This patch extends it so that the index has the indisprimary field set. You can pull a list of primary keys with the followiing select. SELECT pg_class.relname, pg_attribute.attname FROM pg_class, pg_attribute, pg_index WHERE pg_class.oid = pg_attribute.attrelid AND pg_class.oid = pg_index.indrelid AND pg_index.indkey[0] = pg_attribute.attnum AND pg_index.indisunique = 't'; There is nothing in this patch that modifies the template database to set the indisprimary attribute for system tables. Should they be changed or should we only be concerned with user tables? D'Arcy
* fixes to lock debugging macros from Massimo Dal ZottoTom Lane1999-01-171-6/+9
|
* Apply Win32 patch from Horak Daniel.Bruce Momjian1999-01-171-1/+25
|
* Replace direct inclusions of c.h with inclusion of postgres.h,Tom Lane1999-01-171-3/+2
| | | | to ensure that config.h is included as well.
* Update for deadlock detection.Bruce Momjian1998-12-291-18/+29
|
* Update for deadlock timer.Bruce Momjian1998-12-291-11/+10
|
* Fix for deadlock timer timeout.Bruce Momjian1998-12-291-15/+9
|
* Long awaited port for NetBSD/m68k was finally done by Mr. MutsukiBruce Momjian1998-12-261-1/+20
| | | | | | | | | | Nakajima. Since he is not subscribing the mailing list, I'm posting his patches by his request. According to him, he has successfully compiled and passed the regression test on Mac SE/30 running NetBSD/m68k. Also, another person has reported that with the patches PostgreSQL is working on NetBSD/sun3 too. -- Tatsuo Ishii
* Fix deadlock so it only checks once.Bruce Momjian1998-12-181-19/+18
|
* I have ported PostgreSQL 6.4 to Cobalt Qube running Linux 2.0.33 withBruce Momjian1998-12-181-2/+23
| | | | | | | MIPS cpu (I think it's R4000). I have tested the patches on LinuxPPC and FreeBSD. I believe they do not harm other platforms. -- Tatsuo Ishii
* SET TRANSACTION ISOLATION LEVEL ...Vadim B. Mikheev1998-12-181-3/+6
| | | | | LOCK TABLE IN ... MODE ...implemented
* Serialized mode works!Vadim B. Mikheev1998-12-162-15/+9
|
* Initial MVCC code.Vadim B. Mikheev1998-12-159-514/+362
| | | | New code for locking buffer' context.
* Fix for lo_import crash.Bruce Momjian1998-12-131-2/+2
|
* New HeapTuple structure/interface.Vadim B. Mikheev1998-11-271-51/+53
|
* Get rid of some minor compiler warnings.Tom Lane1998-10-261-2/+2
| | | | | (HP's cc doesn't like if you forward-declare a routine static, and then don't make it static in the actual definition...)
* Make functions static or ifdef NOT_USED. Prevent pg_version creation.Bruce Momjian1998-10-084-5/+17
|
* Fix for double free from Tatsuo IshiiBruce Momjian1998-10-061-3/+2
|
* NS32K lock patch reversed.Bruce Momjian1998-09-181-12/+1
|
* Fix for NS32K machine.Bruce Momjian1998-09-181-1/+12
|
* >Bruce Momjian1998-09-091-9/+7
| | | | | | | | | | | | | | | > Open portability issues: > > /usr/local should be searched for lib and include for all ports if present > (currently not working, I have libreadline there) > > the stream functions on AIX need a size_t for addrlen's in fe-connect.c and pqcomm.c. > > lock.c still has an incompatible TPRINTF(flags, args...) definition Massimo
* offsetof cleanup.Bruce Momjian1998-09-041-3/+3
|
* t_bits alignment fix from Tatsuo IshiiBruce Momjian1998-09-041-3/+5
|
* O2. Seems tas() for PPC (storage/buffer/s_lock.c) never works ifBruce Momjian1998-09-031-13/+16
| | | | | | | | | | compiled with -O0. Included are patches that should fix the problem (of course I have confirmed -O2 works with this patch). BTW, here is a platforms/regression test failure(serious one--backend death) matrix. Tatsuo Ishii
* Fix for indexing problems.Bruce Momjian1998-09-021-2/+3
|
* OK, folks, here is the pgindent output.Bruce Momjian1998-09-0120-361/+415
|
* Renaming cleanup, no pgindent yet.Bruce Momjian1998-09-0121-344/+344
|
* From: Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1998-08-281-2/+2
| | | | | | | I have this small patch which fixes a typo in my previous lock patches. Fortunately the bug affects only user locks. -
* Fix 'd ' should be 'd'.Bruce Momjian1998-08-271-2/+1
|
* From: Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1998-08-252-42/+78
| | | | | | | | | | | | > tprintf.patch > > tprintf.patch > > adds functions and macros which implement a conditional trace package > with the ability to change flags and numeric options of running > backends at runtime. > Options/flags can be specified in the command line and/or read from > the file pg_options in the data directory.
* From: Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1998-08-252-5/+20
| | | | | | | | | | | | | | | > sinval.patch > > fixes a problem in SI cache which causes table overflow if some > backend is idle for a long time while other backends keep adding > entries. > It uses the new signal handling implemented in tprintf.patch. > I have also increacasesed the max number of backends from 32 to 64 > and the table size from 1000 to 5000. > I don't know if anybody is working on SI, but until another > solution is found this patch fixes the problem. I have received > messages from other people reporting the same problem which I > fixed many months ago.
* From: Massimo Dal Zotto <dz@cs.unitn.it>Marc G. Fournier1998-08-253-485/+911
| | | | | | | | | | lock.patch I have rewritten lock.c cleaning up the code and adding better assert checking I have also added some fields to the lock and xid tags for better support of user locks. There is also a new function which returns an array of pids owning a lock. I'm using this code from over six months and it works fine.
* o note that now pg_database has a new attribuite "encoding" evenBruce Momjian1998-08-242-19/+2
| | | | | | | | | | | | | | | | | | | | | | if MULTIBYTE is not enabled. So be sure to run initdb. o these patches are made against the latest source tree (after Bruce's massive patch, I think) BTW, I noticed that after running regression, the oid field of pg_type seems disappeared. regression=> select oid from pg_type; ERROR: attribute 'oid' not found this happens after the constraints test. This occures with/without my patches. strange... o pg_database_mb.h, pg_class_mb.h, pg_attribute_mb.h are no longer used, and shoud be removed. o GetDatabaseInfo() in utils/misc/database.c removed (actually in #ifdef 0). seems nobody uses. t-ishii@sra.co.jp
* update fixes.Bruce Momjian1998-08-201-5/+3
|
* heap_fetch requires buffer pointer, must be released; heap_getnextBruce Momjian1998-08-196-96/+95
| | | | | | | | | | | | | no longer returns buffer pointer, can be gotten from scan; descriptor; bootstrap can create multi-key indexes; pg_procname index now is multi-key index; oidint2, oidint4, oidname are gone (must be removed from regression tests); use System Cache rather than sequential scan in many places; heap_modifytuple no longer takes buffer parameter; remove unused buffer parameter in a few other functions; oid8 is not index-able; remove some use of single-character variable names; cleanup Buffer variables usage and scan descriptor looping; cleaned up allocation and freeing of tuples; 18k lines of diff;
* Change owner from oid to int4 type.Bruce Momjian1998-08-111-5/+5
|
* Make large objects their own relkind type. Fix dups in pg_class_mbBruce Momjian1998-08-061-2/+2
| | | | files. Fix sequence creation hack for relkind type.
* Lmgr cleanup, new locking modes for LLL.Vadim B. Mikheev1998-08-013-325/+80
|
* Use Snapshot in heap access methods.Vadim B. Mikheev1998-07-273-8/+88
|
* From: t-ishii@sra.co.jpMarc G. Fournier1998-07-264-13/+13
| | | | | | | | | As Bruce mentioned, this is due to the conflict among changes we made. Included patches should fix the problem(I changed all MB to MULTIBYTE). Please let me know if you have further problem. P.S. I did not include pathces to configure and gram.c to save the file size(configure.in and gram.y modified).
* I really hope that I haven't missed anything in this one...Marc G. Fournier1998-07-244-4/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | From: t-ishii@sra.co.jp Attached are patches to enhance the multi-byte support. (patches are against 7/18 snapshot) * determine encoding at initdb/createdb rather than compile time Now initdb/createdb has an option to specify the encoding. Also, I modified the syntax of CREATE DATABASE to accept encoding option. See README.mb for more details. For this purpose I have added new column "encoding" to pg_database. Also pg_attribute and pg_class are changed to catch up the modification to pg_database. Actually I haved added pg_database_mb.h, pg_attribute_mb.h and pg_class_mb.h. These are used only when MB is enabled. The reason having separate files is I couldn't find a way to use ifdef or whatever in those files. I have to admit it looks ugly. No way. * support for PGCLIENTENCODING when issuing COPY command commands/copy.c modified. * support for SQL92 syntax "SET NAMES" See gram.y. * support for LATIN2-5 * add UNICODE regression test case * new test suite for MB New directory test/mb added. * clean up source files Basic idea is to have MB's own subdirectory for easier maintenance. These are include/mb and backend/utils/mb.
* VariableCache (next XID generator) is placed in shmem.Vadim B. Mikheev1998-07-211-3/+12
|
* Theses buffer leaks are caused by indexes that are kept open betweenBruce Momjian1998-07-211-4/+50
| | | | | | | | | | | | | | | | | | | | | calls. Outside a transaction, the backend detects them as buffer leaks; it sends a NOTICE, and frees them. This sometimes cause a segmentation fault (at least on Linux). These indexes are initialized on the first lo_read/lo_write/lo_tell call, and (normally) closed on a lo_close call. Thus the buffer leaks appear when lo direct access functions are used, and not with lo_import/lo_export functions (libpq version calls lo_close before ending the command, and the backend version uses another path). The included patches (against recent snapshot, and against 6.3.2) cause indexes to be closed on transaction end (that is on explicit 'END' statment, or on command termination outside trasaction blocks), thus preventing the buffer leaks while increasing performance inside transactions. Some (all?) 'classic' memory leaks are also removed. I hope it will be ok. --- Pascal ANDRE, graduated from Ecole Centrale Paris andre@via.ecp.fr
View Lorry Controller Status