X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 86D169DC874 for ; Fri, 24 Feb 2006 02:22:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57739-05 for ; Fri, 24 Feb 2006 02:22:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 55ADD9DC840 for ; Fri, 24 Feb 2006 02:22:48 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k1O6HC6f012811; Fri, 24 Feb 2006 11:47:12 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 05117332665; Fri, 24 Feb 2006 11:47:12 +0530 (IST) Message-ID: <013d01c6390b$73cf5970$cd00000a@sandhyar> From: "sandhya" To: "Michael Fuhr" Cc: "Postgres" References: <00ce01c6384e$68e3c540$cd00000a@sandhyar> <20060223152838.GA36720@winnie.fuhr.org> Subject: Re: large object unlinking Date: Fri, 24 Feb 2006 11:57:57 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.078 required=5 tests=[AWL=0.077, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.078 X-Spam-Level: X-Archive-Number: 200602/306 X-Sequence-Number: 20727 Thank You Fuhr. In select lo_unlink(objid) from (select distinct objid from filetbl)AS s; the above query what is that 'S' stands for in AS 'S' Can u pls explain me..... ----- Original Message ----- From: "Michael Fuhr" To: "sandhya" Cc: "Postgres" Sent: Thursday, February 23, 2006 8:58 PM Subject: Re: [ADMIN] large object unlinking > On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote: > > Is there any possibility to delete /Unlink a group of large objects at a time? > > Please tell me .To test my application i have loaded somany files into database. > > Now i want to unlink all those objects. > > You could call lo_unlink() in a query. Example: > > SELECT lo_unlink(loid) FROM (SELECT DISTINCT loid FROM foo) AS s; > > See also contrib/vacuumlo, which will automatically remove large > objects that aren't referenced anywhere. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >