Re: Delete performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "P(dot)J(dot) \"Josh\" Rovero" <rovero(at)sonalysts(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Delete performance
Date: 2001-11-15 23:01:09
Message-ID: 19710.1005865269@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"P.J. \"Josh\" Rovero" <rovero(at)sonalysts(dot)com> writes:
> Is there a performance issue deleting rows of a table where one
> field is toasted text?

It'd require an additional table access for each such field, but
that seems unlikely to explain the performance problem you're seeing.
Have you looked at EXPLAIN output for the two cases?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-11-15 23:02:35 Re: Bug?
Previous Message Gurupartap Davis 2001-11-15 22:57:04 Re: pgsql and large tables