Dear,
I'm trying to interpret an Explain Analyze, but I did not understand this:
-> According to the Postgresql documentation at: https://www.postgresql.org/
docs/9.6/static/using-explain.html
" the loops value reports the total number of executions of the node, and
the actual time and rows
Hi Mariel,
On 9/7/2017 7:02 AM, Mariel Cherkassky wrote:
I'm pretty sure that the source tables are changing during the loop. I
have no problem showing the query :
SELECT AREA,
PHONE,
TERM_CODE,
LINE_NO,
PAYMENT_START_DATE,
Hello
Trying to setup table partitioning I noticed strange behavior that prevents
me from using it.
I set up master and child tables via inheritance, with range CHECK by date
and with
trigger on 'insert', as described in the documentation.
I was happy with insertion speed, it was about 30
