On 3/18/07, Barry Moore <barry.moore@xxxxxxxxxxxxxxxxx> wrote:
Does anyone know how I can repeatedly run the same query in the "worst case scenario" of no postgres data in the disk cache (e.g., clear the page cache or force it to be ignored)?
try to disconnect from postgresql, reconnect, rerun the query. if it doesn't help - you can try unmounting filesystem which contains postgresql data, and remounting it again. of course with postgresql shutdown. depesz -- http://www.depesz.com/ - nowy, lepszy depesz
