Forum OpenACS Q&A: Response to If money grew on trees, which would you choose Oracle or PG?

It definitly can help performance/storage if you periodically add the drop/create index approach to your db maintenance program. The Create Index will grab a lock on the table during operation allowing only reads during duration.  So keep that in mind for when you may schedule this since large tables make take awhile.