Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performance Tuning and Disk Cache
- From: Michael Stone <mstone+postgres(at)mathom(dot)us>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Performance Tuning and Disk Cache
- Date: Sun, 18 Mar 2007 14:49:06 -0400
On Sun, Mar 18, 2007 at 06:45:34AM -0600, Barry Moore 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)?
Depends on your OS. On linux you can run: echo 1 > /proc/sys/vm/drop_caches Mike Stone
- References:
- Performance Tuning and Disk Cache
- From: Barry Moore
- Performance Tuning and Disk Cache
- Prev by Date: Re: Performance Tuning and Disk Cache
- Next by Date: Re: function call vs staright query
- Previous by thread: Re: Performance Tuning and Disk Cache
- Next by thread: Vacuum full is slow
- Indexes: