Re: UPDATE slow

On the linux box it's 2.8 secs with only one index (on clicks) and no fk's. W/O, it's 1.8 secs. Both were done after 'vacuum analyze' and 'reindex table stats'.

John

 Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:

On Tue, 4 Feb 2003, John Smith wrote:

> That works - updates on foo take about 1.4 seconds. I dropped all the
> indexes and fk's on stats and updates there take about 2.8 seconds.
> These are on the cygwin machine.

The 2.8 seconds is on stats after dropping the fks and indexes? But
it didn't help on the linux box?

Have you done a vacuum/reindex recently?

---

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now