On Sat, 9 Nov 2024 at 23:11, Murthy Nunna wrote:
> I am trying to code bash function and call it from psql. But it is failing.
> How can I get this to work. Creating a separate script instead of a function
> works, but I do not want to do that. I have too many variables to be passed
> back and
Maybe try using full path...
Yahoo Mail: Search, Organize, Conquer
On Sat, Nov 9, 2024 at 12:41 PM, Murthy Nunna wrote:
Hi,
I am trying to code bash function and call it from psql. But it is failing. How
can I get this to work. Creating a separate script instead of a function work
Hi,
I am trying to code bash function and call it from psql. But it is failing. How
can I get this to work. Creating a separate script instead of a function works,
but I do not want to do that. I have too many variables to be passed back and
forth. Any ideas?
#!/bin/bash
psql -d postgres -p 5
Thanks for the advice!
I am planing to set session level!
but before that one more observations noticed i.e One more table has same
issue, which is having similar like hash partitions.
And I scheduled manual analyze for all parent hash tables(thus all stats
will update together).
After this cha
Thanks for correction. At this point I would be trying to modify
plan_cache_mode
for the session which uses the bond variable. alter it so that
plan_cache_mode=force_custom_plan
One hypothesis is that, a bad plan got cached for that SQL pattern.
Obviously, when you run it *manually* you are always
