- 12 Mar, 2005 12 commits
-
-
Tom Lane authored
database's datallowconn and datfrozenxid to the current transaction ID instead of copying the source database's values. This is OK because we assume the source DB contains no normal transaction IDs whatsoever. This keeps VACUUM from immediately starting to complain about unvacuumed databases in the situation where we are more than 2 billion transactions out from the XID stamp of template0. Per discussion with Milen Radev (although his complaint turned out to be due to something else, but the problem is real anyway).
-
Tom Lane authored
who for some reason isn't marked usecreatedb. Per report from Alexander Pravking. Also fix sloppy coding in have_createdb_privilege().
-
Tom Lane authored
can tell whether it is being used as an aggregate or not. This allows such a function to avoid re-pallocing a pass-by-reference transition value; normally it would be unsafe for a function to scribble on an input, but in the aggregate case it's safe to reuse the old transition value. Make int8inc() do this. This gets a useful improvement in the speed of COUNT(*), at least on narrow tables (it seems to be swamped by I/O when the table rows are wide). Per a discussion in early December with Neil Conway. I also fixed int_aggregate.c to check this, thereby turning it into something approaching a supportable technique instead of being a crude hack.
-
Neil Conway authored
-
Neil Conway authored
0.9.7x have EVP_DigestFinal function which which clears all of EVP_MD_CTX. This makes pgcrypto crash in functions which re-use one digest context several times: hmac() and crypt() with md5 algorithm. Following patch fixes it by carring the digest info around EVP_DigestFinal and re-initializing cipher. Marko Kreen.
-
Bruce Momjian authored
-
Bruce Momjian authored
< o Allow COPY FROM ... CSV to interpret newlines and carriage > o -Allow COPY FROM ... CSV to interpret newlines and carriage
-
Bruce Momjian authored
Andrew Dunstan
-
Bruce Momjian authored
* -Add a warning when the free space map is too small
-
Bruce Momjian authored
"max_fsm_relations" for vacuums. Also improve VACUUM VERBOSE final message text. Ron Mayer
-
Bruce Momjian authored
-
Tom Lane authored
elog if the former has trouble writing its file. Code review for Magnus' patch to redirect stderr to syslog on Windows (Bruce's version seems right, but did some minor prettification). Backpatch both changes to 8.0 branch.
-
- 11 Mar, 2005 11 commits
-
-
Bruce Momjian authored
change content (at least not supposed to). Magnus Hagander
-
Bruce Momjian authored
Document use of macros for pg_printf functions. Bump major versions of all interfaces to handle movement of get_progname from libpq to libpgport in 8.0, and probably other libpgport changes in 8.1.
-
Bruce Momjian authored
implementation doesn't export out via libpq and get used by a user application.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
Hashem Masoud
-
Bruce Momjian authored
Robert Treat
-
Bruce Momjian authored
Robert Treat
-
Bruce Momjian authored
-
Neil Conway authored
-
Bruce Momjian authored
> * Fix cross-compiling of time zone database via 'zic'
-
- 10 Mar, 2005 3 commits
-
-
Tom Lane authored
Formerly, if such a clause contained no aggregate functions we mistakenly treated it as equivalent to WHERE. Per spec it must cause the query to be treated as a grouped query of a single group, the same as appearance of aggregate functions would do. Also, the HAVING filter must execute after aggregate function computation even if it itself contains no aggregate functions.
-
Bruce Momjian authored
Vikram Kalsi
-
Neil Conway authored
before we can invoke fork() -- flush stdio buffers, save and restore the profiling timer on Linux with LINUX_PROFILE, and handle BeOS stuff. This patch moves that code into a single function, fork_process(), instead of duplicating it at the various callsites of fork(). This patch doesn't address the EXEC_BACKEND case; there is room for further cleanup there.
-
- 08 Mar, 2005 3 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 07 Mar, 2005 7 commits
-
-
Neil Conway authored
-
Neil Conway authored
-
Bruce Momjian authored
feature for Win32 and bcc.
-
Tom Lane authored
number of palloc calls. This has a salutory impact on plpgsql operations with record variables (which create and destroy tupdescs constantly) and probably helps a bit in some other cases too.
-
Bruce Momjian authored
UNICODE => UTF8 ALT => WIN866 WIN => WIN1251 TCVN => WIN1258 The old codes continue to work.
-
Neil Conway authored
Too much space is allocated for tablespace file path, I guess the directory name used to be "pg_tablespaces" instead of "pg_tblspc" at some point. Heikki Linnakangas
-
Tom Lane authored
by non-default planner parameter settings.
-
- 06 Mar, 2005 1 commit
-
-
Tom Lane authored
on-the-fly, and thereby avoid blowing out memory when the planner has underestimated the hash table size. Hash join will now obey the work_mem limit with some faithfulness. Per my recent proposal (hash aggregate part isn't done yet though).
-
- 05 Mar, 2005 1 commit
-
-
Teodor Sigaev authored
-
- 04 Mar, 2005 1 commit
-
-
Tom Lane authored
the freelist, plus per-buffer spinlocks that protect access to individual shared buffer headers. This requires abandoning a global freelist (since the freelist is a global contention point), which shoots down ARC and 2Q as well as plain LRU management. Adopt a clock sweep algorithm instead. Preliminary results show substantial improvement in multi-backend situations.
-
- 02 Mar, 2005 1 commit
-
-
Bruce Momjian authored
-