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

Re: [HACKERS] COPY / extend ExclusiveLock

2012-03-25 Thread Tom Lane
Jim Nasby j...@nasby.net 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?

[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: