"Decibel!" <decibel@xxxxxxxxxxx> writes: > On Tue, Sep 11, 2007 at 02:49:28PM -0400, Jean-David Beyer wrote: >> It is tricky for me to find a big enough file to test. I tried one of the > > dd if=/dev/zero of=bigfile bs=8192 count=1000000 On linux another useful trick is: echo 1 > /proc/sys/vm/drop_caches Also, it helps to run a "vmstat 1" in another window and watch the bi and bo columns. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
