Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 42ADB634821 for ; Tue, 14 Apr 2009 18:05:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39335-06 for ; Tue, 14 Apr 2009 18:05:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f167.google.com (mail-ew0-f167.google.com [209.85.219.167]) by mail.postgresql.org (Postfix) with ESMTP id 8788B6347E0 for ; Tue, 14 Apr 2009 18:05:43 -0300 (ADT) Received: by ewy11 with SMTP id 11so4093359ewy.19 for ; Tue, 14 Apr 2009 14:05:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=k45/MjqfCxRdK8OZeC3txekMeI5TRjsYmY0zIFbmiYc=; b=XA7JitnCTeDw7SNxhFvZKYvtq7G99/k0qzOCp8zFfh8ufJPVOrnEltaOQVdEhMl83y 1v8ZPnv9KFXeJan+RuVklql/bq0cXP/TjuU4gdrF4Ofq1186tiJ9DhKLcFIU6u8lAXFW a6R+7fTTvt/osVWIfc3GOcFmjEiqghGLmEYdw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=RHzN32KQuQigxz/ytlPNWEOq5zsvLQkPbfavt9SMeBxDjITgkhTzl0K72U6MWFFK5g fNtrEnunFHFyF29wPJpoKcSHTO9mfzycQueKPapHgVJg7Jy+KSJJWAxTir6l7AJNYKVS UiXrceg2gtYs0FgxD9RAudDSeTEoIuios2L+o= MIME-Version: 1.0 Received: by 10.210.105.8 with SMTP id d8mr6665480ebc.48.1239743142039; Tue, 14 Apr 2009 14:05:42 -0700 (PDT) In-Reply-To: <49E4F930.6010701@obviously.com> References: <49E42C72.9070902@obviously.com> <49E4F930.6010701@obviously.com> Date: Tue, 14 Apr 2009 15:05:41 -0600 Message-ID: Subject: Re: Postgres entering zombie state once a week in production evnvironment From: Scott Marlowe To: Bryce Nesbitt Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/75 X-Sequence-Number: 32421 On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt wrote= : > Scott Marlowe wrote: >> >> What does pg_locks say during this time? =A0Specifically about locks >> that aren't granted? > > I don't know, yet. =A0Though these events go for 15-30 minutes before pos= tgres > restart, and no deadlocks are detected, so I don't think it is locks. Ummm, deadlocks <> locks blocking other queries.