we see a lot of alfresco query SUDDENTLY which slow down everything, what is it ?
I use dbeaver to see what kind of activities happening in Alfresco (5.0 ) PostgreSQL (9.3.6) and we see that, when postgreSQL is busy and CPU 100%, this query show up a lot of time:
select node.id as node_id, node.version as node_version, prop.qname_id as qname_id, prop.locale_id as locale_id, prop.list_index as list_index, prop.actual_type_n as actual_type_n, prop.persisted_type_n as persisted_type_n, prop.boolean_value as boolean_value, prop.long_value as long_value, prop.float_value as float_value, prop.double_value as double_value, prop.string_value as string_value, prop.serializable_value as serializable_value
from alf_node node join alf_node_properties prop on (prop.node_id = node.id) WHERE node_id in ( $1 , $2 , $3 , $4 ,
may I know what it is ? and how can we speed that up in postgreSQL? increase the work_mem in postgreSQL 9.3.6 ?