Re: update problem?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Juergen G(dot) Mischke" <jgmischke(at)j-g-m(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: update problem?
Date: 2002-07-09 16:48:38
Message-ID: 20020709094640.W39520-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Tue, 9 Jul 2002, Juergen G. Mischke wrote:

> Could it be true??
>
> I've a table with < 46000 rows. And a little Update like
>
> UPDATE foo set xxx = 'X';
>
> needs about 15 seconds???
>
> What's wrong?

Does the table have any foreign key constraints or other
tables that reference it in foreign key constraints? What's
the schema of the table?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert L Mathews 2002-07-09 16:50:52 Re: Query Casting Help
Previous Message Joe Conway 2002-07-09 16:36:47 Re: Returning bytea* from a C function

Browse pgsql-novice by date

  From Date Subject
Next Message John Nix 2002-07-09 17:24:51 Date Duration Numbers
Previous Message Tom Lane 2002-07-09 16:20:27 Re: pg_dump, restore and versioning