Commit Graph

  • 1c688d1bbe From: "Martin S. Utesch" <utesch@aut.tu-freiberg.de> Subject: Re: [HACKERS] GEQO and views (rules) Marc G. Fournier 1997-04-09 08:31:29 +00:00
  • aaeef4dae8 GNUmakefile.in - remove backend/utils/Gen_fmgrtab.sh on distclean varlena.c - part of Thomas' most recent patch Marc G. Fournier 1997-04-09 08:29:35 +00:00
  • 75e2370cc8 Now we have #define _CPU_INDEX_PAGE_WEIGHT_ 0.033 (/* CPU-index-to-page cost weighting factor */) in addition to #define _CPU_PAGE_WEIGHT_ 0.065 (/* CPU-heap-to-page cost weighting factor */). Vadim B. Mikheev 1997-04-09 02:24:19 +00:00
  • 2fd9273d97 getattnvals(): if attnvals in pg_attribute is 0 then use ATTNVALS_SCALE/reltuples (instead of reltuples). Vadim B. Mikheev 1997-04-09 02:20:32 +00:00
  • 610d0d00ed 1. Enable to have different _CPU_PAGE_WEIGHT_ for heap and index. 2. PageWeights are variables now. 3. Fixed using ceil((double)selec*indextuples) as estimation for expected heap pages: ceil((double)selec*relpages) now. Vadim B. Mikheev 1997-04-09 02:13:41 +00:00
  • fa2629b7ea Fix (hack) IndexSelectivity(): use sum(npages)/((nkeys == 1) ? 1 : nkeys + 1) as expected index page estimation for multi-key quals - instead of sum(npages). In old code npages for x > 10 and x < 20 is twice as for x > 10 - cool ? Vadim B. Mikheev 1997-04-09 01:52:04 +00:00
  • b30aa6ecb8 Slight mods to explain (or try to) the new regression tests Marc G. Fournier 1997-04-08 19:34:58 +00:00
  • c56b20eee9 Fix btabstimecmp (). Vadim B. Mikheev 1997-04-07 06:45:41 +00:00
  • ee0a61ab62 Get rid of queries.source...its all in the sql directory. Marc G. Fournier 1997-04-06 08:53:34 +00:00
  • e31cb4be3a More splits and cleanups... Marc G. Fournier 1997-04-06 08:29:57 +00:00
  • 588ae64c44 More splits and cleanups... Marc G. Fournier 1997-04-06 06:07:13 +00:00
  • 063190a5fa Add in support so that build will at least guess which template file should be used :) Marc G. Fournier 1997-04-06 04:43:28 +00:00
  • 23733026ee remove create.{source,sql} as they are now down in the 'sql' directory partially split Marc G. Fournier 1997-04-05 21:33:26 +00:00
  • 1452327c66 Change Postgres95 to PostgreSQL Marc G. Fournier 1997-04-05 21:28:46 +00:00
  • 9c9e2dd4b5 More splits of the regression tests in order to make them more user-friendly (and more useful) Marc G. Fournier 1997-04-05 21:26:00 +00:00
  • aa51d0d185 Purge out tests/expected that are now in sql/expected subdirectories from 'master' file Marc G. Fournier 1997-04-05 11:58:40 +00:00
  • 04688df668 Again, add more tests Marc G. Fournier 1997-04-05 11:26:55 +00:00
  • 7956e606d6 Add more expected.out results Marc G. Fournier 1997-04-05 11:24:54 +00:00
  • d108a31082 There are the broken out 'sql' queries from queries.source Marc G. Fournier 1997-04-05 11:08:30 +00:00
  • 9607e69c24 These are the broken down 'expected.output' files created so far Marc G. Fournier 1997-04-05 11:06:04 +00:00
  • 0762deacec Print 'Group' as name of Group plan. Vadim B. Mikheev 1997-04-05 06:42:32 +00:00
  • d12e27a5f3 Changes for GROUP BY func_results: AddGroupAttrToTlist() is not called from anywhere now. Vadim B. Mikheev 1997-04-05 06:39:58 +00:00
  • c50d8474d3 Changes for GROUP BY func_results. Vadim B. Mikheev 1997-04-05 06:37:37 +00:00
  • cc11cfdd46 Now we can GROUP BY func_results. Vadim B. Mikheev 1997-04-05 06:29:03 +00:00
  • 803a2b13f2 Fix for 'SET var_name TO var_value': var_name already defined. Vadim B. Mikheev 1997-04-05 06:25:59 +00:00
  • bd511f268a Put resdom into GroupClause (GROUP BY func_results) Vadim B. Mikheev 1997-04-05 06:19:22 +00:00
  • 50faf40903 Check for attributeList is NULL in ConstructTupleDescriptor (). Vadim B. Mikheev 1997-04-05 03:36:21 +00:00
  • 3ded1cc530 From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] Fix for European dates Marc G. Fournier 1997-04-05 02:51:41 +00:00
  • eda9d69d6c Move YACC and YFLAGS into the template files Marc G. Fournier 1997-04-04 11:23:15 +00:00
  • c7b40e6058 This commit represents a clean compile with the new templates under FreeBSD Marc G. Fournier 1997-04-04 10:43:16 +00:00
  • e292a9d627 Got AROPT setting backwards...correct it Marc G. Fournier 1997-04-04 09:02:34 +00:00
  • bfbe25c395 Add distclean to target listing Marc G. Fournier 1997-04-04 09:01:19 +00:00
  • d2892913eb Again, needs float.h Marc G. Fournier 1997-04-04 08:55:29 +00:00
  • 18518c0147 needs float.h for DBL_MIN under FreeBSD Marc G. Fournier 1997-04-04 08:53:08 +00:00
  • 50db09185d Remove some files that were inadvertantly created Clean up format of linux-elf Marc G. Fournier 1997-04-04 08:16:37 +00:00
  • f2eb14ad0d One helluva mess. Marc G. Fournier 1997-04-04 07:59:48 +00:00
  • 82a27f230a Install os.h when we install the other headers... Marc G. Fournier 1997-04-04 02:53:14 +00:00
  • 0213a81dca More modifications to make building more interactive: Marc G. Fournier 1997-04-03 22:16:34 +00:00
  • a03dc60508 Remove code associated with !ACLGROUP_PATCH, and appropriate #ifdef's Marc G. Fournier 1997-04-03 21:31:57 +00:00
  • e3649e9e52 Various improvements to reduce questions :) Marc G. Fournier 1997-04-03 21:26:36 +00:00
  • 4bc578eb83 From: "D'Arcy J.M. Cain" <darcy@druid.net> Subject: [HACKERS] timestamp.c changes Marc G. Fournier 1997-04-03 19:58:11 +00:00
  • 9d5c0af586 From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] Aggregate function patches Marc G. Fournier 1997-04-03 19:56:47 +00:00
  • 164cd7ab34 removed as already installed as part of system headers on NetBSD/FreeBSD Marc G. Fournier 1997-04-02 18:49:24 +00:00
  • 2ab34dfe1a From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] More date time functions Marc G. Fournier 1997-04-02 18:36:24 +00:00
  • 920c58df71 From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at> Subject: [HACKERS] libpq variable set patch Marc G. Fournier 1997-04-02 18:26:25 +00:00
  • a51df14a69 From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at> Subject: [HACKERS] Patch: SET var TO 'val' Marc G. Fournier 1997-04-02 18:24:52 +00:00
  • 17b5bd33e4 From: Anton de Wet <adw@obsidian.co.za> Subject: [HACKERS] Small patch to pgtclCmds.c Marc G. Fournier 1997-04-02 18:16:49 +00:00
  • 5b1311acfb From: Oleg Bartunov <oleg@sai.msu.su> Subject: [HACKERS] locale patches ! Marc G. Fournier 1997-04-02 18:13:47 +00:00
  • a10a951a46 New keyword: SEQUENCE. Vadim B. Mikheev 1997-04-02 04:49:13 +00:00
  • b5ee45e16d Manuals for SEQUENCEs. Vadim B. Mikheev 1997-04-02 04:20:00 +00:00
  • 2b788e0bf5 \h create/drop sequence. Vadim B. Mikheev 1997-04-02 04:18:26 +00:00
  • b259e454e7 Dumping sequence relations as 'CREATE SEQUENCE ...'. Vadim B. Mikheev 1997-04-02 04:17:27 +00:00
  • a15158bb55 Call DefineSequence () for T_CreateSeqStmt node. Vadim B. Mikheev 1997-04-02 04:06:32 +00:00
  • 41aeed4334 Can't INSERT/UPDATE/DELETE sequence relation. Vadim B. Mikheev 1997-04-02 04:04:11 +00:00
  • 9729f6ca0d CREATE/DROP SEQUENCE ... Check nextval/currval permission in analyze.c. Vadim B. Mikheev 1997-04-02 04:01:03 +00:00
  • e276d8a1a6 Can't COPY TO sequence relation. Can't inherits from ... Vadim B. Mikheev 1997-04-02 03:57:06 +00:00
  • e8647c45d6 Sequence numbers generators code. Vadim B. Mikheev 1997-04-02 03:51:23 +00:00
  • 1a3c7371e8 vc_getrels(p, VacRelP) returns NIL for special relations (indices, sequences,...) and vc_delhilowstats(NULL->vrl_relid) ... Vadim B. Mikheev 1997-04-02 03:48:01 +00:00
  • 2030cbdf6c Hack for heap_creat to enable relkind to be 'S' for sequences. Vadim B. Mikheev 1997-04-02 03:41:16 +00:00
  • 076f7286be CloseSequences () at xact commit/abort. Vadim B. Mikheev 1997-04-02 03:38:02 +00:00
  • 6ec8d375f5 New node T_CreateSeqStmt. Vadim B. Mikheev 1997-04-02 03:34:46 +00:00
  • 46d11f314f New relkind ('S') for sequence relations. New funcs (nextval & currval) in pg_proc.h Vadim B. Mikheev 1997-04-02 03:29:37 +00:00
  • 4d8e84155e Prototypes for sequence.c Vadim B. Mikheev 1997-04-02 03:23:38 +00:00
  • 80b618520e Use $(CC), not gcc, to compile Marc G. Fournier 1997-04-02 00:34:23 +00:00
  • 986bfc5053 Misc port related issues Marc G. Fournier 1997-04-01 09:27:11 +00:00
  • 4bd4ecf498 Slight Linux related bug pointed out by Gabriel Akos <gabriel@rocker.sch.bme.hu> Marc G. Fournier 1997-03-28 09:43:53 +00:00
  • 632a707fd1 From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] Small date patches (resubmitted) Marc G. Fournier 1997-03-28 07:18:06 +00:00
  • 28454c216b From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: Re: [HACKERS] abstime "now" broken Marc G. Fournier 1997-03-28 07:13:21 +00:00
  • 159f8c63ad From: Dan McGuirk <mcguirk@indirect.com> Reply-To: hackers@hub.org, Dan McGuirk <mcguirk@indirect.com> To: hackers@hub.org Subject: [HACKERS] tmin writeback optimization Marc G. Fournier 1997-03-28 07:06:53 +00:00
  • d98f72e22f From: "D'Arcy J.M. Cain" <darcy@druid.net> Marc G. Fournier 1997-03-28 06:55:58 +00:00
  • 038e56c4df From: "D'Arcy J.M. Cain" <darcy@druid.net> Marc G. Fournier 1997-03-28 06:54:51 +00:00
  • 70a0237bed On some systems limits.h is needed to define DBL_MIN. Marc G. Fournier 1997-03-28 06:53:50 +00:00
  • b9fda39de3 Added call to heap_endscan in IndexIsUniqueNoCache - to release our READ lock on pg_index and let others to create indices too ! Vadim B. Mikheev 1997-03-27 04:13:44 +00:00
  • dd07f76658 turn GEQO code on by default Marc G. Fournier 1997-03-27 01:00:41 +00:00
  • e3e725a47d Remove customize in favor of 'build' Marc G. Fournier 1997-03-26 07:10:03 +00:00
  • 17c4321411 Add ability to change installation directory in build, prior to configure Marc G. Fournier 1997-03-26 06:54:01 +00:00
  • 7cbe19384f Add string.h for strerror() prototype Marc G. Fournier 1997-03-26 03:27:04 +00:00
  • 5b63c6b63a include float.h *after* postgres.h :( Marc G. Fournier 1997-03-26 03:14:37 +00:00
  • 3be7ecb2e4 Disallow to create multi-column indices using non-btree. Vadim B. Mikheev 1997-03-26 03:05:28 +00:00
  • d6b2f41c07 need float.h under FreeBSD for DBL_MIN Marc G. Fournier 1997-03-26 03:02:15 +00:00
  • 87bc5db412 '\h create index' shows that multi-column indices are available now. Vadim B. Mikheev 1997-03-26 03:01:29 +00:00
  • 7d336625c0 Added syntax for multi-column indices. Vadim B. Mikheev 1997-03-26 02:52:49 +00:00
  • 14ed5b3ecd Someone forgot about 'case sizeof(int32)' for tupleDesc->attrs[i]->attlen in fastgetiattr. Vadim B. Mikheev 1997-03-26 02:24:38 +00:00
  • 64c82a5016 Add checs for float.h Marc G. Fournier 1997-03-25 20:02:42 +00:00
  • 719a413fd2 Add float.h for DBL_{MIN,MAX} under FreeBSD Marc G. Fournier 1997-03-25 20:00:52 +00:00
  • 0ccaaac169 another one missed Marc G. Fournier 1997-03-25 09:44:33 +00:00
  • 884d70edf0 MIssed adding a file to the repository Marc G. Fournier 1997-03-25 09:44:00 +00:00
  • 070381482f From: "D'Arcy J.M. Cain" <darcy@druid.net> Subject: [HACKERS] backend/utils/adt/timestamp.c Marc G. Fournier 1997-03-25 09:25:33 +00:00
  • c2e73db87a Various patches for shared libraries under i386-solaris by: Marc G. Fournier 1997-03-25 09:21:59 +00:00
  • 6304e2c273 Here's two more diffs... Marc G. Fournier 1997-03-25 09:08:06 +00:00
  • ea2fa32eff Rather than make this a Linux test, we should just test for the existence of endian.h. I figure that if it exists it's pretty sure that it has the byte order information and we may catch some other ports without any further testing. Marc G. Fournier 1997-03-25 08:25:47 +00:00
  • fcd65952fd Use $(LD_ADD) from Makefile.global instead of $(LDADD), which doesn't exist... Marc G. Fournier 1997-03-25 08:14:25 +00:00
  • dfe0475362 From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> Subject: [HACKERS] More patches for date/time Marc G. Fournier 1997-03-25 08:11:24 +00:00
  • d2a386d6e3 MOre univel port patches/files from: Marc G. Fournier 1997-03-25 07:54:53 +00:00
  • 52ab6525fb Start of a univel port by "Michael P. Snyder" <msnyder@hawkeye.huntersmoon.com> Marc G. Fournier 1997-03-25 07:16:36 +00:00
  • 1a63f48b28 Free memory allocated by command in the BlankPortal' HeapMemory context (#ifdef-ed). Vadim B. Mikheev 1997-03-25 04:10:21 +00:00
  • ef56e51cd3 - Renamed the variable names to something shorter, and I hope nicer. Also, I grabbed my copy of the Informix manual, and added a couple of variables that make sense (formats for money, time, a language setting, a timezone). Marc G. Fournier 1997-03-25 02:37:21 +00:00
  • e16b43e2dc Add in alpha port Marc G. Fournier 1997-03-25 02:29:08 +00:00
  • 424e43326b I don't know whether this breaks what the previous person tried to fix, but figure I"ll know soon enough, eh? Marc G. Fournier 1997-03-25 00:54:15 +00:00
  • 7fae43654b Needs USE_POSIX_SIGNALS Marc G. Fournier 1997-03-25 00:52:12 +00:00