Postgres Pro
Downloads
Home   >   mailing lists

Re: Disk space is consumed by UPDATE query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Disk space is consumed by UPDATE query
Date
Msg-id 9665.1096643199@sss.pgh.pa.us
Whole thread Raw
In response to Disk space is consumed by UPDATE query  (Patrick Clery <patrick@phpforhire.com>)
List pgsql-bugs
Tree view 
Patrick Clery <patrick@phpforhire.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

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: PQdb() fails with coredump when PQconnectDB() passed invalid parameter.
Next
From: Tom Lane
Date:
Subject: Re: Bug in PostrgeSQL 8.0beta