SLIDE 1
Hacking PostgreSQL with Eclipse
Metin Döşlü
metin@citusdata.com
PGCONF.EU 2017
1
Motivation
2
Hacking PostgreSQL with Eclipse Metin Dl metin@citusdata.com - - PowerPoint PPT Presentation
Hacking PostgreSQL with Eclipse Metin Dl metin@citusdata.com - - PowerPoint PPT Presentation
Hacking PostgreSQL with Eclipse Metin Dl metin@citusdata.com PGCONF.EU 2017 1 Motivation Postgres cant do everything You can extend it Eclipse makes it easy 2 Extensions postGIS - Spatial and Geographic objects pg_cron - Run
SLIDE 2
SLIDE 3
Extensions
3
postGIS - Spatial and Geographic objects pg_cron - Run periodic jobs hll - HyperLogLog (approximate distinct count) citus - Scale across multiple machines
SLIDE 4
Personal Story
4
Distributed PostgreSQL PostgreSQL Extension
SLIDE 5
Why Eclipse?
5
Start Fast Easy Navigation Rich Features
SLIDE 6
Demo Outline
6
PostgreSQL Inside Eclipse Walking Around Deep Dive
SLIDE 7
Demo Outline
7
PostgreSQL Inside Eclipse Walking Around Deep Dive
SLIDE 8
Build PostgreSQL
8
./configure CFLAGS=-"O0 -g" make -s -j4 sudo make install
SLIDE 9
Import PostgreSQL into Eclipse
9
File -> Import C/C++ -> Existing Code as Makefile Project Turn off scalability mode (optional)
SLIDE 10
Demo Outline
10
PostgreSQL Inside Eclipse Walking Around Deep Dive
SLIDE 11
Attach GDB
11
select pg_backend_pid(); Debug As -> Debug Configurations C/C++ Attach to Application
SLIDE 12
PostgreSQL Data Structures
12
Variables window p pprint(parse)
printf "%s", pretty_format_node_dump(nodeToString(parse))
Preferences -> C/C++ -> Debug -> GDB -> Check “Show the GDB traces...”
SLIDE 13
Errors
13
errstart() in elog.c if (elevel >= ERROR)
SLIDE 14
Crashes
14
pg_crasher
SLIDE 15
Demo Outline
15
PostgreSQL Inside Eclipse Walking Around Deep Dive
SLIDE 16
Gatekeeper
16
watch
SLIDE 17
Demo Outline
17
PostgreSQL Inside Eclipse Walking Around Deep Dive
SLIDE 18
Summary
18
Postgres can’t do everything You can extend Eclipse makes it easy
SLIDE 19
Hacking PostgreSQL with Eclipse
Metin Döşlü
metin@citusdata.com
PGCONF.EU 2017
19