Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 87E042E004A for ; Mon, 7 Jan 2008 12:46:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89617-03 for ; Mon, 7 Jan 2008 12:46:33 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id BF4352E01E3 for ; Mon, 7 Jan 2008 12:46:32 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so13003201waf.5 for ; Mon, 07 Jan 2008 08:46:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=fA4PqtiUlTly9HGEh4SfWzaSfMp4nr+cQxsb9Qnpl78=; b=E7hyLGE5zBIJpVJFxMTVPurnsq8Q/X1vyt+xM3QgKYs0Fnh7XV3v/T1wuGz9eKE9aFhfJDVh4LZYGQSRgmy77OOYmQMLnULUR8N8gUP1eh4SJhtLraPt9N6HE9mZNftVpQaq3QecN5mrsJK2827uUMfTdPMAvdozxI1kEX1kElQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nNro0h4cpdlZoUw6XOM6Tf64pCSVTB2feG2Bxy19E7A/fqce4V8D06xEVPaj5496K6yB3LO9oR8HPtQW80sW1l2/9742rxiSYlpNqYxDwBeC75WlDRXcS8aZwNRetvCi0loilmBJNBmuFF9pmhI1bivGibuvPscNHG1LCfIlRjw= Received: by 10.114.93.17 with SMTP id q17mr6616404wab.70.1199724391381; Mon, 07 Jan 2008 08:46:31 -0800 (PST) Received: by 10.114.131.4 with HTTP; Mon, 7 Jan 2008 08:46:31 -0800 (PST) Message-ID: Date: Mon, 7 Jan 2008 10:46:31 -0600 From: "Scott Marlowe" To: "Suresh Gupta VG" Subject: Re: Need some info on Postgresql Cc: "Peter Koczan" , pgsql-admin@postgresql.org In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0BB943DF@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3D5445983859B84B92669C0D883EA6FB0BB943DF@ZENMAILHQ1.ind.zensar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/77 X-Sequence-Number: 27851 On Jan 7, 2008 3:41 AM, Suresh Gupta VG wrote: > > Hi Scott, > > Thanks for your reply. Pls find the attached file for the output of the > command given by you. The reindex problem is coming for the table > "currency". Pls look into the result and advice me what to do. Well, looks like something is holding locks on currency. What processes are using that table and what kind of explicit locks, if any, are they taking?