bookmate game
en
Bøger
Hans-Jurgen Schonig

Troubleshooting PostgreSQL

PostgreSQL is a powerful, open source, object-relational database system. PostgreSQL offers many advantages for your company or business over other database systems.
This book is your practical guide to understanding the advanced techniques used to handle complex data and methods to solve issues that you might face while working with PostgreSQL. We will start with discussing the issues that arise at the time of setting up PostgreSQL. The next step will be to decide which data types will be most suitable to the task at hand and optimize performance using the right ones.
We will understand how to deal with transaction locks, fuzzy matches, cursors, joins, and so on. Know the warning signs to look for, and how to avoid the most common issues before they even happen. In addition to that, specific high-level topics such as replication and Point-In-Time-Recovery will be discussed. The entire book is based on PostgreSQL 9.4 and contains up-to-date information.
161 trykte sider
Udgivelsesår
2015
Har du allerede læst den? Hvad synes du om den?
👍👎

Vurderinger

  • Maryna Lysenko 💙💛har delt en vurderingfor 2 år siden
    👍Værd at læse

Citater

  • Maryna Lysenko 💙💛har citeretfor 2 år siden
    To figure out what is going on in the system, the following queries may be useful.
    Find the most time-consuming queries, like this:
    SELECT (SELECT datname
    FROM pg_database
    WHERE dbid = oid),
    query, calls, total_time
    FROM pg_stat_statements AS x
    ORDER BY total_time DESC
  • Maryna Lysenko 💙💛har citeretfor 2 år siden
    SELECT schemaname, relname, n_tup_ins,
    n_tup_upd, n_tup_hot_upd, n_tup_del
    FROM pg_stat_user_tables
    ORDER BY n_tup_upd DESC;
  • Maryna Lysenko 💙💛har citeretfor 2 år siden
    test=# CREATE FUNCTION mysum(int, int)
    RETURNS int AS ' SELECT $1 + $2 '
    LANGUAGE 'sql'

På boghylderne

  • kozlovan77
    Alexey
    • 25
    • 2
  • comcon375511
    Databases
    • 7
fb2epub
Træk og slip dine filer (ikke mere end 5 ad gangen)