| From: | "Graham Vickrage" <graham(at)digitalplanit(dot)com> |
|---|---|
| To: | "Postgres SQL" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Update taking forever |
| Date: | 2001-03-29 18:42:15 |
| Message-ID: | NDBBJABDILOPAOOMFJHOAEOECIAA.graham@digitalplanit.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I am trying to do an update on column in a table with 1.5 millions rows.
The SQL is as follows, I am also putting it in a transaction in case things
go wrong.
begin;
update statistics set parameters = NULL where parameters ='';
An explain produces the following: -
Seq Scan on statistics (cost=0.00..56174.49 rows=14976 width=88)
Would anyone be able to tell me why it is seemingly infinite, i'm running
linux, postgres v7.0
Cheers
Graham
| Attachment | Content-Type | Size |
|---|---|---|
| winmail.dat | application/ms-tnef | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2001-03-29 18:47:32 | RE: serial type; race conditions |
| Previous Message | Tom Lane | 2001-03-29 17:13:18 | Re: Calling Java from psql (was Re: requesting help) |