Skip site navigation (1) Skip section navigation (2)

Re: Postgres 8.x on Windows Server in production

From: Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)yu>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres 8.x on Windows Server in production
Date: 2009-04-13 13:23:11
Message-ID: 49E33CBF.8060304@etf.bg.ac.yu (view raw or flat)
Thread:
Lists: pgsql-performance
Hi all,

First, thank you all for your answers.


Grzegorz Jaśkiewicz wrote:
> Give it a try, and please tell us what sort of application you want to
> put on it.

It is a student database for the college which is a client of ours. The 
size of the database should be around 1GB, half being binary data 
(images). Not more than 100 users at the time will be working with the 
application.

I don't worry about the performance, but more about the maintenance 
under Windows. What file system to use? How to schedule vacuuming and 
backup? Are there any windows services that should be turned off? Those 
questions come to my mind when I consider new OS for the RDBMS.

Regards,
Ognjen



In response to

Responses

pgsql-performance by date

Next:From: Justin PittsDate: 2009-04-13 13:42:59
Subject: Re: Postgres 8.x on Windows Server in production
Previous:From: Glyn AstillDate: 2009-04-13 11:49:53
Subject: Re: 2.6.26 kernel and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group