I have a question to test postgresql performance.

I want to do a performance test for postgresql.

Ubuntu 16.04 was installed on the virtual machine to test the postgresqlinsert,update query statement. The point here is to test with the latest version of 9.6. The reason is that with the addition of the Heap Only Tuple (HOT) function of postgresql, the problem of postgresql up to the previous version is It also means to see how much improvement is made.I'm going to test other DBs and compare them later.

The procedure is to install a web server (Nginx), install PHP-FPM, and enter # apt-get install php7.0-pgsql to link php and postgresql to install the module I installed Postgresql 9.6, but when I checked the information through phpinfo(), the postgresql version was installed as 9.5.

The reason I thought of is that #apt-getinstallphp7.0-pgsql If you enter this command, the version is set to 9.5.

I'm asking because I'm curious about the solution in this case.

postgresql database benchmark

2022-09-22 19:23

1 Answers

If you don't have to do it through php7.0-pgsql, try installing the version yourself.

Ubuntu Xenial (16.04)

sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main"
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

2022-09-22 19:23

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656