Re: [GSoC 2020] Questions About Performance Farm Benchmarks and Website

Hi Kalvin,

On Tue, Mar 03, 2020 at 03:07:13AM -0700, Kalvin Eng wrote:
> Hi there,
>
> I am potentially interested in the performance farm project listed here:
> https://wiki.postgresql.org/wiki/GSoC_2020#Develop_Performance_Farm_Benchmarks_and_Website_.282020.29
>
> I've applied to the pgperffarm mailing list as well, but am waiting for
> moderator approval so I thought this list would be the best to ask about
> the performance farm code.
>
> Here are the questions based on the
> https://git.postgresql.org/gitweb/?p=pgperffarm.git;a=summary repo:
>
> - Why is a front end framework used instead of django templates?

I don't have a good answer for this, primarily because my knowledge on
the difference is weak...

> - Any reason why the server hasn't been containerized?

Simply because no effort has been put into it yet. Are you thinking for
ease of demoing or evaluating?

> - Django 1.11 will no longer be supported in April 2020, is it time to
> move to 2.2 LTS? (
> https://www.djangoproject.com/download/#supported-versions)

We want to match the same version the community infrastructure uses, so
yes, if that's the version they will be on.

> - What have been the issues with authentication integration to
> postgresql.org?

There is a custom authentication module that doesn't work outside of the
community infrastructure, and this project has been developed outside of
the community infrastructure. We haven't come up with a way to bridge
that gap yet.

> - Should the client be turned into a package for package managers (e.g.
> pypi, DPKG, brew, etc.)?

I think that would be a plus.

> - The project description mentions refactoring to Python 3, but it seems
> like that was completed last GSoC?

Yeah, I think that's been squared away...

> - Should the performance visualizations be added again?

Yes, that would good to have.

> I've also looked at past mailing lists for this project, but am interested
> in hearing current insights from the community:
>
> -
> https://www.postgresql-archive.org/GSoC-2019-report-amp-feedback-td6100606.html
> -
> https://www.postgresql-archive.org/GSoC-2019-Proposal-Develop-Performance-Farm-Database-and-Website-td6079058.html
> -
> https://www.postgresql-archive.org/GSoC-Summery-of-pg-performance-farm-td6034578.html
> -
> https://www.postgresql-archive.org/GSOC-18-Performance-Farm-Project-Initialization-Project-td6010380.html
> -
> https://www.postgresql-archive.org/GSOC-18-Performance-Farm-Project-td6008120.html
> - https://www.postgresql-archive.org/performance-test-farm-td4388584.html

Regards,
Mark

--
Mark Wong
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/