Re: [PERFORM] Database performance post-VACUUM FULL

2009-10-01 Thread Kevin Grittner
Karl Wright wrote: > when database maintenance takes place (which consists of a VACUUM > FULL operation, and some table REINDEX operations) Besides providing the information requested by Robert, can you explain why you chose to use VACUUM FULL? The FULL option is only really useful in a small

Re: [PERFORM] Database performance post-VACUUM FULL

2009-09-18 Thread Robert Haas
On Fri, Sep 18, 2009 at 8:44 AM, Karl Wright wrote: > Hi all, > > We're using Postgresql 8.3.7 on Debian.  We are seeing a very strange > performance situation with our application which I am hoping that someone > can shed light on. > > Our tests find that our application runs quite well on 8.3.7

[PERFORM] Database performance post-VACUUM FULL

2009-09-18 Thread Karl Wright
Hi all, We're using Postgresql 8.3.7 on Debian. We are seeing a very strange performance situation with our application which I am 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 followed by