we see a lot of alfresco query SUDDENTLY which slow down everything, what is it ?

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

dba100

hi,

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 ?

angelborroy

You may try using some tool like pg_tune to improve the performance of your DB queries.