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

Re: Help speeding up delete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help speeding up delete
Date: 2005-11-14 23:42:43
Message-ID: 4162.1132011763@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-www
Steve Wampler <swampler(at)noao(dot)edu> writes:
> We've got an older system in production (PG 7.2.4).  Recently
> one of the users has wanted to implement a selective delete,
> but is finding that the time it appears to take exceeds her
> patience factor by several orders of magnitude.  Here's
> a synopsis of her report.  It appears that the "WHERE
> id IN ..." is resulting in a seq scan that is causing
> the problem, but we're not SQL expert enough to know
> what to do about it.

> Can someone point out what we're doing wrong, or how we
> could get a (much) faster delete?  Thanks!

Update to 7.4 or later ;-)

Quite seriously, if you're still using 7.2.4 for production purposes
you could justifiably be accused of negligence.  There are three or four
data-loss-grade bugs fixed in the later 7.2.x releases, not to mention
security holes; and that was before we abandoned support for 7.2.
You *really* need to be thinking about an update.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Adam WeisbergDate: 2005-11-14 23:46:41
Subject: Hardware/OS recommendations for large databases (5TB)
Previous:From: Scott LambDate: 2005-11-14 23:20:21
Subject: Re: Help speeding up delete

pgsql-www by date

Next:From: Steve WamplerDate: 2005-11-14 23:52:53
Subject: Re: Help speeding up delete
Previous:From: Scott LambDate: 2005-11-14 23:20:21
Subject: Re: Help speeding up delete

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