Dne 16.2.2012 9:53, Marti Raudsepp napsal(a):
2012/2/15 Vojtěch Rylko:
this query performed so long and blocked table so I had to interrupt it. Is
there any way how to drop large indexes in non-blocking or /faster/ way?
Usually the problem is not with the size of the index -- but some
other run
Albe Laurenz wrote:
> Vojtech Rylko wrote:
> > I need to drop some b-tree indexes because they are not used anymore.
> > Size of indexes vary between 700 MB and 7 GB. I tried common DROP
> > INDEX... but this query performed so long and blocked table so I had to
> > interrupt it. Is there any way
2012/2/15 Vojtěch Rylko :
> this query performed so long and blocked table so I had to interrupt it. Is
> there any way how to drop large indexes in non-blocking or /faster/ way?
Usually the problem is not with the size of the index -- but some
other running transactions that hold a read lock on t
Vojtech Rylko wrote:
> I need to drop some b-tree indexes because they are not used anymore.
> Size of indexes vary between 700 MB and 7 GB. I tried common DROP
> INDEX... but this query performed so long and blocked table so I had to
> interrupt it. Is there any way how to drop large indexes in no
