Title: Documento senza titolo
I clean all unused data, run VACUUM FULL and run REINDEX
d,_object_perm.
Un my table, now i have:
--
24089952
But the problem is the same.
Thanks
Il 07/10/2011 17:12, Giovanni Mancuso ha scritto
Title: Documento senza titolo
Il 07/10/2011 12:24, Guillaume Cottenceau ha scritto:
Giovanni Mancuso writes:
select count(*) from dm_object_perm;
count
--
38'928'077
(1 row)
[...]
If i run "explain
* from dm_object_perm;" it goes on
for many hours.
If i try to execute a left join: "SELECT dm_object.id FROM dm_object
LEFT JOIN dm_object_perm ON dm_object.id =
dm_object_perm.object_id;" my db is unusable.
how can I fix this?
Thanks
--
