W dniu 19.04.2015 o 20:10, Tim Landscheidt pisze: > Jeremy Baron <[email protected]> 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?
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
