From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL win32 fragmentation issue |
Date: | 2006-12-02 18:23:53 |
Message-ID: | 1077.24.211.165.134.1165083833.squirrel@www.dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Joshua D. Drake wrote:
> On Sat, 2006-12-02 at 11:05 -0600, Andrew Dunstan wrote:
>> Joshua D. Drake wrote:
>> >
>> > O.k., doesn't this seem like killing a squirrel with a 50mm tank gun?
>> > The fact that this was suggested as anything but a last resort isn't
>> to
>> > inspiring.
>> >
>>
>> Before you start ringing alarm bells, you need to instrument the actual
>> performance effect.
>
> Alarm bells? I saw a potential issue, I brought it to the community.
> That is all.
You said:
"Essentially, this makes win32 impossible in a 24x7 environment (jokes
aside about Win32 in general) because we *have* to defrag on Windows and
Windows won't defrag open files (thus anything PostgreSQL is using)."
What I am asking for is evidence to back up that assertion. At the moment
it is, as Tom likes to say, "a fact not in evidence".
(I should have thought a single file DB would be MORE liable to
fragmentation, BTW).
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas H. | 2006-12-02 18:35:31 | Re: PostgreSQL win32 fragmentation issue |
Previous Message | Ken Johanson | 2006-12-02 18:08:51 | Re: [HACKERS] Case Preservation disregarding case |