PostgresConf is the world's largest PostgreSQL conference series, and it is now in China. China PostgreSQL Branch and the PostgresConf organization in the United States, in 2019, has successfully held two major domestic PG ecological conferences - PostgreSQL Open officially entered the international PostgresConf conference sequence this year, and officially changed its name to PostgresConf.CHN. The conference was jointly organized by China OSS Promotion Union(COPU), China PostgreSQL Association, China PostgreSQL Community and PGCentral Foundation. The organization of PostgresConf CHN will further strengthen and strengthen the territory of the PostgresConf global series of conferences and promote the integration of Chinese PG forces into the global PG ecosystem.
Some of our speakers
PivotalSenior Software Engineer
Percona LLCSr. Software Engineer - PostgreSQL Consultant
High Go, Pgpool-IISr. DatabaseArchitect
HighGo SoftwareSr. Sfotware Engineer
Amazon Web Services - Global Delivery Practice - India.Associate Consultant
Officer representative speech from the government. Emphasize the importance of the Open-source Postgres
PostgreSQL is the first relational database which recognized the need of non-atomic data types to support developers of applications from science to Web. Jsonb in Postgres is the attractive feature for modern application developers, who want to work with json documents without sacrificing a strong consistency and ability to use all the power of proven relational technology. Finally, SQL world has recognized the NoSQL and released the new SQL-2016 standard, which includes specification of...
Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index strategy and design. One thing is for sure: not all indexes are appropriate for all circumstances,...
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on high-performance machine because it is set up to use all available resources. PostgreSQL provides mechanisms that allow you to tune your...
The presentation includes the principle of aggregation, the implementation of multi-stage aggregation on greenplum. And how greenplum implement grouping sets. This presentation will delve into how to implement efficient aggregation in a distributed environment, as well as implementations in the query optimizer and executor. The slides link: https://docs.google.com/presentation/d/1nYiU8-Z2omzmeYJvh1EznAPk-KnMfXZNIrBbt2JICfo/edit?usp=sharing
Replication is the process of copying and maintaining database objects, such as tables, in multiple databases that make up a distributed database system. There are various benefits of replication which makes it an important component of any enterprise level database deployment. The main drivers for replication are high availability, performance, load balancing and others. PostgreSQL offers quite a many replication options with each having its own pros and cons. In this talk I will try to...
Pgpool-II has been around to complement PostgreSQL over a decade and provides many features like connection pooling, failover, query caching, load balancing, and HA. High Availability (HA) is very critical to most enterprise application, the clients needs the ability to automatically reconnect with a secondary node when the master nodes goes down. This is where Pgpool-II watchdog feature comes in, the core feature of Pgpool-II provides HA by eliminating the SPOF is the Watchdog. This...
We have quite a lot of tools and services available in the market to migrate applications and databases from enterprise databases (like Oracle, SQLServer, Sybase, etc) to open-source databases. However, many a times, these tools do not do the complete code conversion compatible with the target open source. Manual intervention is necessary and the procedures and functions need to be reviewed line by line and rewritten to provide the same functionality. If database migration is done right,...
Learn how to boost performance 10x and scale to over million transactions per second with in-memory computing. It will be shown how to add speed and scale to your PostgresQL-based applications, APIs and analytics for different use cases. We will discuss when each option makes sense, as well as how to evolve your architecture over time to add the speed, scale, agility and new technologies needed for digital transformation and other initiatives. By the end of this session, you will...