MironAtHome commented on issue #1974: URL: https://github.com/apache/age/issues/1974#issuecomment-2222673007
Ok, looks like experiment hints that `SET LOCAL parallel_leader_participation = off;` is the better performing option. One thing that isn't 100% clear to me is the bi-directional query design. May I ask you to run queries like this, and if both produce identical results, than we can further tune query by using directional attribute in the MATCH, else, what improvement is available seems reasonable. However, it needs to be confirmed ( only on test instance of the server ). I am not sure how to clean - up buffers ont he running server. On my servers I am allowed to perform any administrative action, so, I would just restart. But please see if this is something doable where you are. Usually RDBMS has commands to clean up memory buffers to run query "anew", as if it was never run before. Once performance gains confirmed, it counts. Give me just a moment to write queries, I will update same comment. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
