>>>>> "JJ" == Jeff Janes <[email protected]> writes:
JJ> Anyway, the writes are logically sequentially, but not physically. JJ> If I remember correctly, it always writes out full blocks, even if JJ> the last part of the block has not yet been filled with new data. JJ> When the remainder gets filled, it then writes out the full block JJ> again, both the already written and the new part. What does that mean for use of a flash SSD for the xlog dir? Does the block writing mesh up well with the usage pattern a flash SSD needs to maximize lifespan? I'd love a dram ssd for pg_xlog and the journals for the other filesystems, but they cost too much. -JimC -- James Cloos <[email protected]> OpenPGP: 1024D/ED7DAEA6 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
