Re: [PERFORM] Extremely slow server?

2013-09-15 Thread Vitalii Tymchyshyn
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

Re: [PERFORM] Extremely slow server?

2013-09-15 Thread Jeff Janes
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

Re: [PERFORM] COPY TO and VACUUM

2013-09-15 Thread Jeff Janes
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