[Labs-l] PostgreSQL or access to GCC

[Jacek Wielemborek]

W dniu 19.04.2015 o 20:10, Tim Landscheidt pisze:
> Jeremy Baron <jeremy at tuxmachine.com> wrote:
> 
>> [...]
> 
>> You first need to request a new project or join an existing project if
>> relevant (normally an option would be tool labs but it sounds like
>> maybe you are too big (billions of records) and anyway you probably
>> can't get postgres in tool labs.
> 
>> postgresql is available in both ubuntu and debian. just a simple apt-get away.
> 
> There is also a Labs-wide PostgreSQL instance used for exam-
> ple by OSM (labsdb1004); access for that is granted on an
> individual basis, though
> (cf. https://phabricator.wikimedia.org/T65382).
> 
> However WMF in general and Wikimedia Labs are heavily geared
> towards MySQL/MariaDB, especially on the administrative
> side, so if there are any problems adding or querying bil-
> lions of records, I think fixes and recommendations will be
> much slower for PostgreSQL databases.  I understand Jacek
> wants to work on IP addresses for which PostgreSQL has dedi-
> cated data types, indexes and other goodness, but I would
> check how much rewriting and performance degrading a move to
> MySQL really would require.
> 
> Tim

I personally could accept slower fixes and recommendations for the time
being - I lurk on #postgresql and know how to get help there, so this
should work for now. Could we agree that I would do research on moving
to MySQL later and for now run the PostgreSQL version of WikiSpy?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150419/fb6fa7f3/attachment-0001.pgp>