Re: [HACKERS] Foreign keys in pgbench

2012-06-19 Thread Tom Lane
Jeff Janes writes: > I think that pgbench should it make it easy to assess the impact of > foreign key constraints. > The attached adds a --foreign-keys option to initialization mode which > creates all the relevant constraints between the default tables. I had need of this for testing what I'm

Re: [HACKERS] Foreign keys in pgbench

2012-05-19 Thread Daniel Farina
On Sun, May 13, 2012 at 3:03 PM, Peter Geoghegan wrote: > On 13 May 2012 18:07, Jeff Janes wrote: >> I think that pgbench should it make it easy to assess the impact of >> foreign key constraints. > > I agree in principle.  I favour being more inclusive about pgbench > options, even if the need f

Re: [HACKERS] Foreign keys in pgbench

2012-05-13 Thread Peter Geoghegan
On 13 May 2012 18:07, Jeff Janes wrote: > I think that pgbench should it make it easy to assess the impact of > foreign key constraints. I agree in principle. I favour being more inclusive about pgbench options, even if the need for such options is only marginal, which this isn't - I personally

[HACKERS] Foreign keys in pgbench

2012-05-13 Thread Jeff Janes
I think that pgbench should it make it easy to assess the impact of foreign key constraints. The attached adds a --foreign-keys option to initialization mode which creates all the relevant constraints between the default tables. I changed the order of the table DDLs so that upon reinitialization