Skip site navigation (1) Skip section navigation (2)

Re: Anything to be gained from a 'Postgres Filesystem'?

From: Jan Dittmer <jdittmer(at)ppp0(dot)net>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: matt(at)ymogen(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-10-21 15:02:00
Message-ID: 4177CF68.2050108@ppp0.net (view raw or flat)
Thread:
Lists: pgsql-performance
Neil Conway wrote:
> Also, I would imagine Win32 provides some means to inform the kernel 
> about your expected I/O pattern, but I haven't checked. Does anyone know 
> of any other relevant APIs?

See CreateFile, Parameter dwFlagsAndAttributes

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/createfile.asp

There is FILE_FLAG_NO_BUFFERING, FILE_FLAG_OPEN_NO_RECALL,
FILE_FLAG_RANDOM_ACCESS and even FILE_FLAG_POSIX_SEMANTICS

Jan


In response to

pgsql-performance by date

Next:From: Stephan SzaboDate: 2004-10-21 15:05:59
Subject: Re: Simple machine-killing query!
Previous:From: Victor CiurusDate: 2004-10-21 14:34:17
Subject: Simple machine-killing query!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group