Database performance post-VACUUM FULL

Hi all,

We're using Postgresql 8.3.7 on Debian.  We are seeing a very strange performance situation with our application which
Iam  
hoping that someone can shed light on.

Our tests find that our application runs quite well on 8.3.7 initially.  The test consists of database creation
followedby 30  
cycles of creation and removal of approximately 1,000,000 rows (across all tables) per cycle.  However, when database
maintenance takes place (which consists of a VACUUM FULL operation, and some table REINDEX operations), subsequent
cycle 
performance is more than 2x worse.  What's more, after one VACUUM FULL operation has been done on the database, no
subsequent 
VACUUM FULL operations *ever* seem to restore it to proper performance levels.

We used the same general maintenance procedure with 8.2 and found that it worked as expected, so we were quite
surprisedto  
discover this problem with 8.3.7.  Anybody know what's going on?

Thanks,
Karl

--
Karl Wright
Software Engineer

MetaCarta, Inc.
350 Massachusetts Avenue, 4th Floor, Cambridge, MA 02139 USA

(617)-301-5511

www.metacarta.com <http://www.metacarta.com>
Where to find it.

This message may contain privileged, proprietary, and otherwise private
information. If you are not the intended recipient, please notify the
sender immediately.