Tweet
Tweet

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

Postgres is well loved loved wanted DBMS of the Year

Slide 3

Slide 3 text

App Developers?

Slide 4

Slide 4 text

Some brief history

Slide 5

Slide 5 text

Postgres OPEN SOURCE DATABASE SAME ROOTS AS MANY OTHERS NO SINGLE OWNER RELEASES YEARLY WITH NEW MAJOR RELEASE

Slide 6

Slide 6 text

But why do people love it?

Slide 7

Slide 7 text

Why do developers love it?

Slide 8

Slide 8 text

What’s in the box Feature rich Data types Advanced indexing Full text search Geospatial support JSON Extensions Vast ecosystem

Slide 9

Slide 9 text

Datatypes

Slide 10

Slide 10 text

JSONB

Slide 11

Slide 11 text

INSERT INTO products (name, attributes) VALUES ( 'Geek Love: A Novel’, 'author => "Katherine Dunn", pages => 368, category => fiction’ );

Slide 12

Slide 12 text

INSERT INTO products (name, attributes) VALUES ( 'Geek Love: A Novel’, 'author => "Katherine Dunn", pages => 368, category => fiction’ ); SELECT name, attributes->'author' as author FROM products WHERE attributes->'category' = 'fiction'

Slide 13

Slide 13 text

Datatypes

Slide 14

Slide 14 text

Indexing

Slide 15

Slide 15 text

INSERT INTO products (name, attributes) VALUES ( 'Geek Love: A Novel’, 'author => "Katherine Dunn", pages => 368, category => fiction’ ); SELECT name, attributes->'author' as author FROM products WHERE attributes->'category' = 'fiction'

Slide 16

Slide 16 text

INSERT INTO products (name, attributes) VALUES ( 'Geek Love: A Novel’, 'author => "Katherine Dunn", pages => 368, category => fiction’ ); SELECT name, attributes->'author' as author FROM products WHERE attributes->'category' = 'fiction’; CREATE INDEX idx_products ON products USING gin(attributes);

Slide 17

Slide 17 text

Indexing

Slide 18

Slide 18 text

Extensions

Slide 19

Slide 19 text

Ecosystem

Slide 20

Slide 20 text

Why People Azure Database for PostgreSQL Global reach Security Scale up & out Built-in HA Compliance Intelligent performance Easy ecosystem integration Extension support Extensions JSONB Full text search Geospatial support Rich indexing

Slide 21

Slide 21 text

With Azure Phd not required

Slide 22

Slide 22 text

Postgres the TLDR;

Slide 23

Slide 23 text

Why do enterprises love it?

Slide 24

Slide 24 text

Reliable history

Slide 25

Slide 25 text

Skills you already have DBAs know how to administer Not another thing to learn, lower overhead to bring online Frameworks already work with it Again not a new thing to learn, already works with your tools Easy to hire for Hiring is hard enough, don’t make it harder

Slide 26

Slide 26 text

Reduced total cost of ownership

Slide 27

Slide 27 text

Leveraging Azure Database for PostgreSQL with OpenText

Slide 28

Slide 28 text

Leveraging Azure Database for PostgreSQL with OpenText

Slide 29

Slide 29 text

Postgres for lower TCO Open source meaning no expensive licensing SQL that works well to replace existing SQL applications Not a new shiny type of data store, you already have the skills to support

Slide 30

Slide 30 text

All these build on each other FOR DEVELOPERS: RICH FEATURE SET AND CONTINUAL INNOVATION FOR COMPANIES: ALREADY KNOWN TOOL WITH EXISTING SKILLS FOR ENTERPRISES: ABILITY TO REDUCE COST

Slide 31

Slide 31 text

One more thing

Slide 32

Slide 32 text

Hyperscale (Citus)

Slide 33

Slide 33 text

APPLICATION BEGIN; UPDATE SET WHERE COMMIT; campaigns start_date = '2018-03-17' company_id = 'Pat Co'; METADATA COORDINATOR NODE WORKER NODES W1 W2 W3 … Wn BEGIN; UPDATE Campaigns_2012 SET …; COMMIT; How Hyperscale (Citus) shards Postgres UPDATE

Slide 34

Slide 34 text

How Hyperscale (Citus) scales out Postgres APPLICATION SELECT FROM GROUP BY company_id, avg(spend) AS avg_campaign_spend compaigns company_id; METADATA COORDINATOR NODE WORKER NODES W1 W2 W3 … Wn SELECT company_id sum(spend), count(spend) … FROM campaigns_2009 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2001 … SELECT company_id sum(spend), count(spend) … FROM campaigns_2017 … DISTRIBUTED AGGREGATE

Slide 35

Slide 35 text

On Azure

Slide 36

Slide 36 text

Thanks! FOR DEVELOPERS: RICH FEATURE SET AND CONTINUAL INNOVATION FOR EVERYONE: ALREADY KNOWN TOOL WITH EXISTING SKILLS FOR ENTERPRISES: ABILITY TO REDUCE COST

Slide 37

Slide 37 text

A good newsletter is like a good GIN index. Sign up for the Citus Newsletter