Re: Disk space is consumed by UPDATE query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Clery <patrick(at)phpforhire(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Disk space is consumed by UPDATE query
Date: 2004-10-01 15:06:39
Message-ID: 9665.1096643199@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Patrick Clery <patrick(at)phpforhire(dot)com> writes:
> Here's the query plan:
> ...
> -> Seq Scan on people_locations (cost=0.00..20.00
> rows=1000 width=122)

The query planner evidently does not know that the people_locations
table is large. A VACUUM or ANALYZE on it would help a lot.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-01 15:20:04 Re: Bug in PostrgeSQL 8.0beta
Previous Message Michael Fuhr 2004-10-01 14:51:52 Re: PQdb() fails with coredump when PQconnectDB() passed invalid parameter.