OSDN Git Service
Bruce Momjian [Thu, 11 Feb 1999 14:59:09 +0000 (14:59 +0000)]
More optimizer speedups.
Bruce Momjian [Thu, 11 Feb 1999 05:29:08 +0000 (05:29 +0000)]
optimizer cleanup
Bruce Momjian [Thu, 11 Feb 1999 04:08:44 +0000 (04:08 +0000)]
Optimizer fix for samekeys() and cost fixes for longer optimizer keys.
Tom Lane [Thu, 11 Feb 1999 01:36:55 +0000 (01:36 +0000)]
Include <varargs.h> on SunOS. (Does any other platform need it??)
Bruce Momjian [Wed, 10 Feb 1999 21:02:50 +0000 (21:02 +0000)]
Optmizer cleanup
Bruce Momjian [Wed, 10 Feb 1999 17:14:32 +0000 (17:14 +0000)]
Update find_typedefs for bsdi 4.0.
Bruce Momjian [Wed, 10 Feb 1999 03:52:54 +0000 (03:52 +0000)]
Rename Path.keys to Path.pathkeys. Too many 'keys' used for other things.
Bruce Momjian [Tue, 9 Feb 1999 17:03:14 +0000 (17:03 +0000)]
Rename Temp to Noname for noname tables.
Bruce Momjian [Tue, 9 Feb 1999 06:30:45 +0000 (06:30 +0000)]
Optimizer fix for samekeys.
Bruce Momjian [Tue, 9 Feb 1999 03:51:42 +0000 (03:51 +0000)]
Major optimizer improvement for joining a large number of tables.
Jan Wieck [Mon, 8 Feb 1999 14:14:32 +0000 (14:14 +0000)]
Added LIMIT/OFFSET functionality including new regression test for it.
Removed CURRENT keyword for rule queries and changed rules regression
accordingly. CURRENT has beed announced to disappear in v6.5.
Jan
Bruce Momjian [Mon, 8 Feb 1999 04:29:25 +0000 (04:29 +0000)]
Optimizer cleanup.
Tom Lane [Mon, 8 Feb 1999 01:46:28 +0000 (01:46 +0000)]
pg_dump -d or -D didn't quote special characters in INSERT data
correctly. -D had problems with tables with inherited fields, also.
Jan Wieck [Mon, 8 Feb 1999 01:39:46 +0000 (01:39 +0000)]
Revert some changes from the INTERSECT/EXPECT patch that broke
rule system semantics by having Var nodes referenced across multiple
parsetrees when rules split them.
Added more tests to the rules regression test.
The code in question resulted from v6.3 based development and was
a little careless applied to the v6.5 source tree.
Jan
Tom Lane [Sun, 7 Feb 1999 23:59:59 +0000 (23:59 +0000)]
Simplify scanstr(), fix broken octal-escape code.
Tom Lane [Sun, 7 Feb 1999 23:58:52 +0000 (23:58 +0000)]
Simplify lexer's rules for string constants, eliminate potential buffer overrun.
Tom Lane [Sun, 7 Feb 1999 22:10:47 +0000 (22:10 +0000)]
Include -lcrypt when needed to link libpgtcl.so and plpgsql.so
Jan Wieck [Sun, 7 Feb 1999 22:10:10 +0000 (22:10 +0000)]
Changed manpages for create_rule/drop_rule to the semantics
of the rule system of v6.4 and descendants.
Jan
Tom Lane [Sun, 7 Feb 1999 22:08:54 +0000 (22:08 +0000)]
Add PQresStatus() function to avoid direct access to pgresStatus[] array,
making life easier for Windoids...
Tom Lane [Sun, 7 Feb 1999 22:07:02 +0000 (22:07 +0000)]
Clean up some minor compile warnings.
Tom Lane [Sun, 7 Feb 1999 22:04:57 +0000 (22:04 +0000)]
Correct definition of srandom() --- it takes unsigned int not int.
Jan Wieck [Sun, 7 Feb 1999 19:04:59 +0000 (19:04 +0000)]
New gram.c after modification of gram.y
Jan
Jan Wieck [Sun, 7 Feb 1999 19:02:20 +0000 (19:02 +0000)]
Reenabled parentheses for grouping multiple rule actions and
added this syntax to rules regression test so it will show up
if someone breaks it again.
Jan
Jan Wieck [Sun, 7 Feb 1999 16:17:14 +0000 (16:17 +0000)]
Changed ExecConstraints() and ExecRelCheck() to cache the constraints
qualification expression trees in the execution state. Prevents from
memory exhaustion on INSERT, UPDATE or COPY to tables that have CHECK
constraints. Speedup against the variant using freeObject() is more than
factor 2.
Jan
Jan Wieck [Sun, 7 Feb 1999 14:20:11 +0000 (14:20 +0000)]
Missing semicolon in last fix :-}
Jan
Jan Wieck [Sun, 7 Feb 1999 13:54:58 +0000 (13:54 +0000)]
One more fix to QuerySnapshot usage in ExecutorStart(). Maybe
current QuerySnapshot could be NULL.
Jan
Jan Wieck [Sun, 7 Feb 1999 13:37:56 +0000 (13:37 +0000)]
Fixed problem with multiple portals shown up in portals_p2 regression
test after new AllocSet code.
Activated optimal AllocSet blocksize and chunk limit.
Jan
Tom Lane [Sun, 7 Feb 1999 03:02:21 +0000 (03:02 +0000)]
Fix bracketing error in CaseExpr code
Bruce Momjian [Sun, 7 Feb 1999 02:56:53 +0000 (02:56 +0000)]
Allow psql to do \p\g. Ingres does it, why not us?
Tom Lane [Sun, 7 Feb 1999 00:52:12 +0000 (00:52 +0000)]
Add equality checking for T_Query so that we don't get
complaints in UNION regress test. Probably still need some more node
types to be handled here, but I'm done for the day...
Tom Lane [Sat, 6 Feb 1999 21:51:03 +0000 (21:51 +0000)]
Add floating-point support to our emulation of snprintf
so that EXPLAIN works again.
Tom Lane [Sat, 6 Feb 1999 20:28:11 +0000 (20:28 +0000)]
Fix silly typo causing SELECT INTO TABLE to sometimes be
treated as SELECT INTO TEMP TABLE.
Bruce Momjian [Sat, 6 Feb 1999 17:29:30 +0000 (17:29 +0000)]
Optimizer cleanup.
Jan Wieck [Sat, 6 Feb 1999 16:50:34 +0000 (16:50 +0000)]
New alloc set code using a memory block pool for small allocations.
Jan
Bruce Momjian [Fri, 5 Feb 1999 20:34:11 +0000 (20:34 +0000)]
optimizer cleanup
Bruce Momjian [Fri, 5 Feb 1999 19:59:31 +0000 (19:59 +0000)]
Optimizer cleanup.
Bruce Momjian [Fri, 5 Feb 1999 17:47:29 +0000 (17:47 +0000)]
Fix for returning stack pointer from selectivity, from Bernard Frankpitt.
Bruce Momjian [Fri, 5 Feb 1999 04:25:55 +0000 (04:25 +0000)]
Reverse out const to libpq interface from D'Arcy.
Tom Lane [Fri, 5 Feb 1999 03:43:05 +0000 (03:43 +0000)]
Fix silly typo in prune_joinrel
Bruce Momjian [Thu, 4 Feb 1999 23:19:53 +0000 (23:19 +0000)]
Optimizer cleanups.
Bruce Momjian [Thu, 4 Feb 1999 19:20:12 +0000 (19:20 +0000)]
Update optimizer comments.
Bruce Momjian [Thu, 4 Feb 1999 14:52:00 +0000 (14:52 +0000)]
Large object write-into-middle fix from Tatsuo Ishii.
Marc G. Fournier [Thu, 4 Feb 1999 04:58:05 +0000 (04:58 +0000)]
From: Michael Meskes <Michael.Meskes@usa.net>
+ Tue Feb 2 07:40:52 CET 1999
+
+ - Brought preproc.y in sync again with gram.y.
+ - Set ecpg version to 2.4.9
+
Bruce Momjian [Thu, 4 Feb 1999 03:20:39 +0000 (03:20 +0000)]
Const fixes from D'Arcy.
Bruce Momjian [Thu, 4 Feb 1999 03:19:11 +0000 (03:19 +0000)]
More optimizer cleanups.
Bruce Momjian [Thu, 4 Feb 1999 01:47:02 +0000 (01:47 +0000)]
More optimizer renaming HInfo -> HashInfo.
Bruce Momjian [Wed, 3 Feb 1999 21:18:02 +0000 (21:18 +0000)]
Cleanup of source files where 'return' or 'var =' is alone on a line.
Bruce Momjian [Wed, 3 Feb 1999 20:19:10 +0000 (20:19 +0000)]
The libpq function PQfnumber does not handle case-insensitive
comparisons correctly. The psql monitor converts all table and field
names to lower case. If the PQfnumber function is called with a mixed
case name, it will always return -1.
Bahman Rafatjoo
Bruce Momjian [Wed, 3 Feb 1999 20:15:53 +0000 (20:15 +0000)]
Optimizer rename ClauseInfo -> RestrictInfo. Update optimizer README.
Jan Wieck [Wed, 3 Feb 1999 19:31:24 +0000 (19:31 +0000)]
Sort node for ORDER BY is suppressed if choosen index scan will
allways present tuples in the requested order.
Jan
Tom Lane [Wed, 3 Feb 1999 00:18:53 +0000 (00:18 +0000)]
Modify int8 to not depend on sscanf(), and fix configure's test
for int8 support. configure now checks only snprintf() for int8 support,
not sprintf and sscanf as it used to. The reason for doing this is that
if we are supplying our own snprintf code (which does handle long long int),
we now only need working long long support in the compiler not in the
platform's C library. I have verified that int8 now passes regression test
on HPUX 9, and I think it should work on SunOS 4.1.* and other older
platforms if gcc is used.
Bruce Momjian [Tue, 2 Feb 1999 23:53:26 +0000 (23:53 +0000)]
SET_ARGS cleanup
Bruce Momjian [Tue, 2 Feb 1999 20:30:18 +0000 (20:30 +0000)]
Make GEQO use dependent on table and index count.
Bruce Momjian [Tue, 2 Feb 1999 19:20:54 +0000 (19:20 +0000)]
OK I found it,
I search in the planner for the '\xFF' appending.
Finally I found in MakeIndexable() in gram.y
Attach a patch which removes the "<=" test in USE_LOCALE,
might make some queries a bit slower for us "locale-heads",
BUT correct result is more important.
regards,
--
-----------------
Göran Thyni
Bruce Momjian [Tue, 2 Feb 1999 19:04:43 +0000 (19:04 +0000)]
Add missing mb files.
Bruce Momjian [Tue, 2 Feb 1999 18:51:40 +0000 (18:51 +0000)]
Included patches make some enhancements to the multi-byte support.
o allow to use Big5 (a Chinese encoding used in Taiwan) as a client
encoding. In this case the server side encoding should be EUC_TW
o add EUC_TW and Big5 test cases to the regression and the mb test
(contributed by Jonah Kuo)
o fix mistake in include/mb/pg_wchar.h. An encoding id for EUC_TW was
not correct (was 3 and now is 4)
o update documents (doc/README.mb and README.mb.jp)
o update psql helpfile (bin/psql/psqlHelp.h)
--
Tatsuo Ishii
t-ishii@sra.co.jp
Bruce Momjian [Tue, 2 Feb 1999 18:41:17 +0000 (18:41 +0000)]
psql help fix.
Bruce Momjian [Tue, 2 Feb 1999 18:39:23 +0000 (18:39 +0000)]
Fix for psql help create table.
Bruce Momjian [Tue, 2 Feb 1999 17:46:17 +0000 (17:46 +0000)]
Fix create_rule is->as.
Jan Wieck [Tue, 2 Feb 1999 12:57:51 +0000 (12:57 +0000)]
Fixed failed assertion happening in multiple action rules
when parsestate in makeRangeTable() already contains an
opened p_target_relation.
Jan
Bruce Momjian [Tue, 2 Feb 1999 03:45:56 +0000 (03:45 +0000)]
Add TEMP tables/indexes. Add COPY pfree(). Other cleanups.
Jan Wieck [Mon, 1 Feb 1999 20:25:55 +0000 (20:25 +0000)]
Fixed growing of backend due to not pfree()'d data on COPY FROM
Fixed growing of backend if BEFORE DELETE trigger returns heap tuple
different from trigtuple.
Jan
Vadim B. Mikheev [Mon, 1 Feb 1999 13:33:27 +0000 (13:33 +0000)]
Initialize es_snapshot.
Tom Lane [Mon, 1 Feb 1999 04:20:50 +0000 (04:20 +0000)]
Tighten coding in samekeys(). Pretty braindead change,
but it saves almost 10% of the runtime in Charles Hornberger's optimizer
example, so what the heck ...
Marc G. Fournier [Mon, 1 Feb 1999 02:52:23 +0000 (02:52 +0000)]
freebsd4.0 needed to be added to configure...
Marc G. Fournier [Sun, 31 Jan 1999 19:56:28 +0000 (19:56 +0000)]
From: Michael Meskes <Michael.Meskes@usa.net>
+
+ Wed Jan 27 12:42:22 CET 1999
+
+ - Fixed bug that caused ecpg to lose 'goto' information.
+ - Set ecpg version to 2.4.7
+
+ Fri Jan 29 18:03:52 CET 1999
+
+ - Fixed bug that caused 'enum' to be rejected in pure C code.
+ - Fixed bug that caused function names to be translated to lower case.
+ - Set ecpg version to 2.4.8
+
Marc G. Fournier [Sun, 31 Jan 1999 05:04:25 +0000 (05:04 +0000)]
From: D'Arcy J.M. Cain <darcy@druid.net>
The following patch does two things.
- Clarifies what the effect of allowing users to add new users (Thet
become super-users.)
- Makes the default database for the new user if they are not allowed
to and the user agrees to create it.
Tom Lane [Sat, 30 Jan 1999 20:04:37 +0000 (20:04 +0000)]
Fix postmaster to not try to start more than MaxBackendId children,
per patch from Tatsuo Ishii
Vadim B. Mikheev [Fri, 29 Jan 1999 13:24:36 +0000 (13:24 +0000)]
Small fix for READ COMMITTED isolevel.
Vadim B. Mikheev [Fri, 29 Jan 1999 11:56:01 +0000 (11:56 +0000)]
Hope that execMain.c good merged.
Fix for BEFORE ROW UPDATE triggers: result tuple may be different
(due to concurrent update) from one initially produced by top level plan.
Vadim B. Mikheev [Fri, 29 Jan 1999 10:15:09 +0000 (10:15 +0000)]
Trying to fix bad merging...
Vadim B. Mikheev [Fri, 29 Jan 1999 09:23:17 +0000 (09:23 +0000)]
READ COMMITTED isolevel is implemented and is default now.
Jan Wieck [Thu, 28 Jan 1999 15:28:40 +0000 (15:28 +0000)]
Changed qualification of pg_views and pg_tables to directly
check if a rewrite rule on SELECT exists/not exists instead
of asking pg_get_viewdef() function.
Jan
Jan Wieck [Thu, 28 Jan 1999 11:50:42 +0000 (11:50 +0000)]
New prebuilt versions of gram.c and scan.c for the mixed case
identifier support.
Jan
Jan Wieck [Thu, 28 Jan 1999 11:48:31 +0000 (11:48 +0000)]
Partial support for mixed case in PL/pgSQL.
Left are identifiers that contain non-alnum/_ chars.
So e.g. whitespaces in identifiers are still not
supported.
Jan
Tom Lane [Wed, 27 Jan 1999 16:48:20 +0000 (16:48 +0000)]
Quick fix for subplan-related crash.
Jan Wieck [Wed, 27 Jan 1999 16:15:22 +0000 (16:15 +0000)]
Speedup of PL/pgSQL by calling ExecEvalExpr() directly
instead of SPI_execp() for simple expressions.
Jan
Bruce Momjian [Wed, 27 Jan 1999 16:15:01 +0000 (16:15 +0000)]
fix for aggregates
Marc G. Fournier [Wed, 27 Jan 1999 01:18:23 +0000 (01:18 +0000)]
From: Tatsuo Ishii <t-ishii@sra.co.jp>
Included patches fix a portability problem of unsetenv() used in
6.4.2 multi-byte support. unsetenv() is only avaliable on FreeBSD and
Linux so I decided to replace with putenv().
Tom Lane [Wed, 27 Jan 1999 01:11:43 +0000 (01:11 +0000)]
Turns out it's easy to cache the fmgr function lookup
result, too ... another little bit of speed for SELECT.
Tom Lane [Wed, 27 Jan 1999 00:36:28 +0000 (00:36 +0000)]
Another SELECT speedup: extract OIDs of column print functions
only once per SELECT, not once per tuple. 10% here, 10% there,
pretty soon you're talking about real speedups ...
Bruce Momjian [Tue, 26 Jan 1999 23:32:04 +0000 (23:32 +0000)]
More agg cleanup.
Marc G. Fournier [Tue, 26 Jan 1999 14:38:52 +0000 (14:38 +0000)]
primary key support cleanups from D'Arcy...
Bruce Momjian [Tue, 26 Jan 1999 05:57:14 +0000 (05:57 +0000)]
pgindent file.
Marc G. Fournier [Mon, 25 Jan 1999 21:22:06 +0000 (21:22 +0000)]
From: Peter T Mount <peter@retep.org.uk>
This implements some of the JDBC2 methods, fixes a bug introduced into the
JDBC1 portion of the driver, and introduces a new example, showing how to
use the CORBA ORB thats in Java2 with JDBC.
The Tar file contains the new files, the diff the changes to the others.
CHANGELOG is separate as I forgot to make a .orig ;-)
Bruce Momjian [Mon, 25 Jan 1999 18:02:28 +0000 (18:02 +0000)]
Agg/Aggreg cleanup and datetime.sql patch.
Vadim B. Mikheev [Mon, 25 Jan 1999 12:01:19 +0000 (12:01 +0000)]
SELECT FOR UPDATE is implemented...
Tom Lane [Mon, 25 Jan 1999 00:44:53 +0000 (00:44 +0000)]
Tighten coding of fmgr_isbuiltin() ... managed to speed it up
by about 10% which seems to be good for half a percent or so of a SELECT.
Tom Lane [Sun, 24 Jan 1999 22:53:25 +0000 (22:53 +0000)]
Tighten coding of inner loops in nocachegetattr ...
seems to have improved speed of routine by 5% or so ...
Tom Lane [Sun, 24 Jan 1999 22:50:58 +0000 (22:50 +0000)]
Use heap_attisnull, rather than heap_getattr, for a small
but useful speedup.
Tom Lane [Sun, 24 Jan 1999 05:40:49 +0000 (05:40 +0000)]
Replace typtoout() and gettypelem() with a single routine,
so that fetching an attribute value needs only one SearchSysCacheTuple call
instead of two redundant searches. This speeds up a large SELECT by about
ten percent, and probably will help GROUP BY and SELECT DISTINCT too.
Tom Lane [Sun, 24 Jan 1999 02:47:15 +0000 (02:47 +0000)]
Fix a couple little problems with signed vs. unsigned
characters ...
Bruce Momjian [Sun, 24 Jan 1999 00:28:37 +0000 (00:28 +0000)]
Rename Aggreg to Aggref.
Tom Lane [Sun, 24 Jan 1999 00:12:59 +0000 (00:12 +0000)]
Improper addition of NaN/Infinity recognition to float8in()
was causing it not to detect out-of-range float values, as evidenced by
failure of float8 regression test. I corrected that logic and also
modified expected float8 results to account for new error message
generated for out-of-range inputs.
Bruce Momjian [Sat, 23 Jan 1999 23:28:09 +0000 (23:28 +0000)]
Remove unused Choose node.
Tom Lane [Sat, 23 Jan 1999 22:27:29 +0000 (22:27 +0000)]
Add explicit buffering in backend libpq, to compensate for
buffering lost by not going through stdio anymore for client I/O.
Tom Lane [Sat, 23 Jan 1999 21:36:00 +0000 (21:36 +0000)]
Fix unportable test syntax in regression script.
Bruce Momjian [Fri, 22 Jan 1999 19:35:54 +0000 (19:35 +0000)]
Fix for intersect FOR UPDATE check.
Bruce Momjian [Fri, 22 Jan 1999 18:47:37 +0000 (18:47 +0000)]
Relcache Size fix.
Bruce Momjian [Fri, 22 Jan 1999 16:49:25 +0000 (16:49 +0000)]
Fix for Size sizeof in cache code.