On 09/19/2017 02:49 AM, 園田祥平 wrote:
> Hi experts,
>
> For an academic experiment I need to *restrict the total amount of
> memory that is available for a pgSQL server* to compute a given set of
> queries.
>
> I know that I can do this through |postgressql.conf|file, where I can
> adjust some pa
I have a complicated query which runs the exact same subplan more than once.
Here is a greatly simplified (and rather pointless) query to replicate the
issue:
select aid, sum_bid from
(select
aid,
(select sum(bid) from pgbench_branches
where bbalance between -1
Hi All,
I didn't understand why same sub plan for the sub query executed two times?
As per the query it should have been executed only once.
Can someone please explain this behaviour of query execution ?
Thanks a lot.
On Wed, 20 Sep 2017 at 5:01 AM, Jeff Janes wrote:
> I have a complicated qu