[OGo-Users] Speed after Backup-Recovery

[Helge Hess]

On 30.06.2007, at 17:24, Christian Naumer wrote:
> users@opengroupware.org wrote:
>> As mentioned before you should also check that the obj_info table is
>> properly filled (pg-fill-objinfo.psql SQL script).
> The table has 4200 rows. Is that reasonable?

No. My test DB with ~10.000 contacts has:
OGo=> SELECT COUNT(*) FROM obj_info;
---snip---
count
--------
100538
(1 row)
---snap---


>> I think this table is used by object::get-by-globalid (the 52s  
>> thing).
> Where do I find the script?

http://svn.opengroupware.org/viewcvs/trunk/Database/PostgreSQL/pg- 
fill-objinfo.psql?rev=1222&view=auto

Helge
-- 
Helge Hess
http://www.helgehess.eu/