c 
CSS Wizardry
OCTOBER 16, 2023
Once that time has elapsed, the cache should either revalidate the file with the origin server, or do whatever any additional directives may have instructed it to do. RFC 2616 says of the Expires header: To mark a response as “never expires,” an origin server sends an Expires date approximately one year from the time the response is sent.
Percona
DECEMBER 29, 2022
The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. In this blog post, I will show you a particular example I faced when working with an upgrade exercise using pg_upgrade. for lib in $(psql -qtA pgbench -c"select extname||'.so' Example case.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Percona
DECEMBER 5, 2023
Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. The scenario Service considerations In this exercise, we wanted to perform a major version upgrade from PostgreSQL v12.16 done server stopped 16.
SQL Performance
JULY 1, 2021
There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name , [ Column ] = c. system_type_id <> c.
SQL Performance
APRIL 14, 2021
b FROM L1 AS A CROSS JOIN L1 AS B CROSS JOIN L1 AS C ) INSERT INTO dbo. Scan count 2, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 8, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
Percona
AUGUST 30, 2023
This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),
SQL Performance
OCTOBER 9, 2019
The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!
Expert insights. Personalized for you.
187 
Let's personalize your content