Re: PostgreSQL win32 fragmentation issue
От | Joshua D. Drake |
---|---|
Тема | Re: PostgreSQL win32 fragmentation issue |
Дата | |
Msg-id | 1165078595.18923.24.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: PostgreSQL win32 fragmentation issue ("Andrew Dunstan" <andrew@dunslane.net>) |
Ответы |
Re: PostgreSQL win32 fragmentation issue
Re: PostgreSQL win32 fragmentation issue |
Список | 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 по дате отправления: