[COMMITTERS] veil - veil: Updates for version 9.1.12 release, to work with Postgres

2010-11-19 Thread User Bloodnok
Log Message: --- Updates for version 9.1.12 release, to work with Postgres 9.0 Modified Files: -- veil: Makefile.global.in (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/veil/veil/Makefile.global.in?r1=1.6&r2=1.7) veil/config: acx_l

[COMMITTERS] pgsql: Improve relation width estimation for subqueries.

2010-11-19 Thread Tom Lane
Improve relation width estimation for subqueries. As per the ancient comment for set_rel_width, it really wasn't much good for relations that aren't plain tables: it would never find any stats and would always fall back on datatype-based estimates, which are often pretty silly. Fix that by copyin

[COMMITTERS] psqlodbc - psqlodbc: Divide SC_returns_rows() macro into several

2010-11-19 Thread User Hinoue
Log Message: --- Divide SC_returns_rows() macro into several categories and make SQLResultNumCols(), SQLDescribeCol() or SQLColAttribute() available for insert/update/delete .. returning statements. Modified Files: -- psqlodbc: convert.c (r1.192 -> r1.193)

[COMMITTERS] psqlodbc - psqlodbc: Initialize flags member in QResultClass before

2010-11-19 Thread User Hinoue
Log Message: --- Initialize flags member in QResultClass before calling QR_set_rowstart_in_cache() per report from Arno Moore. Modified Files: -- psqlodbc: qresult.c (r1.78 -> r1.79) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/qresult.c?

[COMMITTERS] pgsql: Speed up conversion of signed integers to C strings.

2010-11-19 Thread Robert Haas
Speed up conversion of signed integers to C strings. A hand-coded implementation turns out to be much faster than calling printf(). In passing, add a few more regresion tests. Andres Freund, with assorted, mostly cosmetic changes. Branch -- master Details --- http://git.postgresql.org/

[COMMITTERS] pgsql: Fix leakage of cost_limit when multiple autovacuum workers are a

2010-11-19 Thread Tom Lane
Fix leakage of cost_limit when multiple autovacuum workers are active. When using default autovacuum_vac_cost_limit, autovac_balance_cost relied on VacuumCostLimit to contain the correct global value ... but after the first time through in a particular worker process, it didn't, because we'd trash

[COMMITTERS] pgsql: Fix leakage of cost_limit when multiple autovacuum workers are a

2010-11-19 Thread Tom Lane
Fix leakage of cost_limit when multiple autovacuum workers are active. When using default autovacuum_vac_cost_limit, autovac_balance_cost relied on VacuumCostLimit to contain the correct global value ... but after the first time through in a particular worker process, it didn't, because we'd trash

[COMMITTERS] pgsql: Fix leakage of cost_limit when multiple autovacuum workers are a

2010-11-19 Thread Tom Lane
Fix leakage of cost_limit when multiple autovacuum workers are active. When using default autovacuum_vac_cost_limit, autovac_balance_cost relied on VacuumCostLimit to contain the correct global value ... but after the first time through in a particular worker process, it didn't, because we'd trash

[COMMITTERS] pgsql: Fix leakage of cost_limit when multiple autovacuum workers are a

2010-11-19 Thread Tom Lane
Fix leakage of cost_limit when multiple autovacuum workers are active. When using default autovacuum_vac_cost_limit, autovac_balance_cost relied on VacuumCostLimit to contain the correct global value ... but after the first time through in a particular worker process, it didn't, because we'd trash

Re: [COMMITTERS] pgsql: Speed up conversion of signed integers to C strings.

2010-11-19 Thread Tom Lane
Robert Haas writes: > Speed up conversion of signed integers to C strings. This patch breaks the build here: gcc -O1 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -g -I../../../../src/include -D_XOPEN_SOURCE_EXTENDED -c -o numutils.o numutils.c numutils.c: In function `pg_lt

Re: [COMMITTERS] pgsql: Speed up conversion of signed integers to C strings.

2010-11-19 Thread Tom Lane
I wrote: > Robert Haas writes: >> Speed up conversion of signed integers to C strings. > This patch breaks the build here: ... and while I'm looking at it, the added int8 regression test cases definitely merit a WTF. They aren't testing what I would expect. What they are testing is platform-spe

[COMMITTERS] pgsql: Attempt to fix breakage caused by signed integer conversion patc

2010-11-19 Thread Robert Haas
Attempt to fix breakage caused by signed integer conversion patch. Use INT_MIN rather than INT32_MIN as we do elsewhere in the code, and try to work around nonexistence of INT64_MIN if necessary. Adjust the new regression tests to something hopefully saner, per observation by Tom Lane. Branch --

Re: [COMMITTERS] pgsql: Speed up conversion of signed integers to C strings.

2010-11-19 Thread Robert Haas
On Fri, Nov 19, 2010 at 11:47 PM, Tom Lane wrote: > I wrote: >> Robert Haas writes: >>> Speed up conversion of signed integers to C strings. > >> This patch breaks the build here: > > ... and while I'm looking at it, the added int8 regression test cases > definitely merit a WTF.  They aren't test