Skip to content
Friday, May 09, 2025

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
  • mongodb
DBA Notes

Categories

  • AWS (9)
  • Docker (7)
  • General (4)
  • Linux (14)
  • mongodb (1)
  • MySQL (10)
  • notepad++ (2)
  • Oracle (90)
  • performance (44)
  • Postgres (92)
  • postgresql (8)
  • SQL (16)
  • Windows (7)

Tag: postgresql

Postgres

Partition an existing table on PostgreSQL

Bulent Soylu March 26, 2023 partitioningpostgrespostgresql

Release after release PostgreSQL is better and better on table partitioning, if you do run a version12 or 13 today you must have a look…

View More Partition an existing table on PostgreSQL
Postgres

Schema vs User (Role) in Postgres

Bulent Soylu December 25, 2021 postgresqlread-only userread-write userschemaschema vs roleuser vs role

In Postgres and Oracle schemas and users (roles) are different entities. When you create a user in Oracle it is a schema at the same…

View More Schema vs User (Role) in Postgres

Posts navigation

Previous page Page 1 … Page 3 Page 4
Log in

oracle (86)postgres (51)performance (37)postgresql (32)index (11)upgrade (9)linux (9)multitenant (7)pdb (6)partitioning (6)docker (6)windows (5)memory (5)mysql (5)replication (5)execution plan (5)aws (5)sql profiles (4)tuples (4)SQL (4)

Recent Posts

  • π—¦π—€π—Ÿ π—€π˜‚π—²π—Ώπ˜† π—˜π˜…π—²π—°π˜‚π˜π—Άπ—Όπ—» 𝗒𝗿𝗱𝗲𝗿!
  • TABLE FRAGMENTATION IN ORACLEΒ DATABASE
  • Configuring Huge Pages for MySQL Server on Red Hat Linux
  • HUGE PAGES AND POSTGRESQL
  • How to configure HugePages for Oracle Database Server

Archives

  • October 2024 (1)
  • August 2024 (1)
  • March 2024 (3)
  • January 2024 (3)
  • December 2023 (7)
  • October 2023 (17)
  • September 2023 (6)
  • August 2023 (23)
  • July 2023 (10)
  • June 2023 (4)
  • May 2023 (11)
  • April 2023 (15)
  • March 2023 (6)
  • February 2023 (2)
  • January 2023 (11)
  • December 2022 (1)
  • August 2022 (3)
  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved