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

Speed Up

From: John Abel <jabel(at)plus(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Speed Up
Date: 2005-07-29 09:36:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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:

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.




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-2017 The PostgreSQL Global Development Group