Thread: [Postgres-xc-developers] Refactory for Pool Handle Set command.

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi all,

I found that the set command handled by pool is not decent. Especially, the
memory usage will grows up with the same set.
Here is the patch to refectory and fix the potential problem.

The patch also fix the problem that send multi command in one sql like "set
xxx to xxx; truncate  table xxx" which maybe cause "truncate table xxx" be
executed on datanode multi times.

2014-12-23 22:51 GMT+08:00 Jaimin Pan <jai...@gm...>:

> Hi all,
>
> I found that the set command handled by pool is not decent. Especially,
> the memory usage will grows up with the same set.
> Here is the patch to refectory and fix the potential problem.
>

The patch looks nice to handle session parameters more consistently.
Please let me check the code more closely before commit.

I hope the commit can be applied to all the stable branches.

Best;
---
Koichi Suzuki

2014-12-23 23:51 GMT+09:00 Jaimin Pan <jai...@gm...>:
> Hi all,
>
> I found that the set command handled by pool is not decent. Especially, the
> memory usage will grows up with the same set.
> Here is the patch to refectory and fix the potential problem.
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>