From: Scott Marlowe <smarlowe@qwest.net>
To: Mauri Sahlberg <Mauri.Sahlberg@claymountain.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [Fwd: Re: RHDB just sits and does nothing?]
Date: Wed, 09 Jun 2004 07:01:51 -0600
Message-ID: <1086786111.23855.4.camel@localhost.localdomain> (raw)
In-Reply-To: <63280.195.197.242.66.1086768991.squirrel@www.claymountain.com>
References: <63280.195.197.242.66.1086768991.squirrel@www.claymountain.com>
On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote:
> Hi,
>
> What an earth I am doing wrong? I am trying to delete about 6500 rows and
> I am the only user connected to the database and it just sits there and
> does nothing?
>
> Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin;
> Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181 sec
> Jun 9 10:02:51 pihsi postgres[31547]: [27] LOG: query: set constraints
> all deferred;
> Jun 9 10:02:51 pihsi postgres[31547]: [28] LOG: duration: 0.000205 sec
> Jun 9 10:03:04 pihsi postgres[31547]: [29] LOG: query: delete from
> tilikartta
> where yritys=18231413;
>
> and after a long wait...
> Jun 9 10:46:16 pihsi postgres[31547]: [30] LOG: duration: 2592.534609
> sec Jun 9 11:00:28 pihsi postgres[31547]: [31] LOG: query: commit;
> Jun 9 11:00:28 pihsi postgres[31547]: [32] LOG: duration: 0.002915 sec
>
> DELETE 6347
> rahaks=# commit;
> COMMIT
>
> It just took about three quarters of a hour to delete 6500 rows!
> Something is definitely broken and probably I am the one who broke it. Any
> guesses what I have broken and how I could fix this?
Do you have any foreign key references that are of mismatched types
involved?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: smarlowe@qwest.net, Mauri.Sahlberg@claymountain.com
Subject: Re: [Fwd: Re: RHDB just sits and does nothing?]
In-Reply-To: <1086786111.23855.4.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox