[Fwd: Re: RHDB just sits and does nothing?]
От | Mauri Sahlberg |
---|---|
Тема | [Fwd: Re: RHDB just sits and does nothing?] |
Дата | |
Msg-id | 63280.195.197.242.66.1086768991.squirrel@www.claymountain.com обсуждение исходный текст |
Ответы |
Re: [Fwd: Re: RHDB just sits and does nothing?]
|
Список | 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.
Вложения
В списке pgsql-admin по дате отправления: