On Wed, Jul 11, 2012 at 3:51 PM, Daniel Farina <daniel@xxxxxxxxxx> wrote: > > Nope. I don't. But an exact crossover is a level of precision I don't > really need, because here are where things stand on a completely > unremarkable test suite on the closest project to me that meets the > "regular web-app" profile case: > > With en-masse DELETE: > rake 41.89s user 3.08s system 76% cpu 58.629 total > > With TRUNCATE: > rake 49.86s user 2.93s system 5% cpu 15:17.88 total > > 15x slower. This is a Macbook Air with full disk encryption and SSD > disk with fsync off, e.g. a very typical developer configuration. What is shared_buffers? > This is a rather small schema -- probably a half a dozen tables, and > probably about a dozen indexes. This application is entirely > unremarkable in its test-database workload: it wants to load a few > records, do a few things, and then clear those handful of records. How many rounds of truncation does one rake do? I.e. how many truncations are occurring over the course of that 1 minute or 15 minutes? Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
