[OGo-Users] Speed after Backup-Recovery

[Christian Naumer]

users@opengroupware.org wrote: 
> 
> The problem is *NOT* in OpenGroupware, but in your database.
Thought as much..

> 
> **** Did you restore your settings to postgresql.conf after the database
> restore? ****
I didnt do any optimizations. I am just reading the ones you have in the Admin
guide but it was the same file before the backup.
Here are my results for the queries:

Unique  (cost=115.60..115.79 rows=38 width=4) (actual time=9.987..10.012 rows=2
loops=1)

  ->  Sort  (cost=115.60..115.70 rows=38 width=4) (actual time=9.977..9.986
rows=2 loops=1)

        Sort Key: company_id

        ->  Seq Scan on person t1  (cost=0.00..114.60 rows=38 width=4) (actual
time=0.383..9.828 rows=2 loops=1)

              Filter: (((lower((login)::text) ~~ '%naumer%'::text) OR
(lower((firstname)::text) ~~ '%naumer%'::text) OR (lower((description)::text) ~~
'%naumer%'::text) OR (lower((name)::text) ~~ '%naumer%'::text)) AND
((db_status)::text <> 'archived'::text) AND ((is_template_user IS NULL) OR
(is_template_user = 0)))

Total runtime: 10.158 ms


ndex Scan using obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx, obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx, obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx, obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx, obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx, obj_acl_object_id_idx, obj_acl_object_id_idx,
obj_acl_object_id_idx on object_acl t1  (cost=0.00..167.19 rows=37 width=24)
(actual time=0.408..0.437 rows=2 loops=1)

  Index Cond: (((object_id)::text = '0'::text) OR ((object_id)::text =
'497336'::text) OR ((object_id)::text = '497478'::text) OR ((object_id)::text =
'497630'::text) OR ((object_id)::text = '497650'::text) OR ((object_id)::text =
'497670'::text) OR ((object_id)::text = '497690'::text) OR ((object_id)::text =
'497770'::text) OR ((object_id)::text = '497810'::text) OR ((object_id)::text =
'498120'::text) OR ((object_id)::text = '498610'::text) OR ((object_id)::text =
'498650'::text) OR ((object_id)::text = '498666'::text) OR ((object_id)::text =
'499157'::text) OR ((object_id)::text = '499220'::text) OR ((object_id)::text =
'499260'::text) OR ((object_id)::text = '499370'::text) OR ((object_id)::text =
'499490'::text))

Total runtime: 0.603 ms

-- 
Dr. Christian Naumer
Scientist Molecular Biology

B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail cn@brain-biotech.de, homepage www.brain-biotech.de
fon +49-6251-9331-30  /   fax +49-6251-9331-11

Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Dr. Holger Zinke (Vorsitz), Dr. Jrgen Eck
Vorsitzender des Aufsichtsrats: Ulrich Putsch