Tim Uckun wrote:

If you have any suggestions I am all ears. For the purposes of this
discussion we can narrow down the problem this update statement.

Update imports set make_id = null.
Well, that simplifies things.

First off, what does it say for rows affected? (Hint, if you really
are using a default configuration and it doesn't say 0 rows
affected, please show us the actual query used.)

Second, try connecting to the database as a superuser and running:

VACUUM ANALYZE imports;
-- (show us the results)
VACUUM FULL imports;
VACUUM FREEZE ANALYZE;  -- (don't specify a table)

Then try your query and see whether performance is any different.

-Kevin

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 12 of 38 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJan 21, '13 at 8:04a
activeJan 27, '13 at 10:28a
posts38
users9
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase