Received: from digitalplanit.wdi.co.uk ([195.13.87.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f2TIhnK71608 for ; Thu, 29 Mar 2001 13:43:49 -0500 (EST) (envelope-from graham@digitalplanit.com) Received: from graham (dp0002.demon.co.uk [193.237.187.164]) by digitalplanit.wdi.co.uk (8.9.3/8.9.3) with SMTP id TAA20266 for ; Thu, 29 Mar 2001 19:42:12 GMT From: "Graham Vickrage" To: "Postgres SQL" Subject: Update taking forever Date: Thu, 29 Mar 2001 19:42:15 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0028_01C0B888.5B46BF00" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MS-TNEF-Correlator: X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200103/615 X-Sequence-Number: 2286 This is a multi-part message in MIME format. ------=_NextPart_000_0028_01C0B888.5B46BF00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0028_01C0B888.5B46BF00 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+Ig8SAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANEHAwAdABMAKQAAAAQAOAEBA5AGAFQGAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAAFgAAAFVw ZGF0ZSB0YWtpbmcgZm9yZXZlcgAAAAIBcQABAAAAFgAAAAHAuH/roNgT0/wk JxHVkBcASFRQH7YAAAIBHQwBAAAAHgAAAFNNVFA6R1JBSEFNQERJR0lUQUxQ TEFOSVQuQ09NAAAACwABDgAAAABAAAYOAIajzH+4wAECAQoOAQAAABgAAAAA AAAAi6davEbI0xGQEwBIVFAftsKAAAALAB8OAQAAAAIBCRABAAAA9gEAAPIB AAB8AgAATFpGdet4HNUDAAoAcmNwZzEyNSYyAPgLYG5nAdA1N08B9wKkA+MC AGNoCsBzsGV0MCAHEwKAfQqBknYIkHdrC4BkNAxgDmMAUAsDC7UgSSBhoG0g dHJ5C4BnFBAYbyBkFKADkXVwZFBhdGUgAiAgCOF1vm0DoAuAE+AUEAGgbBVw AQPwdGggMS41IHJtAxBsaQIgBCADYHeccy4KogqECoBUaBVw2FNRTBYgBCBh BCACEFsXkBgRLBPEB0BzFKBw3nUCQBRSFvAWJXIAcQDQ9xtQFZEWMWMZwBVw FwAUUXUEIGcUoHcDYA8gGEtitGVnC4A7GFQVJXMBkP8bUCBQDeAEIBEhGxAK wBPwlxEwBJAEID0HsFVMGXDOdxkgCXAhOycnH3UYVHJBA6BleAtTGxADYGQ/ EsAHkRcAFXAZ9BRROiD2LRhUBmBxBgAdEAOgFZEZIFkgKAWgIFA9MC4GMCjw F0A2MTc0LiQ0ORfzPTEpsDc2hRbRZBcAPTg4KRha0lcIYGxkFOF5AiAVcP8f IBPgFqIUkRVgF5AXYBbBbGh5G5Mg4mUXcA8gbFkuAW5mC4AW8GUaYGniJxQA cnVuAwAUYReg6G51eBpgcCixCcEEIOx2NykAGFpDGSAhshhatkccMBDwbRhU EeEANLAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwADgAgg BgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAAAADAAAAAAAAA RgAAAABShQAAJ2oBAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAA BAAAADkuMAAeAAqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAA AAAAHgALgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4A DIAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALAA2ACCAG AAAAAADAAAAAAAAARgAAAACChQAAAQAAAAsAOoAIIAYAAAAAAMAAAAAAAABG AAAAAA6FAAAAAAAAAwA8gAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAAD AD2ACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAsAUoAIIAYAAAAAAMAA AAAAAABGAAAAAAaFAAAAAAAAAwBTgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUA AAAAAAACAfgPAQAAABAAAACLp1q8RsjTEZATAEhUUB+2AgH6DwEAAAAQAAAA i6davEbI0xGQEwBIVFAftgIB+w8BAAAAggAAAAAAAAA4obsQBeUQGqG7CAAr KlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEM6XFdJ TkRPV1NcTG9jYWwgU2V0dGluZ3NcQXBwbGljYXRpb24gRGF0YVxNaWNyb3Nv ZnRcT3V0bG9va1xvdXRsb29rLnBzdAAAAAMA/g8FAAAAAwANNP03AAACAX8A AQAAADgAAAA8TkRCQkpBQkRJTE9QQU9PTUZKSE9BRU9FQ0lBQS5ncmFoYW1A ZGlnaXRhbHBsYW5pdC5jb20+AAMABhD95j0dAwAHEGABAAADABAQAAAAAAMA ERAAAAAAHgAIEAEAAABlAAAASUFNVFJZSU5HVE9ET0FOVVBEQVRFT05DT0xV TU5JTkFUQUJMRVdJVEgxNU1JTExJT05TUk9XU1RIRVNRTElTQVNGT0xMT1dT LElBTUFMU09QVVRUSU5HSVRJTkFUUkFOU0FDVAAAAACSUQ== ------=_NextPart_000_0028_01C0B888.5B46BF00--