Re: Delete performance - Mailing list pgsql-general

From Tom Lane
Subject Re: Delete performance
Date
Msg-id 19710.1005865269@sss.pgh.pa.us
Whole thread Raw
In response to Delete performance  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
List pgsql-general
"P.J. \"Josh\" Rovero" <rovero@sonalysts.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

pgsql-general by date:

Previous
From: "Culley Harrelson"
Date:
Subject: [PHP] Re: psql with PHP question
Next
From: Stephan Szabo
Date:
Subject: Re: Bug?