On Wed, Jun 07, 2006 at 04:11:57PM +0100, Simon Riggs wrote: > On Wed, 2006-06-07 at 09:35 -0500, Jim C. Nasby wrote: > > > Would simply changing the ORDER BY to DESC suffice for this? FWIW: > > Try sorting on aid also, both ascneding and descending. > > We need to try lots of tests, not just one thats chosen to show the > patch in the best light. I want this, but we need to check.
Well, correlation on everything in that table is 1. At this point maybe it makes more sense to just come up with a different test case, possibly generate_series and random. Better yet would be if someone came up with a patch that actually populated the filler field in pgbench. Better still would be allowing the user to define how large they wanted the filler field to be... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
