DB
-
Remote Dictionary Server(Redis) and Redis Enterprise ClusterDB/InMemory 2019. 8. 25. 08:18
1. Overview An in-memory data structure project implementing a distributed, in-memory key-value database with optional durability. Redis supports different kinds of abstract data structures, such as strings, lists, maps, sets, sorted sets, HyperLogLogs, bitmaps, streams, and spatial indexes. 2. Description 2.1 Differences with other database systems 2.1.1 Can be considered either a store and a c..
-
Explain Query Plan and Query Performance with PostgresDB/RDB 2019. 8. 23. 09:34
1. Overview Let's analyze the query plan with Postgres to enhance performance using explain and analysis. 2. Description 2.1 Optimizer The brain of the database, which interprets queries and determines the fastest method of execution. A single query optimization technique can increase database performance drastically. 2.2 Explain & Analyze 2.2.1 Explain Displaying the execution plan that the Pos..