topic Re: we see a lot of alfresco query SUDDENTLY which slow down everything, what is it ? in Alfresco Forum

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

dba100 — Tue, 07 Dec 2021 04:27:01 GMT

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 ?

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

angelborroy — Mon, 13 Dec 2021 09:22:06 GMT

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

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

dba100 — Tue, 14 Dec 2021 09:11:25 GMT

hi,

tks.

where it from ? percona ?

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

dba100 — Mon, 20 Dec 2021 06:18:34 GMT

I am sorry, what are you saying ?