Skip site navigation (1) Skip section navigation (2)

Re: Do we need vacuuming when tables are regularly dropped?

From: "Peter Kovacs" <maxottovonstirlitz(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Do we need vacuuming when tables are regularly dropped?
Date: 2008-09-29 09:50:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
PGSQL version is: 8.2.7. (BTW, which catalog view contains the
back-end version number?)

On Mon, Sep 29, 2008 at 11:37 AM, Peter Kovacs
<maxottovonstirlitz(at)gmail(dot)com> wrote:
> Hi,
> We have a number of automated performance tests (to test our own code)
> involving PostgreSQL. Test cases are supposed to drop and recreate
> tables each time they run.
> The problem is that some of the tests show a linear performance
> degradation overtime. (We have data for three months back in the
> past.) We have established that some element(s) of our test
> environment must be the culprit for the degradation. As rebooting the
> test machine didn't revert speeds to baselines recorded three months
> ago, we have turned our attention to the database as the only element
> of the environment which is persistent across reboots. Recreating the
> entire PGSQL cluster did cause speeds to revert to baselines.
> I understand that vacuuming solves performance problems related to
> "holes" in data files created as a result of tables being updated. Do
> I understand correctly that if tables are dropped and recreated at the
> beginning of each test case, holes in data files are reclaimed, so
> there is no need for vacuuming from a performance perspective?
> I will double check whether the problematic test cases do indeed
> always drop their tables, but assuming they do, are there any factors
> in the database (apart from table updates) that can cause a linear
> slow-down with repetitive tasks?
> Thanks
> Peter

In response to

pgsql-admin by date

Next:From: JonnyDate: 2008-09-29 11:00:41
Subject: turning of pg_xlog
Previous:From: Peter KovacsDate: 2008-09-29 09:37:36
Subject: Do we need vacuuming when tables are regularly dropped?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group