Beiträge von Daniela Pressmar

Daniela Pressmar

1 MIN LESEDAUER

0 KOMMENTARE

11.12.2023 –

Java’s legacy date and time API, which includes classes such as „java.util.Date“, „java.util.Calendar“, has been replaced by the newer „java.time“ package introduced in Java 8. The legacy classes have several issues, like properly dealing with timezones. The newer API is more comprehensive, easier to use, and less error-prone.

Daniela Pressmar

1 MIN LESEDAUER

0 KOMMENTARE

11.12.2023 –

Did you know that the Postgres datatype „timestamp with timezone“ is not really saving the timezone information? PostgreSQL converts the value into a UTC value and stores that in the table. But the origin timezone information is lost forever.

Daniela Pressmar

1 MIN LESEDAUER

0 KOMMENTARE

20.10.2023 –

In addition to the post “Alternatives to VACUUM FULL in Postgres”, here is an overview of what is possible within Aurora/RDS AWS.

Daniela Pressmar

4 MIN LESEDAUER

0 KOMMENTARE

16.10.2023 –

If deleted data („dead tuples“) are not purged in time, tables continue to grow. With VACUUM FULL, this space can be freed again. However, this leads to a downtime of the table due to its EXCLUSIVE LOCK. Are there other tools available that support online running?

Daniela Pressmar

6 MIN LESEDAUER

0 KOMMENTARE

10.05.2023 –

There is a table with more than 1 TB size. The task is to shrink this table. But the table data cannot be queried at all. No matter how simple a query is, it is still running after one day. The question is: what is wrong with the table?