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
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
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
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
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
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