Re: [HACKERS] Postgres Speed or lack thereof

From: John Ryan <john(at)cybertrace(dot)com>
To: Todd Graham Lewis <tlewis(at)mindspring(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, John Holland <jholland(at)isr(dot)umd(dot)edu>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Postgres Speed or lack thereof
Date: 1999-01-23 00:11:34
Message-ID: 36A913B6.66F1@cybertrace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Todd Graham Lewis wrote:
>
> On Wed, 20 Jan 1999, Tom Lane wrote:
>
> > What the -F switch actually does is to disable calls to fsync(2),
> > thereby allowing modified file blocks to hang around in kernel

Could you use an mmapped file and flush it according to some algorythm?
Hard on memory but fast.

--
John Ryan
CEO Ryan Net Works Visit us at www.cybertrace.com
john(at)cybertrace(dot)com (703) 998-1751 (w)
3515-A S. Stafford St. (703) 820-6304 (f)
Arlington, VA 22206-1191 (703) 626-4130 (c)

-----BEGIN PGP PUBLIC KEY BLOCK----- Version: 2.6.2
mQBtAzO3iTYAAAEDAOvDARDRxluZdieT11m6ukP/niHI3qnSL9DKmRrLil5M+Cdp
3w4fV2/HvoBhsUvJE0uLwtbFCCBUP5YkGWNM0oU+XxQHP2+yUY8CDEHLncZ6KHV5
KLlfQKDHSQgZ+58PcQAFE7QjSm9obiBSeWFuIDxqb2huQHd3dy5jeWJlcnRyYWNlLmNvbT4==Wl7V
-----END PGP PUBLIC KEY BLOCK-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1999-01-23 03:00:19 MySQL vulnerability
Previous Message Taral 1999-01-22 23:33:22 Re: [HACKERS] getcwd failing suddenly