On Mon, Sep 14, 2009 at 6:57 PM, Aude aude.wiki@gmail.com wrote:
I haven't had so much free time lately, but am comfortable with helping set up and configure PostgreSQL and PostGIS and get the OSM database import going. Though, there are many more tasks to do that I have time to do.
Yay!
Partitioning the servers in an optimal manner for us is something I'm not as comfortable with. I could figure it out if necessary, but Saper is probably better capable of that. One thing I do know is that the database logs should be on separate partition from the database itself, and both kept separate from the OS.
I can't remember what sort of RAID setup we have. Depending on the RAID how we partition might not matter at all.
Without having tried it I wouldn't think that putting logging on a separate disk doesn't help that much. Logging doesn't take up so much I/O. However keeping the database and its indexes on separate disks evidently helps a lot. See recent discussions on osm-dev/talk about database setup.
..although most of that is outdated when compared to this: https://wiki.toolserver.org/view/OpenStreetMap_server/Setup_notes
On Cassini, work is needed on PostgreSQL configuration.
I'll take care of this one.
I can't view this. I'll hopefully get the required JIRA permissions soon.