Home > mailing lists

Re: UPDATE slow - Mailing list pgsql-general

From	John Smith
Subject	Re: UPDATE slow
Date	February 4, 2003 20:44:32
Msg-id	20030204224431.11898.qmail@web40710.mail.yahoo.com Whole thread Raw
In response to	Re: UPDATE slow (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List	pgsql-general

Tree view

It has two foreign key references to two other tables. No other tables reference stats though.

John

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

On Tue, 4 Feb 2003, John Smith wrote:

> Just tried it on Linux - still takes 5-10 seconds. Any speed-up tips?
> Also tried it on MySQL and the update is nearly instantaneous :(.

Hmm, does stats reference another table or is it referenced by another
table?

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

pgsql-general by date:

From: Stephan Szabo
Date: 04 February 2003, 20:40:35
Subject: Re: UPDATE slow

From: John Smith
Date: 04 February 2003, 20:49:28
Subject: Re: UPDATE slow

Re: UPDATE slow - Mailing list pgsql-general

Previous

Next