Re: UPDATE becomes mired / win32 - Mailing list pgsql-performance

From Tom Lane
Subject Re: UPDATE becomes mired / win32
Date
Msg-id 12200.1160054364@sss.pgh.pa.us
Whole thread Raw
In response to Re: UPDATE becomes mired / win32  (Steve Peterson <stevep-hv@zpfe.com>)
List pgsql-performance
Steve Peterson <stevep-hv@zpfe.com> writes:
> The behavior also persists across a dump/reload of the table into a
> new install on a different machine.  IIRC dump/reload rebuilds
> indexes from scratch.

Hm.  There must be something you're not telling us that accounts for
the difference between the original table and the copied version ---
foreign keys linking from other tables, perhaps?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Re: Performance Optimization for Dummies 2 - the SQL
Next
From: Tom Lane
Date:
Subject: Re: Performance Optimization for Dummies 2 - the SQL