Re: Are indexes blown?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Are indexes blown?
Date: 2008-02-18 16:22:29
Message-ID: 20080218162229.GE977@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 15, 2008 at 09:09:32PM +0800, Phoenix Kiula wrote:
> Actually my host has just told me that I have a number of "hung
> semaphores" in my server. And he is relating them to postgresql. I am
> not surprised, because this is the only utility that has issues. All
> the rest is working (apache, mysql, exim, etc). Any thoughts on where
> I should start looking for hung semaphores?

If this means what I think it means, you have bigger problems than you've
been posting. Shut down postgres, and clean up any shared memory segments
that are hanging around. See the manual on ipcclean.

A

In response to

Browse pgsql-general by date

  From Date Subject
Next Message fdu.xiaojf@gmail.com 2008-02-18 16:37:13 questions about very large table and partitioning
Previous Message Andrew Sullivan 2008-02-18 16:20:36 Re: Are indexes blown?