On 07/26/2013 11:42 AM, Greg Smith wrote: > On 7/25/13 6:02 PM, didier wrote: >> It was surely already discussed but why isn't postresql writing >> sequentially its cache in a temporary file? > > If you do that, reads of the data will have to traverse that temporary > file to assemble their data. In case of crash recovery, a sequential reading of this file could be performed as first step.
this should work fairly well in most cases, at least when the recovery shared_buffers is not smaller than the latest run of checkpoint-written dirty buffers. -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
