| From: | "Mauri Sahlberg" <Mauri(dot)Sahlberg(at)claymountain(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | [Fwd: Re: RHDB just sits and does nothing?] |
| Date: | 2004-06-09 08:16:31 |
| Message-ID: | 63280.195.197.242.66.1086768991.squirrel@www.claymountain.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
Full log as an attachment.
| Attachment | Content-Type | Size |
|---|---|---|
| foo | application/octet-stream | 4.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lise chhay | 2004-06-09 10:26:11 | Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432 ? |
| Previous Message | Mauri Sahlberg | 2004-06-09 07:06:30 | RHDB just sits and does nothing? |