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

Speed Up clean_pending.pl?

From: John Abel <jabel(at)plus(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Speed Up clean_pending.pl?
Date: 2005-07-29 09:36:09
Message-ID: 42E9F889.10604@plus.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

The company I'm at is running dbmirror, and we've found a problem with 
clean_pending,pl, in that it takes an age to run.  I've done some 
looking about, and came with up this:

http://www.postgresql.org/docs/7.4/interactive/indexes.html

After reading the comments on that page, I explain'd the query that 
clean_pending runs, and found that it is performing a sequential scan on 
each of the tables.

Is there a way to make it use the indexes?

Any help would be appreciated.

Thanks

John

Responses

pgsql-admin by date

Next:From: Devrim GUNDUZDate: 2005-07-29 11:04:06
Subject: Re: PostgreSQL Installation
Previous:From: Bruno Wolff IIIDate: 2005-07-29 07:18:13
Subject: Re: PostgreSQL Installation

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