Re: [COMMITTERS] pgsql: Improve Range Types and Exclusion Constraints example.

2013-09-05 Thread Magnus Hagander
Backpatch to 9.3 at least, maybe? Without that, it's not going to show
up in "production docs" for a year...

//Magnus


On Thu, Sep 5, 2013 at 8:30 AM, Jeff Davis  wrote:
> Improve Range Types and Exclusion Constraints example.
>
> Make the examples self-contained to avoid confusion. Per bug report
> 8367 from KOIZUMI Satoru.
>
> Branch
> --
> master
>
> Details
> ---
> http://git.postgresql.org/pg/commitdiff/be6fcb671e4291654391fba475f4b555d2da74f3
>
> Modified Files
> --
> doc/src/sgml/rangetypes.sgml |   18 +++---
> 1 file changed, 11 insertions(+), 7 deletions(-)
>
>
> --
> Sent via pgsql-committers mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-committers



-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Improve Range Types and Exclusion Constraints example.

2013-09-05 Thread Jeff Davis
Improve Range Types and Exclusion Constraints example.

Make the examples self-contained to avoid confusion. Per bug report
8367 from KOIZUMI Satoru.

Branch
--
REL9_3_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/fb843b2679d959a63f48c2f4ad52243053e1a5d4

Modified Files
--
doc/src/sgml/rangetypes.sgml |   18 +++---
1 file changed, 11 insertions(+), 7 deletions(-)


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Improve Range Types and Exclusion Constraints example.

2013-09-05 Thread Jeff Davis
Improve Range Types and Exclusion Constraints example.

Make the examples self-contained to avoid confusion. Per bug report
8367 from KOIZUMI Satoru.

Branch
--
REL9_2_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/1bb4b62d3e5209dae1f1e441b7f01a053b7587f4

Modified Files
--
doc/src/sgml/rangetypes.sgml |   18 +++---
1 file changed, 11 insertions(+), 7 deletions(-)


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Make catalog cache hash tables resizeable.

2013-09-05 Thread Heikki Linnakangas
Make catalog cache hash tables resizeable.

If the hash table backing a catalog cache becomes too full (fillfactor > 2),
enlarge it. A new buckets array, double the size of the old, is allocated,
and all entries in the old hash are moved to the right bucket in the new
hash.

This has two benefits. First, cache lookups don't get so expensive when
there are lots of entries in a cache, like if you access hundreds of
thousands of tables. Second, we can make the (initial) sizes of the caches
much smaller, which saves memory.

This patch dials down the initial sizes of the catcaches. The new sizes are
chosen so that a backend that only runs a few basic queries still won't need
to enlarge any of them.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/20cb18db4668b016748fbb5fcb1422bc3e0d52d1

Modified Files
--
src/backend/utils/cache/catcache.c |   52 --
src/backend/utils/cache/syscache.c |  104 ++--
src/include/utils/catcache.h   |4 +-
3 files changed, 102 insertions(+), 58 deletions(-)


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Eliminate pg_rewrite.ev_attr column and related dead code.

2013-09-05 Thread Kevin Grittner
Eliminate pg_rewrite.ev_attr column and related dead code.

Commit 95ef6a344821655ce4d0a74999ac49dd6af6d342 removed the
ability to create rules on an individual column as of 7.3, but
left some residual code which has since been useless.  This cleans
up that dead code without any change in behavior other than
dropping the useless column from the catalog.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/277607d600fb71e25082b94302ca1716403cd0bc

Modified Files
--
doc/src/sgml/catalogs.sgml   |8 -
src/backend/rewrite/rewriteDefine.c  |6 
src/backend/rewrite/rewriteHandler.c |   17 +
src/backend/rewrite/rewriteManip.c   |   64 --
src/backend/utils/adt/ruleutils.c|   16 +
src/backend/utils/cache/relcache.c   |3 --
src/include/catalog/catversion.h |2 +-
src/include/catalog/pg_rewrite.h |   14 
src/include/rewrite/prs2lock.h   |1 -
src/include/rewrite/rewriteManip.h   |2 --
src/tools/pgindent/typedefs.list |1 -
11 files changed, 9 insertions(+), 125 deletions(-)


-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers