HTAP Database PostgreSQL Scenario and Performance Testing 13 - (OLTP) String Search - Similar Query
Label
PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing
background
PostgreSQL is a database with a long history, which can be traced back to 1973. It was first awarded by the 2014 Computer Turing Prize winner and the originator of relational database. Michael_Stonebraker PostgreSQL has similar functions, performance, architectur ...
Posted by freejellyfish on Tue, 11 Dec 2018 17:30:08 -0800
Design of Airfare Business Database Architecture (Single Instance 27 million rows/s return) - Aliyun RDS PostgreSQL Best Practice
background
One module of airline ticket business has a data volume of 1 billion +, and the amount of writing, updating and deleting is relatively low. According to KEY query some data, each query returns about 10,000 records.
It is such a simple requirement that the business side finds that reading has become a huge bottleneck, returning 10,000 ...
Posted by brianb on Tue, 11 Dec 2018 03:33:06 -0800
Talk about fail fast of hikari and tomcat jdbc pool
order
This paper mainly studies the fail fast of hikari and tomcat jdbc pool in the case of Midway database hanging.
Experimental code
@Test
public void testDatabaseDownAndUp() throws SQLException, InterruptedException {
LOGGER.info("begin to wait for database down and up");
for(int c=0;c<10;c++){
LOGGER.info("execute:"+(c+1));
...
Posted by alan543 on Tue, 11 Dec 2018 03:18:06 -0800
PostgreSQL NULL value relative position and QUERY optimization - nulls first last, asc desc
Label
PostgreSQL, NULLS FIRST, NULLS LAST, ASC, DESC, default behavior, sort
background
In the database, NULL value refers to the value of UNKNOWN, which does not store any value. When sorting, it is specified by grammar before or after the line with value.
for example
-- Express null In front of the line of value
select * from tbl order b ...
Posted by comicrage on Mon, 10 Dec 2018 18:06:05 -0800