Can it be hardware problem with io? Try finding out which file the stuck
table is and do a simple fs copy. Or simply do a copy of the whole pg data
directory.
15 вер. 2013 04:54, "Craig James" напис.
> On Sat, Sep 14, 2013 at 11:36 AM, bricklen wrote:
>
>> On Sat, Sep 14, 2013 at 11:28 AM, Craig
On Sat, Sep 14, 2013 at 7:06 PM, bricklen wrote:
>
>
> I don't have any solutions at the moment, but three things come to mind:
>
> 1). Try without "--blobs",
> 2). Does "strace -p " show anything unusual?
> Futex? Lots of semops?
>
He probably needs to find the pid of the backend to which pg_du
On Wed, Sep 11, 2013 at 11:14 PM, Roberto Grandi <
roberto.gra...@trovaprezzi.it> wrote:
> Hi Guys,
>
> we found a suitable solution for our process we run every 5-6 hours a
> CLUSTER stement for our big table: this "lock" activities but allow us to
> recover all available space.
>
If you can to