[GENERAL] Can somebody explain what is the meaning for HashAggregate?

2015-09-20 Thread lin
Can somebody explain what does the postgres done for the explain of sql shows HashAggregate( what is the meaning for HashAggregate )? for example: postgres=# explain verbose select oid,relname from pg_class group by oid,relname; QUERY PLAN

Re: [GENERAL] Can somebody explain what is the meaning for HashAggregate?

2015-09-20 Thread Bill Moran
On Sun, 20 Sep 2015 21:56:39 +0800 (CST) lin wrote: > Can somebody explain what does the postgres done for the explain of sql shows > HashAggregate( what is the meaning for HashAggregate )? > for example: > > > postgres=# explain verbose select oid,relname from pg_class

Re: [GENERAL] clone_schema function

2015-09-20 Thread Melvin Davidson
Additional revision to avoid duplicating RI_Constraint triggers. On Fri, Sep 18, 2015 at 4:09 PM, Melvin Davidson wrote: > Revised to add rules after all tables are create to avoid error where > table referenced in rule was not created yet. > > Added copying of column

Re: [GENERAL] Memory for BYTEA returned by C function is not released until connection is dropped

2015-09-20 Thread John Leiseboer
Tom Lane [mailto:t...@sss.pgh.pa.us] writes: > But at any rate, bottom line is that your problem is client-side not > server-side, and no amount of fooling with the function innards will change > it. I wish it were. While monitoring memory on Linux and Windows machines I see that psql memory

[GENERAL] Memory for BYTEA returned by C function is not released until connection is dropped

2015-09-20 Thread John Leiseboer
I have written a number of functions in C that return BYTEA type. I have compiled and run on both Windows and Linux, 32-bit and 64-bit, PostgreSQL versions 9.3 and 9.4. My functions return BYTEA data to the caller. The problem is that memory usage grows until there is no memory left on the

Re: [GENERAL] Memory for BYTEA returned by C function is not released until connection is dropped

2015-09-20 Thread Tom Lane
John Leiseboer writes: > I have written a number of functions in C that return BYTEA type. I have > compiled and run on both Windows and Linux, 32-bit and 64-bit, PostgreSQL > versions 9.3 and 9.4. > My functions return BYTEA data to the caller. The problem is that