On Wed, Aug 17, 2016 at 6:45 AM, pinker wrote:
> Hi,
> the problem I'm dealing with is long holding locks during extensions of
> table:
> process xxx still waiting for ExclusiveLock on extension of relation xxx of
> database xxx after 3000.158 ms
> My application is write intensive, in one round I
On 8/17/16 6:45 AM, pinker wrote:
1. rename table t01 to t02
OK...
2. insert into t02 1M rows in chunks for about 100k
Why not just insert into t01??
3. from t01 (previously loaded table) insert data through stored procedure
But you renamed t01 so it no longer exists???
to b01 - this happen
Hi,
the problem I'm dealing with is long holding locks during extensions of
table:
process xxx still waiting for ExclusiveLock on extension of relation xxx of
database xxx after 3000.158 ms
My application is write intensive, in one round I need to insert about 1M
rows. The general scheme of the p
