Re: [HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-20 Thread Jeff Janes
On Tue, Jun 19, 2012 at 8:06 PM, Robert Haas wrote: > On Tue, Jun 19, 2012 at 10:56 PM, Jeff Janes wrote: >> But in the 9.2 branch, the slow phenotype was re-introduced in >> 1575fbcb795fc331f4, although perhaps the details of who is locking >> what differs.  I haven't yet sorted that out. > > It

Re: [HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-19 Thread Robert Haas
On Tue, Jun 19, 2012 at 10:56 PM, Jeff Janes wrote: > But in the 9.2 branch, the slow phenotype was re-introduced in > 1575fbcb795fc331f4, although perhaps the details of who is locking > what differs.  I haven't yet sorted that out. It very much does. That commit prevents people from creating a

Re: [HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-19 Thread Jeff Janes
On Tue, Jun 19, 2012 at 2:38 PM, Robert Haas wrote: > On Tue, Jun 19, 2012 at 4:33 PM, Robert Haas wrote: >> On Mon, Jun 18, 2012 at 8:42 PM, Jeff Janes wrote: >>> There was a regression introduced in 9.2 that effects the creation and >>> loading of lots of small tables in a single transaction.

Re: [HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-19 Thread Robert Haas
On Tue, Jun 19, 2012 at 4:33 PM, Robert Haas wrote: > On Mon, Jun 18, 2012 at 8:42 PM, Jeff Janes wrote: >> There was a regression introduced in 9.2 that effects the creation and >> loading of lots of small tables in a single transaction. >> >> It affects the loading of a pg_dump file which has a

Re: [HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-19 Thread Robert Haas
On Mon, Jun 18, 2012 at 8:42 PM, Jeff Janes wrote: > There was a regression introduced in 9.2 that effects the creation and > loading of lots of small tables in a single transaction. > > It affects the loading of a pg_dump file which has a large number of > small tables (10,000 schemas, one table

[HACKERS] performance regression in 9.2 when loading lots of small tables

2012-06-18 Thread Jeff Janes
There was a regression introduced in 9.2 that effects the creation and loading of lots of small tables in a single transaction. It affects the loading of a pg_dump file which has a large number of small tables (10,000 schemas, one table per schema, 10 rows per table). I did not test other schema