From: | Paul Linehan <linehanp(at)tcd(dot)ie> |
---|---|
To: | |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Compiling PostgreSQL under Windows (for use with R package). |
Date: | 2015-07-27 22:03:42 |
Message-ID: | CAF4RT5Rjv3VRxfzmTiEbq2+xeR6aJ4UmMSFg3QYmMoD0kcYQkg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
I'm a (mature) student and I'm interested in exploring the use
of PostgreSQL with the R statistical programming package.
I'm particularly interested in performance for different statistical
problems (I/O intensive/CPU intensive/RAM intensive) with
different compiler options and/or flags.
I'm also interested in benchmarking with "ordinary" hardware - i.e.
John/Joan Doe's laptop, rather than the normal 512GB RAM/SAN
array systems we nomally read about in benchmarks.
I've just compiled PostgreSQL under "pure" Cygwin and also using
mingw-64. Now, under both of these systems I have been able to
perform basic tests - create database/create table/insert into...
and that's worked fine.
I know that up till (is it a decade now?) recently, PostgreSQL wasn't
the most windows-friendly - Cygwin was mandatory (possibly the
reason why (only for the moment hopefully!) MySQL is the
most popular Open Source database.
Anyway, I'm just wondering am I wasting my time working with
Mingw-64 and and/or Cygwin for PostgreSQL. Should I would just
be better off with the "native" Windows system.
By "native", I mean one compiled using Microsoft Visual C++,
which I understand is the system used for the offcial builds
(http://www.postgresql.org/docs/9.4/static/install-windows.html).
I would be interested in hearing opinions - particularly those with
any references (student dissertation - want something concrete),
so, anyone who wants to weigh in with references, URLs - anything.
Should anyone require any further information, please don't hesitate
to ask.
TIA and rgs,
Paul...
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2015-07-27 22:18:24 | Re: Compiling PostgreSQL under Windows (for use with R package). |
Previous Message | Greg Sabino Mullane | 2015-07-27 12:31:25 | Re: Changing the value of data_directory |