After trying to explain why moving to PostgreSQL is a good idea, and after outlining some of the most important issues, it is time for me to explain some of the possible options we have to finally get rid of MySQL/MariaDB.
- Title Page
- Copyright and Credits
- About Packt
- Contributors
- Preface
- PostgreSQL Overview
- What is new in PostgreSQL 11.0?
- Summary
- Questions
- Understanding Transactions and Locking
- Making Use of Indexes
- Handling Advanced SQL
- Introducing grouping sets
- Making use of ordered sets
- Understanding hypothetical aggregates
- Utilizing windowing functions and analytics
- Writing your own aggregates
- Summary
- Log Files and System Statistics
- Optimizing Queries for Good Performance
- Learning what the optimizer does
- Understanding execution plans
- Understanding and fixing joins
- Enabling and disabling optimizer settings
- Partitioning data
- Adjusting parameters for good query performance
- Making use of parallel queries
- Introducing JIT compilation
- Summary
- Writing Stored Procedures
- Managing PostgreSQL Security
- Managing network security
- Digging into row-level security – RLS
- Inspecting permissions
- Reassigning objects and dropping users
- Summary
- Questions
- Handling Backup and Recovery
- Making Sense of Backups and Replication
- Deciding on Useful Extensions
- Understanding how extensions work
- Making use of contrib modules
- Using the adminpack module
- Applying bloom filters
- Deploying btree_gist and btree_gin
- Dblink – considering phasing out
- Fetching files with file_fdw
- Inspecting storage using pageinspect
- Investigating caching with pg_buffercache
- Encrypting data with pgcrypto
- Prewarming caches with pg_prewarm
- Inspecting performance with pg_stat_statements
- Inspecting storage with pgstattuple
- Fuzzy searches with pg_trgm
- Connecting to remote servers using postgres_fdw
- Other useful extensions
- Summary
- Troubleshooting PostgreSQL
- Migrating to PostgreSQL
- Migrating SQL statements to PostgreSQL
- Using lateral joins
- Using grouping sets
- Using the WITH clause – common table expressions
- Using the WITH RECURSIVE clause
- Using the FILTER clause
- Using windowing functions
- Using ordered sets – the WITHIN GROUP clause
- Using the TABLESAMPLE clause
- Using limit/offset
- Using OFFSET
- Using temporal tables
- Matching patterns in time series
- Moving from Oracle to PostgreSQL
- Moving from MySQL or MariaDB to PostgreSQL
- Summary
- Migrating SQL statements to PostgreSQL
- Other Books You May Enjoy
Migrating data and schema
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.