article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. It’s easy with anydbver and k3d.

C++ 95
article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. If my memory serves me correctly SQL Server started using the ReadFileScatter and WriteFileGather APIs in SQL Server 6.5

Servers 40
Insiders

Sign Up for our Newsletter

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

Trending Sources

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. pt-summary --user=root [?2004l#

Cache 96
article thumbnail

Configuring PostgreSQL and LDAP Using StartTLS

Percona

While trying to be as complete yet succinct as possible, I’m detailing how to enable TLS between a PostgreSQL and the OpenLDAP server. Username accounts, but not passwords, are created on the Postgres server. Both username accounts and passwords are configured on the LDAP server. 0 ldap ldapserver=127.0.0.1

C++ 68
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40
article thumbnail

Getting Started with HTTP/2 and Server Push

Dean Hume

We didn’t change any code, or even make any web performance tweaks - we made the switch and noticed the results immediately. If too many requests are made, it can negatively affect the performance of your web page due to the fact that HTTP/1.1 A lot of the web performance hacks that we currently use are no longer needed!

Servers 40