Re: PostgreSQL win32 fragmentation issue - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: PostgreSQL win32 fragmentation issue
Date
Msg-id 1165078595.18923.24.camel@localhost.localdomain
Whole thread Raw
In response to Re: PostgreSQL win32 fragmentation issue  ("Andrew Dunstan" <andrew@dunslane.net>)
Responses Re: PostgreSQL win32 fragmentation issue
Re: PostgreSQL win32 fragmentation issue
List pgsql-hackers
> > Well, we mostly do random reads (seek) all the time anyway, so is this
> > really a concern?
> >
> > Are you using NTFS or FAT?  You didn't answer that question.
> >
> 
> If it's FAT then you deserve what you get.

I am investigating this for the wider community. I do not, use
PostgreSQL Win32 for anything but testing, but guess what -- our silent
majority does. I have a customer with 5000 Win32 installations and they
are not the only ones with those types of deployments.

I am trying to get as much information as possible so that:

1. We can update the documentation to correctly reflect issues with
Win32.

2. We can hopefully become the dominant database on Win32.

> 
> If you really need this, a Slony setup would probably work well.

The idea of Slony with Windows is a bit terryfying considering the
target Admin audience and the performance hit one would take. 

>  Shut down
> replica, defrag, start up replica, wait for sync completion, switchover
> and repeat. The new Slony release is said to support Windows.

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.

Sincerely,

Joshua D. Drake



> 
> cheers
> 
> andrew
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 
-- 
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997            http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





pgsql-hackers by date:

Previous
From: "Thomas H."
Date:
Subject: Re: PostgreSQL win32 fragmentation issue
Next
From: "Andrew Dunstan"
Date:
Subject: Re: PostgreSQL win32 fragmentation issue