Re: [HACKERS] expanding our usage of POSIX_FADVISE

2009-08-12 Thread Cédric Villemain
Le mercredi 12 août 2009, Greg Stark a écrit : > On Wed, Aug 12, 2009 at 3:07 PM, Cédric > > Villemain wrote: > > I wonder if POSIX_FADV_RANDOM and POSIX_FADV_SEQUENTIAL are still > > innacurate for postgreSQL ? > > > > I find > > «A related problem is that the smgr uses the same FD to access the s

Re: [HACKERS] expanding our usage of POSIX_FADVISE

2009-08-12 Thread Greg Stark
On Wed, Aug 12, 2009 at 3:07 PM, Cédric Villemain wrote: > > I wonder if POSIX_FADV_RANDOM and POSIX_FADV_SEQUENTIAL are still innacurate > for postgreSQL ? > > I find > «A related problem is that the smgr uses the same FD to access the same > relation no matter how many scans are in progress. Thin

[HACKERS] expanding our usage of POSIX_FADVISE

2009-08-12 Thread Cédric Villemain
Hello, I wonder if POSIX_FADV_RANDOM and POSIX_FADV_SEQUENTIAL are still innacurate for postgreSQL ? I find «A related problem is that the smgr uses the same FD to access the same relation no matter how many scans are in progress. Think about a complex query that is doing both a seqscan and a