CYBERTEC PostgreSQL Logo

Category: Performance

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Category: Performance. You can go back to all blog posts or take a look into our other categories & tags.

Composite types in PostgreSQL: (func()).* - Hidden performance issues

by Hans-Jürgen Schönig | 04.2017
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.

Checkpoint distance and amount of WAL

by Hans-Jürgen Schönig | 01.2017
Tuning the database server affects the amount of WAL written to disk. Fewer checkpoints are a good idea for bigger databases.

Trying out Postgres Bloom indexes

by CYBERTEC Guest | 12.2016
Let's set up a simple demo to exemplify “fields of application” for Bloom and to also gauge pros/cons/performance in comparison to B-tree.

So what are Bloom indexes for Postgres?

by CYBERTEC Guest | 12.2016
Overview of the Bloom index in PostgreSQL. It's a very useful index method - find out how to use it & how it affects performance.

Parallel queries and SERIALIZABLE transactions

by Hans-Jürgen Schönig | 11.2016
In version 9.6 PostgreSQL introduced parallel queries. The ability to use more than just one CPU core per query is […]

Introducing pg_squeeze - a PostgreSQL extension to auto-rebuild bloated tables

by CYBERTEC Guest | 10.2016
pg_squeeze is a PostgreSQL extension implementing a background worker process that can monitor tables and and rebuild them automatically!

Connection pooling intro - PgBouncer and pgpool-II

by CYBERTEC Guest | 10.2016
Connection pooling in a Postgres context: two products stand out - PgBouncer and pgpool-II. We compared both and give you insights!

The "synchronous_commit" parameter and streaming replication

by CYBERTEC Guest | 09.2016
If you're not yet familiar with the "synchronous_commit" parameter, keep reading. It's one of the most important PostgreSQL parameters.

Will more disks get you better PostgreSQL performance?

by Hans-Jürgen Schönig | 09.2016
Find out whether to buy more hardware to fix performance problems - which are in many cases not caused by bad disk performance.

Walbouncer update - a proxy for selective PostgreSQL physical replication

by CYBERTEC Guest | 08.2016
walbouncer update, now supporting PostgreSQL 14, together with a helper script to build replicas. How-to on the walbouncer set up process.
1 … 11 12 13 14 15 … 17
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram