Re: [HACKERS] COPY / extend ExclusiveLock

2012-03-25 Thread Tom Lane
Jim Nasby writes: > On 3/22/12 2:13 PM, Stephen Frost wrote: >> Has anyone been working on or considering how to improve the logic >> around doing extends on relations to perhaps make larger extensions >> for larger tables? Or make larger extensions when tables are growing >> very quickly? > I k

Re: [HACKERS] COPY / extend ExclusiveLock

2012-03-25 Thread Jim Nasby
On 3/22/12 2:13 PM, Stephen Frost wrote: Greetings, I've recently become a bit annoyed and frustrated looking at this in top: 23296 postgres 20 0 3341m 304m 299m S 12 0.9 1:50.02 postgres: sfrost gis [local] COPY waiting 24362 postgres 20 0 3353m 298m 285m D 12 0.9 1:24.9

[HACKERS] COPY / extend ExclusiveLock

2012-03-22 Thread Stephen Frost
Greetings, I've recently become a bit annoyed and frustrated looking at this in top: 23296 postgres 20 0 3341m 304m 299m S 12 0.9 1:50.02 postgres: sfrost gis [local] COPY waiting 24362 postgres 20 0 3353m 298m 285m D 12 0.9 1:24.99 postgres: sfros