[PERFORM] [offtopic] Problems subscribing to Postgres mailing lists

2010-03-15 Thread Ognjen Blagojevic
e finding the right person for this problem. Regards, Ognjen Blagojevic -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] SATA drives performance

2009-12-24 Thread Ognjen Blagojevic
Richard and others, thank you all for your answers. My comments inline. Richard Neill wrote: > 2. Also, for reads, the more RAM you have, the better (for caching). I'd > suspect that another 8GB of RAM is a better expenditure than a 2nd drive > in many cases. The size of the RAM is already four

[PERFORM] SATA drives performance

2009-12-24 Thread Ognjen Blagojevic
Hi all, I'm trying to figure out which HW configuration with 3 SATA drives is the best in terms of reliability and performance for Postgres database. I'm thinking to connect two drives in RAID 0, and to keep the database (and WAL) on these disks - to improve the write performance of the SATA

Re: [PERFORM] Postgres 8.x on Windows Server in production

2009-04-13 Thread Ognjen Blagojevic
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 da

[PERFORM] Postgres 8.x on Windows Server in production

2009-04-10 Thread Ognjen Blagojevic
Hi all, What are your experiences with Postgres 8.x in production use on Windows Server 2003/2008? Are there any limitations, trade-offs or quirks? My client is accustomed to Windows Server environment, but it seems hard to google good information about these types of installations. Regards