On Tue, Feb 28, 2012 at 6:11 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Feb 27, 2012 at 4:03 AM, Simon Riggs <si...@2ndquadrant.com> wrote: >> So please use a scale factor that the hardware can cope with. > > OK. I tested this out on Nate Boley's 32-core AMD machine, using > scale factor 100 and scale factor 300. I initialized it with Simon's > patch, which should have the effect of rendering the entire table > unhinted and giving each row a different XID.
Thanks for making the test. I think this tells me the only real way to do this kind of testing is not at arms length from a test machine. So time to get my hands on a machine, but not for this release. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers