On 2011-06-06 09:42, Heikki Linnakangas wrote:
took about 15 hours without the patch, and 2 hours with it. That's quite dramatic.
With the precense of robust consumer-class SSD-drives that can be found in sizes where they actually can fit "many" database usage scenarios. A PostgreSQL version is not likely to hit the streets before 50% of PostgreSQL users are sitting on "some kind" of flash based storage (for the part where the entire dataset doesn't fit in memory any more). Point is: * Wouldn't it be natural to measure the performance benefits of disc-bound tests in an SSD setup? ... my understanding of Fast gi(n|st) index build is that it is more or less a challenge to transform a lot of random IO workload to be more sequential and collapse multiple changes into fewer. In terms of random IO an SSD can easily be x100 better than rotating drives and it would be a shame to optimize "against" that world? -- Jesper -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
