Forum OpenACS Development: Re: acs_object__new slowness...

Collapse
Posted by Jeff Davis on
I bumped shared_buffers up to 256mb timed it w/o the index (.56ms first time, .26ms once things were cached), recreated the index and timed it again 1st time through 1198ms, 5th time through 1149ms so no probably not caching.

I dropped the index and the query was back to .38ms.

I vote do away with the index.