Skip to content
Friday, May 27, 2022

DBA Notes

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

Categories

  • AWS (2)
    • EC2 (1)
  • Docker (7)
  • General (2)
  • Linux (7)
  • MySQL (3)
  • notepad++ (2)
  • Oracle (19)
  • Postgres (53)
    • Index (9)
      • Bloom (1)
      • BRIN (1)
      • BTree (1)
      • GIN (1)
      • GIST (1)
      • Hash (1)
      • RUM (1)
      • SP-Gist (1)
    • pgpool (1)
  • SQL (8)
  • WSL (2)

Category: BRIN

BRIN Index Postgres

Indexes in PostgreSQL (BRIN)

Bulent Soylu October 21, 2021 No Comments brinindexpostgres

BRIN General concept Unlike indexes with which we’ve already got acquainted, the idea of BRIN is to avoid looking through definitely unsuited rows rather than…

View More Indexes in PostgreSQL (BRIN)
Log in

postgres (44)index (10)linux (6)docker (6)oracle (5)tuples (4)vacuum (3)aws (2)notepad++ (2)wsl (2)vim (2)SQL (2)CTE (2)access methods (2)sequential scan (2)concurrency (2)mvcc (2)isolation (2)performance (2)tuple (2)

Recent Posts

  • Export Import statistics with dbms_stats in Oracle
  • Oracle Version Numbers
  • Find password for database link (<= 11.2.0.2)!
  • How to check progress of a long running statistics gathering job
  • Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS

Archives

  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

[s2Member-Security-Badge v="2" /]

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