Programmer Group

Posgres-xl is a good thing? Why? Posgres-xl is based on postgresql database. Posgres can hoist many databases. It can do oltp, against mysql, mysql has no analysis function function It can make oltp, counterbalance oracle, oracle ecology is weak, can not be real-time It supports json well and competes with mongodb, which is used by fewer and ...

Summary: Labels PostgreSQL, PostGIS, box, grid, pointcloud, pgpointcloud, point aggregation, KNN, auto-driving, auto-distribution, scenes of science fiction movies with unmanned backgrounds are gradually changing from screen to reality with the development of technology. Label PostgreSQL, PostGIS, box, grid, pointcloud, pgpointcl ...

// This article mainly refers to Deco's articles, links: http://blog.163.com/digoal@126/blog/static/163877040201201275922529/ This article by De Ge is very good. I have some explanations in the related function section, especially in the array_upper,array_lower section. The ARRAY type contains several important features dimension In othe ...

Label PostgreSQL, stream replication, master-slave, logical subscription background Origin of stream replication PostgreSQL has supported streaming physical replication since the release of version 9.0 in 2010. Users can build read-only standby through streaming replication (master-standby physical replication, block-level consistency). St ...

Label PostgreSQL, pipelineDB, streaming, independent event correlation, public opinion analysis, real-time status analysis, recursive queries, time series data background People's bodies and machines are similar. With the increase of age, organs are aging, and more and more faults will occur. On the one hand, attention should be paid to main ...

Label PostgreSQL, BRIN block-level index, scanning method, data structure, pages_per_range algorithm background BRIN is a new block-level index interface for PostgreSQL 9.5, which stores the boundary values (maximum, minimum) and other statistical information of the indexed fields at the block level. When a field needs to be retrieved, the w ...

Experience of QL optimization with twists and turns background Recently, I received an SQL tuning task, which performs nearly five seconds in a month of data statistics in the development environment. Originally thought it was a smooth optimization, but I didn't expect that in order to get the best result, it went through twists and turns. ...

fsync (boolean) If this parameter is turned on, the PostgreSQL server will try to ensure that updates are physically written to disk by issuing fsync() system calls or using multiple equivalent methods (see wal_sync_method). This ensures that the database cluster can recover to a consistent state after an operating system or hardware crash. ...

Label PostgreSQL, citus, new objects, new databases, new users background citus is a plug-in of PG. The plug-in mainly deals with ordinary SQL (non-UTILITY) plus HOOK, and uses UDF to create new partitions for tables. If the user wants to execute DDL, then CITUS can not take over, how should it operate? In two cases, one needs to be executed ...

Label PostgreSQL, Arrays, Articles, Random Recommendations, Forums, E-Commerce background Content recommendation is a common requirement, such as forums, e-commerce, news clients, etc. Simpler requirements: Edit some content ID s and generate a list of recommendations. (For example, generate a recommendation list like this every day.) Then r ...