12-06-2021 08:27 PM
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 ?
12-13-2021 01:22 AM
You may try using some tool like pg_tune to improve the performance of your DB queries.
12-14-2021 01:11 AM
hi,
tks.
where it from ? percona ?
12-19-2021 10:18 PM
I am sorry, what are you saying ?
Explore our Alfresco products with the links below. Use labels to filter content by product module.