> > That latter test - won't that pretty much just read from the page > cache? > > 'sync' may well have forced dirty pages to disk but does it actually > > evict them to? > > Basically, the cache is avoided because of the size of the file. > 6000000 blocks at 8k exceeds the size of RAM in the machine, so it > *should* miss the cache and hit the disk directly. :) Doh! > > > > Anyway, that is off topic... perhaps ;) > > > > Thanks again, > > > > Jim > > > > Cheers > > Martin ============================================= Romax Technology > Limited Rutherford House Nottingham Science & Technology Park > Nottingham, NG7 2PZ England Telephone numbers: +44 (0)115 951 88 00 > (main) For other office locations see: > http://www.romaxtech.com/Contact ================================= > =============== E-mail: info@xxxxxxxxxxxxx Website: www.romaxtech.com > ================================= ================ Confidentiality > Statement This transmission is for the addressee only and contains > information that is confidential and privileged. Unless you are the > named addressee, or authorised to receive it on behalf of the > addressee you may not copy or use it, or disclose it to anyone else. > If you have received this transmission in error please delete from > your system and contact the sender. Thank you for your cooperation. > ================================================= > -- Jim Vanns Systems Programmer Framestore -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance