I did not completely understand you.
Postgresql only uses regular files as its db. Do you suggest something
like mounting
an image file that supports RW? can you give an example?
If you mean native partitions then postgresql does not support these.
I don't mind low performance since its all relative to other runs in the
benchmarking.
Sadly postgresql relies on the underlying OS caching. Readaheads and
all,
they have O_DIRECT on their todo list...
so its currently not possible.
Regards,
tzahi.
> -----Original Message-----
> From: Eran Tromer [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 29, 2005 2:32 AM
> To: Tzahi Fadida
> Cc: Linux-IL mailing list
> Subject: Re: cleaning memory.
>
>
> On 29/04/05 03:11, Tzahi Fadida wrote:
> > Is there a file system out there
> > that I could disable its caching when mounting?
>
> If your DBMS can uss a character device instead of file (most
> do), then you can use a raw device on top of a block device
> (i.e., a disk partition, or a loopback device on top of a
> file). That won't be cached. Actually this is often
> recommended for performance reasons, to prevent the OS from
> caching data that's already in the DBMS's cache.
>
> Alternatively, use a recent Linux kernel and tell the DBMS to
> use the O_DIRECT flag when open()ing the database files
> (e.g., for recent MySQL versions with InnoDB, set
> innodb_flush_method to O_DIRECT).
>
> Eran
>
>
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
