Forum OpenACS Development: Re: Compatibility Matrix

Collapse
27: Re: Compatibility Matrix (response to 26)
Posted by Dave Bauer on 08/02/12 05:48 PM
I checked and I did update shared buffers to 128mb in my PG 9.1 config.
Collapse
28: Bugtrack updating many object permissions (response to 27)
Posted by Dave Bauer on 08/02/12 05:54 PM
Very interesting results.

If you try to change the access policy on a bugtracker instance it calls set_inherit and grant_permission on every bug.

This can be hundreds of objects. The first ones took 1-2 seconds per query as the page runs by the end the last objects take 1 ms.

It appears Postgresql is loading the tables/indexes into memory and as that happens to seems to help.

Maybe this is not a signifigant issue unless you try to issue hundreds of small queries in one submission.