Re: [BUGS] Disk space is consumed by UPDATE query

2004-10-01 Thread Tom Lane
Patrick Clery <[EMAIL PROTECTED]> 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 lo

[BUGS] Disk space is consumed by UPDATE query

2004-10-01 Thread Patrick Clery
Your name : Patrick Clery Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Operating System (example: Linux 2.4.18) : FreeBSD 4.10-stable PostgreSQL version (example: PostgreSQL-8