ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZ
1
*How many years have you been working as a developer?**How long have you been using Postgres?**How do you refer to Postgres?**How did you first find out about Postgres?**What is the main reason you chose to use Postgres over other options?**How would you rate your first experience with Postgres?**How would you rate your ability to connect with the community?**Have you ever contributed to Postgres?**In the past year, what type of Postgres virtual events have you attended?**How would you rate your experience with these events overall?**Which virtual events would you recommend friends and colleagues attend?**What language(s) do you most frequently use to access Postgres?**What database tools/GUIs do you most frequently use with Postgres?**What CLI tools do you most frequently use with Postgres?**Which of these SQL features do you use in your production apps?**Which of these features have you used to organize and access data for your production apps?**What automated failover solution(s) do you use?**How do you deploy Postgres?**How would you classify your Postgres database deployment size?**What cloud provider(s) do you currently use?**Which visualization tool(s) do you use?**What are your top 3 favorite or most frequently used Postgres extension(s)?**Which of the below Postgres extensions are you familiar with?*
(Extensions you've used in the past, present, plan to use in the future)
Citusltreepg\_prewarmpg\_repackpg\_stat\_statementsPostGISPostgres\_fdwSwarm64tablefuncTimescaleDBZomboDB*Do you currently use or have you used any of the following NoSQL databases?**What is your primary geographical location?**What is your current job title (or most accurately fits your job description)?**Do you use Postgres for personal projects?**How would you classify your personal project use case?**Do you use Postgres at work?**How would you classify your professional use case?**Which best describes the industry your organization is in?**How many total employees are in your organization?**How big is your team?**Compared to one year ago, is Postgres being used more or less in your organization?**Bonus questions**We asked about events and code contributions earlier, but how do you engage / interact with the Postgres community?**In your experience, what’s the best thing about the Postgres community / what do you like the most?**In your experience, what’s the most challenging thing about the Postgres community / what do you like the least?**What would make the Postgres community better and/or more welcoming to newcomers? Why?**Have you migrated from a NoSQL database to Postgres or from Postgres to a NoSQL database? If so, why?**Have you migrated to Postgres from another relational database? If so, which one? Why?*
2
20+3-5 yearsPostgresSchoolEcosystem33Yes, once or twiceMeetups3lkC#, Ruby
I don’t use database tools/GUIs, OmniDB
I don’t use CLI tools
Common Table Expressions, Filter clause for aggregates
I haven’t used any of theses
Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
1 TB+Azure, GCPPowerBIkpg\_prewarmCassandra, MongoDBPrefer not to say
Professional Services Specialist
FALSETRUEDashboardingAgriculture5,001-10,00021-50 peopleMoreTRUEas
3
20+1-2 yearsPostgresFriendsSQL53No
I haven’t attended any virtual events
JavaScript or TypeScriptI don’t use database tools/GUIspsqlLateral joinsI haven’t used any of these
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAWSGrafana, PowerBITimescale!TimescaleDB, PostGISMongoDBNorth America
Software Developer / Engineer
TRUEIoT applicationsTRUEDashboardingSoftware / SaaS51-1002-10 peopleAbout the sameTRUEI read TwitterIt has been around forever.It has been around forever.
Welcome younger developers.
NoNo
4
0-53-5 yearsNo preferenceSchoolReliability31No
I haven’t attended any virtual events
SQL, JavaScript or TypeScriptI don’t use database tools/GUIspsql
Common Table Expressions, Lateral joins
JSON/JSONB, Declarative partitioning
PatroniTimescale Cloud< 100 GBAWSGrafana, NetdataPostGISCitus, TimescaleDBElasticsearch, MongoDBNorth America
Software Developer / Engineer
TRUEOtherTRUEApp development, DevOpsSoftware / SaaS11-502-10 peopleMoreFALSE
5
11-1515+ yearsPostgresWork or colleagueCommunity35Yes, several times
Conferences, Meetups, Technical workshops
5
Looks for the Postgres Meetups in your area
C, Go, Python, SQL, Shell scriptsI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Lateral joins, Tablesamples, Window functions
Custom foreign data wrappers, Declarative partitioning, Logical replication, JSON/JSONB, Non-btree indexes, BRIN
Patroni
Timescale Cloud, Self-managed in a private data center, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
1 PB+AWS, DigitalOceanGrafana
TimescaleDB, pg_stat_statements, istore
ltree, pg\_prewarm, pg\_repack, pg\_stat\_statements, Postgres\_fdw, tablefunc, TimescaleDB
Cassandra, Elasticsearch, Redis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEMonitoringTRUEDevOpsSoftware / SaaS51-10011-20 peopleMoreTRUE
Organize conferences and meetups, participate in the mailing lists discussion, submit and review patches
The strong desire to do things properly and openness to all sorts of critique to improve.
Major contributors/committers are typically overworked, with the majority of their time dedicated to work on features/review patches. There is less focus on providing modern development infrastructure (a bugtracker, issue system, CI/CD, community group chats that are mobile friendly), and, IMO as a result, that diminishes the number of new contributors.
Some sort of document describing how the community works and why certain things (i.e the bugtracker, or accepting github pull-requests) is harder than it looks from the outside (and, perhaps, that would make newcomes work on solving the real issues instead of complaining over an over).
I did migrate a redis-based cache to PostgreSQL using logical replication to propagate the data to the worker nodes. One less technology to take care about.
Oracle to Postgres migration, some contract work.
6
11-156-10 yearsPostgreSQLSearch engineEcosystem41Yes, once or twice
I haven’t attended any virtual events
RubyDBeaverpsqlWindow functionsBRINPAF, testingElephantSQL> 1 PBGCPLookertestingTimescaleDB, pg\_repack
I have never used a NoSQL database
North AmericatestingTRUEApp developmentTRUEFinanceConstruction0-10Just meAbout the sameTRUEtestingtestingtesting
7
20+3-5 yearsPostgresWork or colleagueEcosystem32No
Conferences, Meetups, Webinars
4FOSDEMC#, Go, JavaScript or TypeScript, Python, SQL, Shell scriptsAzure Data Studio, DBeaverpsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
BRIN, Event triggers, JSON/JSONB, Procedures (with CALL), Non-btree indexes
Patroni
Timescale Cloud, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), AWS RDS
1 TB - 1 PBAWS, DigitalOcean, GCP
Grafana, Native PG UI tools (e.g., DBeaver, Metabase, pgAdmin), PowerBI
postgis, timescaledb, promscale
Citus, pg\_stat\_statements, PostGIS, postgres\_fdw, tablefunc, TimescaleDB
Cassandra, Elasticsearch, Redis
North AmericaDeveloper AdvocateTRUE
App development, Finance, DevOps, Dashboarding, IoT applications, Monitoring, Real-time analytics, Web analytics
TRUE
App development, Dashboarding, DevOps, Finance, Real-time analytics, Monitoring, IoT applications, SaaS metrics, Web analytics
Software / SaaS51-1002-10 peopleA lot moreTRUETwitter, Slack channels
Large ecosystem, lots of interest and contributions
Slow to change and no specific owner to guide the overall project
Some strong community leaders
Yes, performance and management
Yes, SQL Server. Company mandate
8
0-5Less than 1 yearPGWork or colleagueCommunity33NoWebinars3N/AC, SQLpgAdmin 4psql
I don’t use any SQL features/have production apps
JSON/JSONB, I haven’t used any of these
I don’t use an automated failover solution
Timescale Cloud< 100 GBAWSGrafanaN/aPostGIS
I have never used a NoSQL database
Prefer not to say
Professional Services Specialist
FALSETRUEDashboardingSoftware / SaaS0-10Just meA lot lessFALSE
9
0-51-2 yearsPostgresWork or colleagueLicense33No
I haven’t attended any virtual events
PythonpgAdmin 4, DBeaverpsql
Lateral joins, Window functions, Common Table Expressions
Custom foreign data wrappers, JSON/JSONB
Patroni
Timescale Cloud, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAWS
Grafana, Tableau, Native PG UI tools (e.g., DBeaver, Metabase, pgAdmin)
TimescaleDB, PostGIS
PostGIS, postgres\_fdw, TimescaleDB, ZomboDB, pg\_stat\_statements
MongoDB, Cassandra, RedisNorth AmericaDeveloper AdvocateTRUEDashboardingTRUE
Dashboarding, DevOps, Finance, Real-time analytics, Monitoring, IoT applications, App development, SaaS metrics, Web analytics
Other11-502-10 peopleMoreTRUEYesOpen sourcePeople's egoNot sureScale and TimeSQLServer
10
6-103-5 yearsPostgreSQLWork or colleagueSQL55No
I haven’t attended any virtual events
JavaScript or TypeScript, Java, SQLDatagrip, pgAdmin 4, Posticopsql
Common Table Expressions, Full text search
JSON/JSONB
I don’t use an automated failover solution
AWS RDS, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAWS, DigitalOceanGrafana, pgAdminN/ACitus, TimescaleDB
Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
App development, IoT applications
TRUE
App development, IoT applications
IoT11-5011-20 peopleAbout the sameFALSE
11
20+Less than 1 yearPostgresWork or colleagueUsability43No
I haven’t attended any virtual events
JavaScript or TypeScriptpgAdmin I-III, pgAdmin 4psql
Grouping sets, Window functions
JSON/JSONB
I don’t use an automated failover solution
I haven't done it so far. Most of the time higher ups (seniors) do it
< 100 GBAWSDBeaverxxxltreeRedis, Elasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
FALSETRUE
Monitoring, Web analytics, App development
Software / SaaS11-502-10 peopleMoreFALSE
12
6-106-10 yearsPostgresSchoolEcosystem31No
I haven’t attended any virtual events
Go, Java, SQL, KotlinDatagrip, IntelliJpsql
Common Table Expressions, Lateral joins, Window functions
Custom foreign data wrappers, JSON/JSONB, Logical decoding, Non-btree indexes, Procedures (with CALL)
Patroni
AWS RDS, Timescale Cloud or Timescale Forge, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Heroku Postgres
< 100 GBDigitalOcean, AWSGrafana
TimescaleDB, promscale, pgcrypto
Citus, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB, ZomboDB
Elasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
IoT applications, Dashboarding, App development
TRUEDevOps, MonitoringSoftware / SaaS51-1002-10 peopleMoreTRUE
I don't, I follow a few people on Twitter for news, and mostly interact with the TimescaleDB community
They use a mailing list as the main channel. FFS
Some kind of portal about the project, it's organization, guidelines
NoNo
13
0-51-2 yearsPostgresEvent/meetupEcosystem44No
Webinars, Conferences, Meetups
4Python, SQL, Shell scripts
Datagrip, pgAdmin 4, I don’t use database tools/GUIs
psql
Common Table Expressions, Grouping sets, Window functions, Tablesamples
Custom foreign data wrappers, Event triggers, Logical replication, Non-btree indexes
Patroni, repmgr
AWS RDS, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
1 TB - 1 PBAWSpgAdmin, Grafana
pg_stat_statement, postgis, repmgr
pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEDashboardingTRUE
App development, Finance, SaaS metrics, Web analytics
Software / SaaS0-102-10 peopleA lot moreTRUE
14
6-103-5 yearsPostgresSearch engineReliability53No
Webinars, Technical workshops
4ConferencesC#, Python, JavaAzure Data Studio, pgAdmin 4psql
Common Table Expressions, Filter clause for aggregates, Full text search, Window functions
JSON/JSONB, BRIN, Logical replication, Procedures (with CALL)
repmgr
Azure Postgres, Heroku Postgres, Self-managed on-site
100 - 500 GBAzureGrafana, pgAdmin, Power BI
Timescaledb, pgaudit, postgis
TimescaleDB, postgres\_fdw, PostGIS, pg\_stat\_statements
Elasticsearch, MongoDBSouth AmericaData ArchitectTRUEWeb analyticsTRUE
App development, Dashboarding, IoT applications, Monitoring, Real-time analytics, Web analytics
Energy501-1,0002-10 peopleMoreTRUEMailing listExpertiseNaJira bug tracker
From MongoDB to Postgres because of SQL sintax and connectivity whit the rest of the technologies
From Oracle because of the license costs
15
6-103-5 yearsPGWork or colleaguePerformance53No
I haven’t attended any virtual events
C++I don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Grouping sets
JSON/JSONB, Non-btree indexes, Procedures (with CALL)
I don’t use an automated failover solution
Self-managed on-site< 100 GBAWS, GCPI don’t use visualization toolsN/APostGIS, postgres\_fdwElasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEApp developmentTRUEApp developmentFinance / Crypto / FinTech11-502-10 peopleAbout the sameTRUE
16
16-203-5 yearsPostgresWork or colleagueSQL43No
Conferences, Meetups, Technical workshops, Webinars
4SQL, JavaScript or TypeScript, PythonDatagrippsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Event triggers, JSON/JSONBPatroni
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
1 TB - 1 PBAWSGrafanatimescaledb
TimescaleDB, PostGIS, pg\_stat\_statements
Redis, Cassandra, Elasticsearch
North America
Software Developer / Engineer
FALSETRUE
Dashboarding, Real-time analytics, Monitoring, IoT applications
IoT11-502-10 peopleA lot moreTRUE
Full SQL capabilities; huge eco system; proven platform
not yet; we might move our MySQL databases over soon
17
6-103-5 yearsPostgres
Technical forum (e.g., Stack Overflow, Reddit, DBA Exchange)
Ecosystem43Yes, once or twiceWebinars3Python, SQL, Shell scriptsI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Lateral joins, Window functions
JSON/JSONB, Logical replication, Non-btree indexes
I don’t use an automated failover solution
AWS RDS, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Self-managed in a private data center
1 TB - 1 PBAWSI don’t use visualization toolsTimescaleDB
Citus, pg\_repack, pg\_stat\_statements, PostGIS, TimescaleDB
Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
Other, App development, IoT applications, Monitoring
TRUE
App development, Monitoring, IoT applications, Real-time analytics
Software / SaaS51-1002-10 peopleAbout the sameFALSE
18
20+15+ yearsPostgresusenetUsability33NoConferences4pgconfGo, SQLPosticopsql
Common Table Expressions, Filter clause for aggregates
Custom foreign data wrappers, Declarative partitioning, Event triggers
I don’t use an automated failover solution
AWS RDS, CrunchyBridge, Self-managed on-site
501 GB - 999 GBAWSGrafana
timescale, prometheus_postgres_adapter, pg_audit
pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
ElasticsearchNorth AmericaDatabase AdministratorTRUEApp developmentTRUE
App development, Dashboarding, DevOps, Monitoring, Real-time analytics
Education5,001-10,0002-10 peopleAbout the sameFALSE
19
11-1511-15 yearsPostgreSQLWorkCommunity54Yes, once or twice
Webinars, Technical workshops
5Python, Ruby, Shell scripts, SQLpgAdmin 4, OmniDB, Datagrippsql
Common Table Expressions, Full text search, Filter clause for aggregates, Lateral joins, Window functions, Grouping sets
Custom foreign data wrappers, Event triggers, JSON/JSONB, Logical replication, Non-btree indexes, Procedures (with CALL), Logical decoding, Declarative partitioning
Patroni, repmgr, Stolon, PAFSelf-managed on-site1 TB - 1 PBI don’t use a cloud providerGrafana, Tableau, pgAdminPg_stat_statements
Citus, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw, tablefunc, TimescaleDB
Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Professional Services Specialist
TRUE
App development, DevOps, Dashboarding, Real-time analytics, Web analytics
TRUE
App development, Dashboarding, DevOps, Monitoring, Real-time analytics, Web analytics
Telecommunications501-1,00021-50 peopleMoreTRUE
20
0-51-2 yearsPostgresWork or colleagueSQL52No
I haven’t attended any virtual events
SQL, CpgAdmin 4, Postico, DBeaverpsqlWindow functions
Custom foreign data wrappers, Pluggable table storage, Logical replication
Patroni
Timescale Cloud or Timescale Forge, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Postgres on Aiven.io, AWS RDS
501 GB - 999 GBAWSI don’t use visualization toolsPostGIS, TimescaleDB
Citus, ltree, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
MongoDBNorth America
Software Developer / Engineer
TRUEMonitoringTRUE
App development, Monitoring, Web analytics, SaaS metrics
Software / SaaS51-1002-10 peopleMoreFALSE
21
I'm not a developer1-2 yearsNo preferenceConferenceLicense44Yes, once or twice
Webinars, Conferences
4WebinarSQL
Azure Data Studio, pgAdmin 4, OmniDB
psql
Window functions, Tablesamples, Lateral joins, Grouping sets, Common Table Expressions
I haven’t used any of theserepmgr
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBAzurePower BI, pgAdminPg_stat_statement
pg\_stat\_statements, PostGIS, tablefunc
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEApp development, OtherTRUEApp developmentSoftware / SaaS501-1,00021-50 peopleAbout the sameTRUEUser groupApprochableVery competent people
Yes, because it is intimideting
NoNo
22
6-103-5 yearsPostgresdon't recallUsability44No
I haven’t attended any virtual events
SQLVS Codepgcli
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, Procedures (with CALL), JSON/JSONB
I don’t use an automated failover solution
Timescale Cloud or Timescale Forge, AWS RDS
501 GB - 999 GBAWSI don’t use visualization tools
Timescale, plpgsql, pg_cron
TimescaleDB, tablefunc, postgres\_fdw, pg\_stat\_statements
HBase, MongoDB, RedisNorth AmericaData Science EngineerFALSETRUEIoT applicationsIoT51-1002-10 peopleMoreTRUE
23
I'm not a developer3-5 yearsPostgresConferenceLicense54No
Conferences, Meetups, Webinars
4EDB pgday. and FOSSSQL, Shell scripts, Python
DBeaver, pgAdmin 4, I don’t use database tools/GUIs
psql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins
Declarative partitioning, Logical replication
I don’t use an automated failover solution
AWS RDS, Self-managed in a private data center
1 TB - 1 PBAWSDBeaver, pgAdmincube, earthdistancePostGIS, TimescaleDBElasticsearch, Cassandra
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEDashboardingTRUE
Other, Dashboarding, Web analytics, Finance, DevOps
Other51-1002-10 peopleAbout the sameTRUE
visit conferneces, meetups, nowadays: virtual.
It is easy to participate.cliques.
organize events: confernes, meetups.
no, not a big user of noSQL systems
not yet
24
I'm not a developer6-10 yearsPostgreSQLWork or colleagueReliability54Yes, several timesConferences4SQLI don’t use database tools/GUIspsql
Full text search, Filter clause for aggregates, Common Table Expressions, Lateral joins, Grouping sets, Window functions
BRIN, Custom foreign data wrappers, Declarative partitioning, Event triggers, JSON/JSONB, Logical decoding, Logical replication, Non-btree indexes, Procedures (with CALL)
PAF
Self-managed in a private data center
1 TB - 1 PBI don’t use a cloud providerI don’t use visualization tools
pg_stat_statements, pg_stat_kcache,pg_wait_sampling,powa,pg_qual_stats,pg_wait_sampling
pg\_stat\_statements
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEApp developmentTRUE
App development, Real-time analytics, Web analytics, SaaS metrics, DevOps
Software / SaaS1,001-5,0002-10 peopleA lot moreTRUEpgsql-hackersvery open and friendly
25
16-206-10 yearsPostgresWork or colleague
extended features (e.g. foreign data wrappers)
44Yes, once or twice
I haven’t attended any virtual events
Java, Python, JavaScript or TypeScript, SQLI don’t use database tools/GUIspsql
Common Table Expressions, Lateral joins, Window functions, Filter clause for aggregates
Custom foreign data wrappers, Declarative partitioning, Event triggers, JSON/JSONB
I don’t use an automated failover solution
AWS RDS, Heroku Postgres501 GB - 999 GBAWSsupersetpostgres_fdw, postgis
postgres\_fdw, PostGIS, pg\_stat\_statements, tablefunc
Cassandra, HBase, MongoDB, Redis
North America
staff engineer, with a focus on data architecture, software backends, and reliability
TRUEOther, DashboardingTRUE
IoT applications, Finance, App development, Dashboarding, Monitoring
Other11-502-10 peopleAbout the sameTRUE
I don't, much. I've checked out the Slack and posted to pgsql-hackers a few times
the openness
I don't agree with your framing. Challenges aren't necessarily bad; the community (especially the mailing list) has a pretty high standard of expected effort, and that's a barrier to entry, but it's also what keeps it operating smoothly.
The community has a lot of infrastructure but in terms of information architecture (i.e. library sciences type stuff) it seems to have grown organically, and that makes it hard for newcomers to get their bearings. There are all these little bits and pieces -- the docs, the wiki, the mailing list, the commitfest tracker, the buildfarm (for which someone's recently created a snazzy dashboard, iirc), but it isn't obvious how they're connected and which parts are relevant in which order to whatever goal someone might have. It'd be good to think through that holistically, and to try to define and streamline common paths through it all.
I have replaced Mongo with Postgres multiple times because data models comprising isolated hierarchies aren't as common as other people think
never a production db
26
0-53-5 yearsPostgreSQLSchoolPerformance55NoWebinars5Java, SQL, Shell scripts, C, Python, GoDatagrippsqlLateral joins, Full text searchJSON/JSONBrepmgr, pg\_auto\_failover
Google Cloud PostgreSQL, Azure Postgres
< 100 GBAzurepgAdminpg_cloudCitusMongoDBPrefer not to say
Software Developer / Engineer
TRUEApp developmentTRUEOtherOil & Gas10,000+50+ peopleA lot moreFALSE
27
11-1511-15 yearsPostgresSchoolCommunity55Yes, once or twice
I haven’t attended any virtual events
C, Java, Python, Shell scriptsI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Full text search, Lateral joins, Tablesamples, Window functions
Declarative partitioning, JSON/JSONB, Logical replication, Non-btree indexes
PAF
Heroku Postgres, Self-managed in a private data center, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBDigitalOcean, LinodeGrafana
auto_explain, pg_stat_statements, pg_buffercache
pg\_stat\_statements, ltree, PostGIS, postgres\_fdw, tablefunc
Elasticsearch, RedisSouth AmericaDatabase AdministratorTRUE
DevOps, Finance, Dashboarding
TRUE
DevOps, Finance, Dashboarding
Finance / Crypto / FinTech51-10011-20 peopleAbout the sameTRUEe-mail, irc and telegram
Everyone is very accessible and knowledgeable. It's easy to find someone who can solve an issue.
Third party packagers have a really high time to release new versions, so we get old versions for a long time in cloud providers and even over official repositories of Red Hat, for instance.
Events such as conferences and meetups are really nice. I think we could do with more small/local events, at least in my city.
No, but I always try to solve a problem using postgres first.
Yes, from Oracle several times, but a couple from MSSQL and DB2.
28
I'm not a developer6-10 yearsPostgreSQLWork or colleagueCommunity44NoMeetups4Pg ConfSQL, Shell scriptspsqlpsql
Common Table Expressions, Filter clause for aggregates, Window functions
Custom foreign data wrappers
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
501 GB - 999 GBGCPGrafana, DBeaverN/A
pg\_repack, PostGIS, postgres\_fdw, TimescaleDB
MongoDBSouth AmericaDatabase AdministratorTRUEOtherTRUEApp developmentTransportation51-10011-20 peopleAbout the sameTRUE
29
16-2011-15 yearsPostgresWork or colleagueLicense32No
Conferences, Technical workshops
4PostgresConfBrJava, C#DBeaver, pgAdmin I-IIIpsql
Common Table Expressions, Filter clause for aggregates, Window functions
I haven’t used any of these
I don’t use an automated failover solution
Self-managed in a private data center
1 TB - 1 PBDigitalOceanMetabase, QlikSense
PostGIS, unaccent, pgcrypto
pg\_stat\_statements, PostGIS, postgres\_fdw
HBase, RedisSouth America
Software Developer / Engineer
TRUEApp developmentTRUEOther
Healthcare / Pharmaceuticals
5,001-10,00021-50 peopleAbout the sameTRUETelegramthe people just helpno
Yes. From Oracle because the license prices
30
20+3-5 yearsPostgresFriendsReliability55Yes, once or twiceConferences, Meetups5SQL, PythonDatagrip, pgAdmin 4psql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
BRIN, JSON/JSONB, Logical replication, Non-btree indexes
I don’t use an automated failover solution
Self-managed in a private data center
100 - 500 GBGCPpgAdmin, Grafana, Tableaupg_stat_activity
pg\_stat\_statements, tablefunc
I have never used a NoSQL database
South AmericaDatabase AdministratorFALSETRUE
DevOps, Dashboarding, App development, Finance
Education11-5011-20 peopleA lot moreTRUEhelp on forums
reliability and responsiveness
I don´t have any
Maybe a tutorial for beginners
no
From Firebird, because Postgres is too much better
31
6-103-5 yearsPostgresSearch engineSQL43NoWebinars4SQLDatagrippsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Window functions
JSON/JSONB, Logical replication, Procedures (with CALL)
I don’t use an automated failover solution
Self-managed on-site< 100 GBOracle CloudI don’t use visualization toolspgsql-http, pgcryptoPostGIS
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEApp developmentTRUE
Finance, IoT applications, App development
Finance / Crypto / FinTech0-10Just meMoreTRUEdocumentation is the best
from mysql, at the time mysql was lacking in JSON features
32
11-153-5 yearsPGWork or colleagueACID44No
I haven’t attended any virtual events
Rust, Go, SQLI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, Event triggers, JSON/JSONB, Logical decoding, Logical replication
Patroni
Google Cloud PostgreSQL, Self-managed in a private data center, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Timescale Cloud or Timescale Forge
< 100 GBDigitalOcean, AWS, GCPGrafanaTimescaleDB
PostGIS, postgres\_fdw, TimescaleDB, ZomboDB
Cassandra, Elasticsearch, MongoDB, Redis
North America
Software Developer / Engineer
TRUEOtherTRUEDevOpsSoftware / SaaS51-10011-20 peopleMoreFALSE
33
16-203-5 yearsPostgresWork or colleagueReliability32No
I haven’t attended any virtual events
PythonI don’t use database tools/GUIspsql
I don’t use any SQL features/have production apps
I haven’t used any of thesePatroni
Timescale Cloud or Timescale Forge
< 100 GBAWS, DigitalOceanGrafanaTimescaleDB
TimescaleDB, PostGIS, postgres\_fdw, pg\_stat\_statements
Elasticsearch, MongoDB, Redis
North America
Software Developer / Engineer
TRUEApp developmentTRUE
IoT applications, App development, DevOps
Software / SaaS51-10011-20 peopleMoreTRUELittleDocs
Engaging with closed core developer community, lack of github/modern tooling
Github, issue tracking & modern developer tooling
34
20+6-10 yearsPostgresWork or colleagueReliability23No
I haven’t attended any virtual events
Java, Python, SQLDBeaverpsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Declarative partitioning, Event triggers, Non-btree indexes, Logical replication
pg\_auto\_failoverAWS RDS< 100 GBAWSDBeaver, LookerN/A
pg\_prewarm, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
Cassandra, Elasticsearch, HBase, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software ArchitectTRUE
App development, Dashboarding, Monitoring
TRUEFinanceFinance / Crypto / FinTech101-50011-20 peopleAbout the sameTRUERead blogsMeetups
Keeping the community together
?
Used Posrgres for CRUD backend, migrated some functionality of fast lookups to aerospike to meet sub millisecond response time
MySQL, more reliable
35
20+6-10 yearsPostgreSQLWork or colleaguePerformance55No
Webinars, Conferences, Meetups
5Python, Ruby, SQLpgAdmin 4psql
Common Table Expressions, Lateral joins, Filter clause for aggregates, Grouping sets, Window functions, Tablesamples
Declarative partitioning, Event triggers, JSON/JSONB, Procedures (with CALL)
repmgrSelf-managed on-site< 100 GBI don’t use a cloud providerI don’t use visualization toolsN/Apg\_stat\_statements
MongoDB, Elasticsearch, Redis
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEOtherTRUEOtherEntertainment / Media0-10Just meAbout the sameFALSE
36
I'm not a developer15+ yearsPostgresWork or colleagueTransaction support42No
I haven’t attended any virtual events
Go, Python, Shell scripts, SQLDBeaverpsqlCommon Table ExpressionsEvent triggers, JSON/JSONB
I don’t use an automated failover solution
Timescale Cloud or Timescale Forge, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Self-managed on-site
100 - 500 GBAWS, DigitalOceanDBeaverTimescale
pg\_stat\_statements, TimescaleDB
Cassandra, Elasticsearch, HBase, MongoDB, Redis
North America
Director - Software Engineering
TRUE
App development, Dashboarding, DevOps, IoT applications, Monitoring, SaaS metrics
TRUE
Dashboarding, DevOps, Monitoring
IoT501-1,00021-50 peopleAbout the sameTRUE
Only via the TimescaleDB community
Reluctance to answer questions about older versions
See aboveNoNo
37
20+15+ yearsPostgreSQLSchoolCommunity24Yes, several times
Conferences, Meetups, Webinars
5PGConf BrazilShell scripts, SQL, Go, C, PythonI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Full text search, Grouping sets, Lateral joins, Tablesamples, Window functions
BRIN, Custom foreign data wrappers, Declarative partitioning, Event triggers, JSON/JSONB, Logical decoding, Logical replication, Non-btree indexes, Pluggable table storage, Procedures (with CALL)
Patroni
AWS RDS, Self-managed in a private data center, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Google Cloud PostgreSQL, Azure Postgres
1 TB - 1 PB
AWS, Azure, DigitalOcean, GCP, Oracle Cloud
Grafana, Netdata
pg_stat_statements, auto_explain and pg_repack
Citus, ltree, pg\_prewarm, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw, Swarm64, tablefunc, TimescaleDB, ZomboDB
I have never used a NoSQL database
South America
Software Developer / Engineer
TRUEOther, DevOps, MonitoringTRUEDevOps, Monitoring, OtherOther11-502-10 peopleA lot moreTRUE
I'm a Brazilian PostgreSQL Community leader
Pragmatism
First code contribution can be traumatic... sometimes we're not very welcome with new developers. We should improve it a lot!!!
Use more friendly tools for the development process (like Gitlab, Github, etc), because we're still using mailing lists sending patches attached.
No, I don't use NoSQL!No, I just use Postgres!
38
16-2015+ yearsPostgreSQL
Included in one of the early non-mainstream linux distributions
SQL35Yes, once or twice
Conferences, Meetups, Webinars
3
I'd recommend to either go in person or watch recorded Talks on Youtube
SQL, Shell scriptsPostico, pgAdmin 4psql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, Event triggers, JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
Self-managed on-site100 - 500 GBI don’t use a cloud provider
pgAdmin, I don’t use visualization tools
pg_trgm, btree_gin, hstore, uuid-ossp, pg_stat_statements, postgis, pgcrypto
pg\_prewarm, ltree, pg\_stat\_statements, PostGIS, postgres\_fdw, tablefunc
Redis, CouchDB
EMEA (Europe, Middle East, Africa)
Prefer not to sayTRUEDevOps, IoT applications, OtherTRUEApp development, OtherOther51-1002-10 peopleMoreTRUE
Giving presentations, running conferences, user groups, maintaining distribution, testing and contributing code
very high level of knowledge, inclusive, welcoming
a certain amount of commitment is necessary (not a bad thing!)
a broader understanding of SQL, overview of available tools per topic
39
11-153-5 yearsPGWork or colleagueEcosystem54No
I haven’t attended any virtual events
Java, SQLDBeaverpsql
Common Table Expressions, Filter clause for aggregates, Full text search, Window functions, Lateral joins, Grouping sets
Declarative partitioning, Event triggers, JSON/JSONB, Logical replication, Non-btree indexes, Procedures (with CALL)
Patroni
Self-managed in a private data center
100 - 500 GBI don’t use a cloud providerDBeaver, GrafanaPostgis
Timescaledb
AgensGraph(age)
jdbc_fdw
oracle_fdw
Citus
Citus, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
Elasticsearch, Redis, HBaseAPAC (Asia-Pacific)Software ArchitectTRUEDashboarding, OtherTRUEOtherSoftware / SaaS101-50011-20 peopleA lot moreFALSE
40
16-2011-15 yearsPostgreSQLSchoolPerformance44No
I haven’t attended any virtual events
phpDBeaverpsqlFull text searchJSON/JSONB
I don’t use an automated failover solution
AWS RDS< 100 GBAWSDBeavern/aPostGISRedis, Elasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
FALSETRUE
App development, Monitoring, Dashboarding, Web analytics
Education11-502-10 peopleMoreTRUE......
41
6-103-5 yearsPostgresTechnical blogSQL45No
I haven’t attended any virtual events
Python, SQLI don’t use database tools/GUIspsql
Common Table Expressions, Grouping sets, Window functions
Logical replication
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBAWS, GCPGrafanatimescaledb
Citus, pg\_repack, pg\_stat\_statements, PostGIS, TimescaleDB
Elasticsearch
EMEA (Europe, Middle East, Africa)
DevOps EngineerFALSETRUEIoT applicationsIoT11-502-10 peopleAbout the sameFALSE
42
I'm not a developer3-5 yearsPostgresWork or colleagueReliability35NoWebinars3Shell scriptsI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Full text search, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, Declarative partitioning, JSON/JSONB, Event triggers, Procedures (with CALL)
I don’t use an automated failover solution
AWS RDS, Self-managed in a private data center, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
501 GB - 999 GBAWSI don’t use visualization toolspg_stat_statements
pg_buffercache
pg_repack
pg\_repack, pg\_stat\_statements
I have never used a NoSQL database
APAC (Asia-Pacific)Database AdministratorFALSETRUE
App development, Dashboarding, DevOps, Finance, Monitoring, Real-time analytics
Finance / Crypto / FinTech501-1,000Just meAbout the same
43
6-103-5 yearsPostgresFriendsPerformance34No
I haven’t attended any virtual events
JavaScript or TypeScript, Python, SQLI don’t use database tools/GUIspsql
Lateral joins, Window functions, Common Table Expressions
Logical replication, JSON/JSONB
Patroni
Google Cloud PostgreSQL, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBGCPGrafanaTimescaleDBTimescaleDBElasticsearch, Redis
EMEA (Europe, Middle East, Africa)
DevOps EngineerTRUE
Dashboarding, Finance, Monitoring, DevOps
TRUEDevOps, Real-time analyticsFinance / Crypto / FinTech51-1002-10 peopleA lot moreTRUEStackOverflowDocumentation
Reliability, consistency, performance
44
20+6-10 yearsPostgreSQLTechnical blogUsability44NoWebinars3Python, JavaScript or TypeScript, Java, SQLDBeaverpsql
Common Table Expressions, Filter clause for aggregates, Full text search, Window functions
Event triggers, Non-btree indexes, BRIN
I don’t use an automated failover solution
Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBI don’t use a cloud providerMetabasehstore, postgis
PostGIS, postgres\_fdw, pg\_stat\_statements
Cassandra, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software ArchitectTRUEApp developmentTRUEApp developmentFinance / Crypto / FinTech1,001-5,000Just meAbout the sameTRUE
45
6-103-5 yearsPostgresWork or colleagueEverything together52NoMeetups4PG meetupPython, Shell scripts, SQLDatagrip, IntelliJpsql
Common Table Expressions, Filter clause for aggregates, Lateral joins, Window functions
BRIN, Custom foreign data wrappers, Declarative partitioning, Event triggers, JSON/JSONB, Non-btree indexes, Procedures (with CALL)
I don’t use an automated failover solution
AWS RDS, Postgres on Aiven.io
100 - 500 GBAWSMetabase, Power BI, Tableau
cstore_fwd (future: citus), hll, pg_stats_statements
Citus, pg\_stat\_statements, postgres\_fdw
Lotus Notes :-)
EMEA (Europe, Middle East, Africa)
Data Engineer/BITRUEDashboardingTRUE
Dashboarding, Other, Real-time analytics, Web analytics, Finance
Software / SaaS101-5002-10 peopleAbout the sameTRUETwitter
Usually there is already a solution somewhere
Bugs in postgresql are hard to submit as there is no easy bugtracker
-nono
46
11-156-10 yearsPostgresSchoolUsability35Yes, once or twice
I haven’t attended any virtual events
Python, C#, SQL, Shell scriptsDBeaverpgcli
Common Table Expressions, Filter clause for aggregates, Lateral joins, Window functions
BRIN, Custom foreign data wrappers, Declarative partitioning, Event triggers, JSON/JSONB, Non-btree indexes, Pluggable table storage, Procedures (with CALL)
I don’t use an automated failover solution
Postgres on Aiven.io, Self-managed in a private data center, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Timescale Cloud or Timescale Forge
1 TB - 1 PBAzure, GCP, AWS, ScalewayLooker, Metabase, Tableau
postgres-hll, postgres-cstore, multicorn
postgres\_fdw, Citus, TimescaleDB
Elasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEFinanceTRUEDevOps, App developmentSoftware / SaaS101-5002-10 peopleLessFALSE
47
20+15+ yearsPostgresWork or colleagueReliability42No
I haven’t attended any virtual events
Java, PythonI don’t use database tools/GUIspsqlFull text searchEvent triggers, JSON/JSONB
I don’t use an automated failover solution
AWS RDS, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAzure, AWSI don’t use visualization toolsPostgisPostGIS, TimescaleDB
Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software ArchitectTRUEApp developmentTRUEApp developmentFinance / Crypto / FinTech11-502-10 peopleMoreTRUE
Attention to standards and correctness
Ease of use of some tooling
NaNoNo
48
0-53-5 yearsPostgreSQLWork or colleagueLicense25No
Webinars, Conferences
5
Postgres Build 2020
FOSDEM Postgres Dev Room
Python, SQL, Shell scriptsDBeaver, OmniDB, pgAdmin 4psql
I don’t use any SQL features/have production apps
I haven’t used any of theseEFM
Virtual server RHEL in private datacenter
501 GB - 999 GBI don’t use a cloud providerpgAdmin, DBeaverPostgis, postgres_fdw
Citus, pg\_prewarm, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw
Elasticsearch
EMEA (Europe, Middle East, Africa)
Database AdministratorFALSETRUEApp developmentPrefer not to say10,000+2-10 peopleMoreTRUE
Advocating on Twitter and LinkedIn
Sharing experience
Nothing, really easy to get in communication with community
Nothing
no, I'm coming from Oracle world
Yes, From Oracle.
For the community and it's Open Source
49
I'm not a developer15+ yearsPostgreSQLTechnical blogCommunity55NoMeetups, Conferences4FosdemPythonDBeaverpsql
Common Table Expressions, Filter clause for aggregates
JSON/JSONB, BRINPatroni
Self-managed in a private data center, Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBVultrGrafana
plpgsql,pg_stat_statements,pgaudit
pg\_repack, pg\_stat\_statements, postgres\_fdw
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEOtherTRUEDevOpsOther0-10Just meAbout the sameTRUE
community channels, telegram mostly
friendly, open, with good attitude to get things done
too much fragmentation, the lack of a community endorsed professional certification
noMySQL, performance issues
50
0-511-15 yearsNo preferenceWork or colleagueEcosystem44No
Conferences, Meetups, Webinars
4
All of them. (Nothing is better than real life meetings but in the meantime...)
Shell scripts, SQLI don’t use database tools/GUIspsql
Common Table Expressions, Lateral joins
I haven’t used any of thesePAF, PatroniSelf-managed on-site1 TB - 1 PBVMwareI don’t use visualization tools
pg_stat_statements, powa
pg\_prewarm, pg\_stat\_statements
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUEMonitoringTRUEOther, Monitoring, DevOpsSoftware / SaaS101-5002-10 peopleAbout the sameFALSE
51
11-156-10 yearsPostgresWork or colleagueReliability33No
I haven’t attended any virtual events
RubyI don’t use database tools/GUIspgcliFull text search, Lateral joins
JSON/JSONB, Custom foreign data wrappers
Patroni, Stolon
Heroku Postgres, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAWS, GCPGrafanaTimescaleTimescaleDBRedisSouth AmericaDevOps EngineerTRUE
DevOps, App development, Real-time analytics
TRUEDevOpsOther11-5011-20 peopleAbout the sameFALSE
52
6-103-5 yearsPostgresSchoolPerformance43No
I haven’t attended any virtual events
Ruby, SQLPostico, pgAdmin 4psqlFull text searchJSON/JSONB
I don’t use an automated failover solution
Heroku Postgres< 100 GBAWSpgAdmin, MetabasePostgisPostGISElasticsearch, RedisSouth America
Software Developer / Engineer
TRUEApp developmentTRUEApp developmentSoftware / SaaS51-10021-50 peopleMoreFALSE
53
0-53-5 yearsPostgresWork or colleagueReliability34No
Conferences, Meetups, Webinars
3ElixirConf US
Elixir Brasil
SQLDatagrippgcli
Full text search, Window functions, Common Table Expressions
Declarative partitioning, JSON/JSONB, Logical replication
I don’t use an automated failover solution
AWS RDS, Heroku Postgres, Postgres on Aiven.io
100 - 500 GBAWS, DigitalOceanGrafana, MetabasePostGIS, pgcrypto, ltree
ltree, pg\_stat\_statements, PostGIS, Citus
RedisSouth America
Software Developer / Engineer
TRUE
Dashboarding, App development, Monitoring, Other
TRUE
Dashboarding, Real-time analytics, Monitoring, IoT applications, SaaS metrics
Software / SaaS11-502-10 peopleMoreTRUEOn Telegram groupsExpertise, friendliness
Sometimes lack of examples
More beginners materialNo.No.
54
0-51-2 yearsPostgresWork or colleagueUsability54No
I haven’t attended any virtual events
JavaScript or TypeScript, RustAzure Data Studio, DBeaverpsql
Common Table Expressions, Full text search, Grouping sets, Lateral joins
Event triggers, JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
Self-managed on-site< 100 GBI don’t use a cloud providerI don’t use visualization toolsuuidCitus, TimescaleDBRethinkDB
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
App development, Web analytics, Other
TRUEApp developmentSoftware / SaaS0-102-10 peopleMoreTRUE
55
11-151-2 yearsPostgreSQLTechnical blogLicense55No
Webinars, Conferences
4SQLDBeaverpsql
Common Table Expressions, Grouping sets
Custom foreign data wrappers, JSON/JSONB, Logical replication, Procedures (with CALL)
pg\_auto\_failoverSelf-managed on-site501 GB - 999 GBI don’t use a cloud providerDBeaver, Metabasetimescaledb
Citus, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
MongoDB
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
FALSETRUEMonitoring, IoT applicationsTelecommunications11-502-10 peopleMoreTRUEResponsivnessNo
From Oracle because of license and oracle is very frustating
56
6-103-5 yearsPostgresSearch engineReliability54NoWebinars4Timescale webinarsJavapgAdmin 4psqlCommon Table Expressions
JSON/JSONB, Declarative partitioning, Logical decoding
I don’t use an automated failover solution
Self-managed in a private data center, Self-managed on-site
1 TB - 1 PBI don’t use a cloud providerpgAdmin, Grafana
pg_stat_statements, timescaledb, postgis
pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
Elasticsearch, HBase, Redis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEApp developmentTRUEApp developmentEnergy5,001-10,00011-20 peopleAbout the sameTRUEnewsletters, hackernewshigh quality documentationN/AN/Anono
57
0-53-5 yearsPostgresWork or colleagueUsability34NoTechnical workshops4SQL, Python, CpgAdmin 4psql
I don’t use any SQL features/have production apps
I haven’t used any of these
I don’t use an automated failover solution
Self-managed on-site501 GB - 999 GBVMwareGrafana, pgAdminTimescale
pg\_stat\_statements, TimescaleDB
Redis, Elasticsearch, Cassandra
EMEA (Europe, Middle East, Africa)
Information Technologies / Systems Engineer
TRUEIoT applicationsTRUE
Dashboarding, Monitoring, DevOps
Manufacturing1,001-5,0002-10 peopleMoreFALSE
58
6-101-2 yearsNo preference
Technical forum (e.g., Stack Overflow, Reddit, DBA Exchange)
Usability53No
I haven’t attended any virtual events
Java, SQL, Shell scriptsDBeaverpsql
Filter clause for aggregates, Common Table Expressions, Window functions, Grouping sets
BRIN, JSON/JSONB, Logical replication, Procedures (with CALL)
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBGCPMetabasepostgis
PostGIS, pg\_stat\_statements, TimescaleDB
Elasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
FALSETRUEIoT applicationsIoT11-502-10 peopleAbout the sameTRUE
I think the postgres community should rethink the tools it uses. Everything including code review seems to be exchange via mailing lists. This is very old school and inefficient. Postgres should embrace more modern tools to welcome new contributors that don't have the time to deal which such inefficient tools like email. The code itlsef should be migrated to a git repository on Github or Gitlab. The issues and code review , bug reports should be handled in a proper issue tracker. Right now without these modern tools, I don't really see how a newcomer will be motivated enough to invest the time it takes to be introduced in the old school community.
On stackoverflow there are many good answers. On the technical blogs we find a lot of information. The official documentation is also really well made.
Code should be migrated to github or gitlab. The community should use a proper ticker tracker like any other project does and drop the old school mailing lists progressively, or use them only for announcements purposes.
Again : code on gitlab/github, proper project/ticket tracker tool, drop the mailing lists
not migrated, I used both when appropriate
I also use Mysql. But for new projects I prefer to use PG because it's much more performant and has very useful features which are lacking in mysql
59
0-53-5 yearsPostgresSearch engineLicense33No
I haven’t attended any virtual events
PythonpgAdmin 4I don’t use CLI tools
Common Table Expressions, Window functions
I haven’t used any of these
I don’t use an automated failover solution
Self-managed on-site< 100 GBI don’t use a cloud providerGrafanaTimescale
Citus, pg\_stat\_statements, PostGIS, TimescaleDB, tablefunc
MongoDBNorth America
Software Developer / Engineer
FALSETRUE
Dashboarding, IoT applications, Monitoring, Real-time analytics
Manufacturing101-5002-10 peopleMoreTRUE
60
16-201-2 yearsPostgreSQL
Technical forum (e.g., Stack Overflow, Reddit, DBA Exchange)
Only DB supported by many systems
43No
I haven’t attended any virtual events
Only used by installed tools (grafana, FROST-server, odoo)I don’t use database tools/GUIspsql
Production apps are not developed in-house
JSON/JSONBAWS RDSAWS RDS< 100 GBAWSGrafanapostgisPostGIS, TimescaleDB
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
CTOFALSETRUE
Dashboarding, IoT applications, Real-time analytics
IoT0-102-10 peopleMoreTRUE
official doc and stackoverflow
many users, easy to find answers to questions
hard to evaluate extension quality
Not sureNoNo
61
20+15+ yearsPostgreSQLWork or colleagueLicense43No
I haven’t attended any virtual events
Python, Ruby
pgAdmin I-III, pgAdmin 4, I don’t use database tools/GUIs
psql
I don’t use any SQL features/have production apps
Procedures (with CALL)
I don’t use an automated failover solution
Self-managed on-site< 100 GBI don’t use a cloud providerI don’t use visualization toolsPostGISPostGIS
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEApp developmentTRUEWeb analyticsSoftware / SaaS10,000+11-20 peopleAbout the sameFALSE
62
6-103-5 yearsPostgresTechnical blogEcosystem44No
I haven’t attended any virtual events
Ruby, SQLI don’t use database tools/GUIspsql
Window functions, Lateral joins, Grouping sets, Full text search, Filter clause for aggregates, Common Table Expressions
JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
Self-managed on-site, Self-managed in a private data center
100 - 500 GBUCloudMetabasetimescaledb,rum,zhparser
TimescaleDB, pg\_stat\_statements, ltree
RedisAPAC (Asia-Pacific)
Software Developer / Engineer
TRUE
App development, Dashboarding, Finance, Real-time analytics, Monitoring, SaaS metrics, Web analytics
TRUE
App development, Dashboarding, Real-time analytics, Monitoring, Web analytics, SaaS metrics
Software / SaaS0-10Just meMoreTRUE
63
20+6-10 yearsPostgreSQLWork or colleagueReliability53No
I haven’t attended any virtual events
Ruby, Python, Go, RustI don’t use database tools/GUIspgcli
Window functions, Full text search, Common Table Expressions
Event triggers, JSON/JSONB, Logical replication, Non-btree indexes, Pluggable table storage, Custom foreign data wrappers, Declarative partitioning
I don’t use an automated failover solution
Self-managed in a private data center
1 TB - 1 PBDigitalOcean, AzureNetdata, Grafana, MetabaseTimescale, plpython
pg\_stat\_statements, PostGIS, TimescaleDB, ZomboDB, Citus, postgres\_fdw
Redis, ElasticsearchNorth AmericaDevOps EngineerTRUE
DevOps, App development, Dashboarding
TRUE
App development, Dashboarding, DevOps, Monitoring, IoT applications, Real-time analytics
Entertainment / Media501-1,0002-10 peopleMoreTRUEIRC on Freenode, or Reddit
I don't really have a strong opinion about the community.
I don't really have a strong opinion about the community.
Other communities that I really enjoy being a part of have a slack that I'm involved in, including rust, golang and a couple of DevOps slacks.
No, PG all the way.No, PG all the way.
64
11-153-5 yearsPostgresWork or colleague
chosen by supplier because of JSONB-support
44NoWebinars4SQLDatagripI don’t use CLI tools
Common Table Expressions, Filter clause for aggregates, Lateral joins, Window functions
JSON/JSONBnot sure, managed platformsupplier-managed on-site100 - 500 GBI don’t use a cloud providerI don’t use visualization toolstablefunc
PostGIS, pg\_stat\_statements, tablefunc
MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Project ManagerTRUEOtherTRUEDashboarding, Other
Healthcare / Pharmaceuticals
1,001-5,000Just meAbout the sameTRUEdon't really
good documentation, many resources
very opinionated
planning to move private project from MongoDB to Postgres
site and data model are becoming more complex, it's getting hard to maintain data integrity
65
20+15+ yearsNo preferenceWork or colleagueLicense54No
I haven’t attended any virtual events
JavaScript or TypeScriptpgAdmin 4I don’t use CLI tools
I don’t use any SQL features/have production apps
JSON/JSONB
I don’t use an automated failover solution
AWS RDS< 100 GBAWSI don’t use visualization toolsjson/jsonbPostGIS, TimescaleDB
Redis, MongoDB, Elasticsearch
North AmericaSoftware ArchitectTRUEOtherTRUE
App development, Dashboarding, DevOps, Monitoring, IoT applications, Real-time analytics
Energy11-502-10 peopleAbout the sameTRUEI don't.Stackoverflow
66
20+15+ yearsPostgresWork or colleagueReliability45No
I haven’t attended any virtual events
JavaPostico, pgAdmin 4psql
Common Table Expressions, Filter clause for aggregates, Full text search, Lateral joins, Window functions, Grouping sets
JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Self-managed on-site
100 - 500 GBAWSGrafana
citext, pgcrypto, timescaledb
pg\_stat\_statements, TimescaleDB, Citus, pg\_repack
I have never used a NoSQL database
APAC (Asia-Pacific)
Software Developer / Engineer
TRUEApp developmentTRUE
App development, IoT applications
Energy0-102-10 peopleAbout the sameTRUEEmail, Slack
Generally helpful, with access to long-time top contributors.
Tuning clusters for optimal performance: not feeling that I've
got all the tuning parameters quite perfect.
I think it's pretty welcoming as it is.
I have migrated MySQL databases to Postgres, for better reliability and
better SQL features.
67
0-53-5 yearsPostgreSQL
Through my education and software review
Usability55No
Webinars, Technical workshops
5C, C#, JavaScript or TypeScript, SQL, Python, Node.jsDatagrippsql
Common Table Expressions, Grouping sets, Lateral joins, Tablesamples, Window functions
Event triggers
I don’t use an automated failover solution
Azure Postgres1 TB - 1 PBAzureGrafanaTimescaleDB, tablefunc,
tablefunc, TimescaleDB, pg\_stat\_statements, Citus
HBase, MongoDB, Elasticsearch
EMEA (Europe, Middle East, Africa)
Manager Data and Technology
TRUE
IoT applications, Monitoring, DevOps, Dashboarding, Real-time analytics
TRUE
DevOps, Dashboarding, IoT applications, Monitoring, Real-time analytics
Oil & Gas501-1,0002-10 peopleA lot moreTRUE
The basics, we debug and fact-check over stackoverflow. We are also involved in the Slack channel of e.g. TimescaleDB
For one I think that the community is really critical of how the DB should work, sometimes redesigning features. Also the compliance to SQL itself is great. Lastly, we havent yet came across a truly unique problem that was not recorded and resolved somewhere on the internet. Its soo ubiquitous
Nothing to comment here. I think where postgres needs to grow is in building trust with professional organisations. I see in my own organisation that we use the crap of Microsoft, only because they can 'buy' it somwhere. Open-source software is deemed lesser, just because it doesnt have a central marketing strategy. I was able to overcome this issue within my own unit, but it is difficult to share this with other developers.
nothing to comment
Yes, we used CosmosDB. it was the worst DB experience of my life, as this database is build like a stack and was used for data-warehousing. It was expensive, slow and horrible. Without the basic SQL engine, the DB had no real query methods, making it necessary to add logic post-query over python.
Yes, we had a Azure SQL database. This didnt work very well, was crazy expensive and has a poor SQL syntax. The fact that Azure SQL is a subset of T-SQL makes documentation also useless, as T-SQL is wel documented but only partly supported in Azure SQL.
68
6-106-10 yearsPostgresTechnical blogPostGIS32No
I haven’t attended any virtual events
Python, SQLTablePlusI don’t use CLI tools
Common Table Expressions, Grouping sets, Lateral joins, Window functions
Non-btree indexes
I don’t use an automated failover solution
Azure Postgres501 GB - 999 GBAzureGrafanaTimescale
PostGIS
pg_crypto
ltree, PostGIS, TimescaleDB
Neo4jAPAC (Asia-Pacific)Data EngineerTRUEDashboarding, IoT applicationsTRUE
App development, Dashboarding, IoT applications, Real-time analytics
Mining1,001-5,0002-10 peopleMoreTRUEPodcastsFriendlyOld mailing lists
More real time communication tool like Discord
NoNo
69
6-103-5 yearsPostgreSQLSearch enginePerformance31No
I haven’t attended any virtual events
PHPpgAdmin 4psqlFull text searchJSON/JSONB
I don’t use an automated failover solution
Self-managed on-site1 TB - 1 PBAWS, DigitalOcean, In HouseGrafana, pgAdminTimescale
Citus, postgres\_fdw, Swarm64, TimescaleDB, pg\_stat\_statements
RedisAPAC (Asia-Pacific)
Software Developer / Engineer
TRUE
App development, Dashboarding, SaaS metrics, Web analytics, Monitoring
TRUE
App development, Dashboarding, SaaS metrics, Web analytics, Monitoring
Software / SaaS0-10Just meAbout the sameFALSE
70
16-203-5 yearsPostgresTechnical blogReliability44NoWebinars4phppgAdmin 4I don’t use CLI tools
Common Table Expressions, Grouping sets, Lateral joins, Filter clause for aggregates
JSON/JSONBPatroni
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
501 GB - 999 GBOVHI don’t use visualization toolsN/Altree, PostGISRedis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
FALSETRUEIoT applicationsIoT0-102-10 peopleAbout the sameTRUE
71
I'm not a developer3-5 yearsPostgreSQLWork or colleagueUsability44No
Webinars, Conferences, Technical workshops
4Postgres VisionSQL, Python, Java, CDBeaver, pgAdmin 4psql
Filter clause for aggregates, Common Table Expressions, Grouping sets, Lateral joins, Window functions
BRIN, Declarative partitioningPEM
Self-managed in a private data center, Self-managed on-site
100 - 500 GBOracle Cloud, AWSDBeaver, pgAdminN/aPostGIS, Swarm64Cassandra, MongoDB
EMEA (Europe, Middle East, Africa)
Database AdministratorFALSETRUE
Finance, IoT applications, Real-time analytics, SaaS metrics
Software / SaaS11-502-10 peopleMoreFALSE
72
I'm not a developerLess than 1 yearPostgreSQLSearch engineEcosystem22No
I haven’t attended any virtual events
zabbixpgAdmin 4psqlzabbixI haven’t used any of these
I don’t use an automated failover solution
Self-managed on-site, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBAlibaba CloudGrafana, pgAdmintimescaledb
TimescaleDB, pg\_stat\_statements
Elasticsearch, HBase, RedisAPAC (Asia-Pacific)
Information Technologies / Systems Engineer
FALSETRUEMonitoringSoftware / SaaS501-1,0002-10 peopleA lot lessTRUEn/azabbix performance
Some configuration parameters in the official documents are not fully explained, and how to adjust the monitoring items which have high values
Well-known projects, such as zabbix gitlab, defeat mysql!
nomysql,zabbix performance
73
0-53-5 yearsPostgresFriendsReliability32No
I haven’t attended any virtual events
GopgAdmin 4psql
Lateral joins, Window functions
JSON/JSONBPatroni
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
< 100 GBDigitalOceanGrafana, pgAdminTimescale, postgis, uuidPostGIS, TimescaleDBElasticsearch, Redis
EMEA (Europe, Middle East, Africa)
Software ArchitectTRUE
App development, Monitoring, Other
TRUE
App development, Monitoring, Other
Software / SaaS0-102-10 peopleLessFALSE
74
0-51-2 yearsPostgreSQLTechnical blogReliability44No
I haven’t attended any virtual events
Python, Shell scripts, SQLpgAdmin 4psql
Lateral joins, Common Table Expressions
I haven’t used any of these
I don’t use an automated failover solution
Self-managed in a private data center, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
501 GB - 999 GBDigitalOceanGrafanaTimescaleDBTimescaleDB
I have never used a NoSQL database
North America
Software Developer / Engineer
TRUEIoT applicationsFALSEFALSE
75
6-103-5 yearsPostgresWork or colleagueEcosystem43Yes, once or twiceConferences, Meetups3PgConf.Russia
HighLoad++
#RuPostgres
Java, SQLpgAdmin 4psql
Common Table Expressions, Window functions, Filter clause for aggregates, Lateral joins
Procedures (with CALL), Non-btree indexes, JSON/JSONB, Event triggers, Custom foreign data wrappers, Declarative partitioning
I don’t use an automated failover solution
Self-managed in a private data center
1 TB - 1 PBI don’t use a cloud providerGrafana, pgAdminTimescaleDB
PostGIS
Citus, ltree, pg\_prewarm, pg\_repack, pg\_stat\_statements, PostGIS, TimescaleDB, ZomboDB, postgres\_fdw
Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Chief Technical OfficerTRUE
App development, Dashboarding, DevOps, IoT applications, Monitoring
TRUE
Real-time analytics, IoT applications
Transportation11-502-10 peopleAbout the sameTRUE
76
0-51-2 yearsPGSearch engineEcosystem55No
I haven’t attended any virtual events
Python, JavaScript or TypeScript, Shell scripts, SQLDBeaver, Posticopsql
Common Table Expressions, Full text search, Filter clause for aggregates, Grouping sets, Lateral joins
JSON/JSONB
I don’t use an automated failover solution
Self-managed on-site100 - 500 GBDigitalOcean, AWS, GCPDBeaver, TableauN/A ✅
Citus, postgres\_fdw, Swarm64, TimescaleDB, ZomboDB
Redis, Elasticsearch
EMEA (Europe, Middle East, Africa)
CTOFALSETRUE
Real-time analytics, Dashboarding, Monitoring, SaaS metrics, DevOps
Software / SaaS0-102-10 peopleA lot moreFALSE
77
I'm not a developer15+ yearsPostgresWork or colleaguePhilosophy44Yes, several times
Conferences, Webinars
3SQL, Shell scriptspsqlpsql
Common Table Expressions, Filter clause for aggregates
JSON/JSONB, Custom foreign data wrappers, Non-btree indexes, Logical replication
I don’t use an automated failover solution
AWS RDS, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
1 TB - 1 PBAWS, GCPGrafana
pg_stat_statements, auto_explain
Citus, pg\_prewarm, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw
Redis, Elasticsearch, Cassandra
North AmericaPrefer not to sayTRUEApp development, OtherTRUE
App development, Dashboarding, DevOps, IoT applications, Monitoring, Other
Other101-50011-20 peopleMoreTRUE
Community slack, twitter, irc, mailing lists
Friendly people willing to help answer questions when you get stuck.
Navigating strong philosophical opinions masquerading as technical opinions
It seems hard for Windows users to get troubleshooting help. Also an open source gui solution on par with OEM or SSMS (the current options just aren't there)
Moved specific things like text search into elastic when it outgrew our capabilities as an integrated solution.
Oracle due to cost, MySQL due to correctness.
78
11-156-10 yearsPostgresTechnical blogReliability43No
I haven’t attended any virtual events
Python, JavaDatagrip, DBeaverpsql
Filter clause for aggregates, Common Table Expressions
Event triggers, JSON/JSONB, Non-btree indexes
Patroni
Self-managed in a private data center
1 TB - 1 PBDigitalOcean, Oracle CloudDBeaver, GrafanaTimescaleDBTimescaleDBRedis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
IoT applications, Dashboarding, App development
TRUEIoT applicationsEnergy101-5002-10 peopleMoreFALSE
79
20+1-2 yearsPostgreSQL
Technical forum (e.g., Stack Overflow, Reddit, DBA Exchange)
Ecosystem44No
I haven’t attended any virtual events
RubypgAdmin 4psqlWindow functionsJSON/JSONB, Event triggers
I don’t use an automated failover solution
Timescale Cloud or Timescale Forge
100 - 500 GBI don’t use a cloud providerGrafana, pgAdminTimescale
PostGIS, TimescaleDB, tablefunc
Cassandra, Redis, MongoDB, Elasticsearch
EMEA (Europe, Middle East, Africa)
DevOps EngineerTRUE
IoT applications, Monitoring, Real-time analytics
FALSEFALSE
80
0-56-10 yearsPostgresWork or colleagueReliability35No
Conferences, Meetups, Technical workshops
5Java, PythonI don’t use database tools/GUIspsqlWindow functions
Logical replication, Non-btree indexes, Declarative partitioning
Patroni
Self-managed on-site, Self-managed in a private data center
1 TB - 1 PBI don’t use a cloud providerGrafana
Pg_stat_statisics pg_repack timescaledb
pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB, pg\_prewarm, Citus
Elasticsearch, Redis
EMEA (Europe, Middle East, Africa)
Information Technologies / Systems Engineer
TRUEMonitoring, IoT applicationsTRUE
DevOps, Monitoring, App development
Retail / Food5,001-10,0002-10 peopleLessTRUE
81
16-203-5 yearsPostgresSchoolCommunity33Yes, once or twice
I haven’t attended any virtual events
JavaDBeaverpsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Window functions
JSON/JSONB, Event triggers, Declarative partitioning, Logical replication
repmgr
Self-managed in a private data center
1 TB - 1 PBAWS
DBeaver, Grafana, Metabase, Tableau
pg stats, uuid, hypo index
pg\_repack, pg\_stat\_statements, postgres\_fdw, TimescaleDB
Cassandra, Elasticsearch, MongoDB, Redis
South America
Information Technologies / Systems Engineer
TRUEMonitoringTRUEFinanceFinance / Crypto / FinTech101-50011-20 peopleAbout the sameTRUE
Foros, i wrte ine Postgres extension
I like i have postges telegram, tweeter,
Maybe language because in Latam we speak Spanish
More samples or easiest way ti find oir extensions or complements
N9
10 years ago. From oracle to Postgres. Budget reduction
82
I'm not a developer15+ yearsPostgresWork or colleagueLicense45No
I haven’t attended any virtual events
SQL, Shell scripts, GoI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Lateral joins, Tablesamples, Window functions, Grouping sets, Full text search
Declarative partitioning, Event triggers, JSON/JSONB, Logical replication, Logical decoding, Non-btree indexes, Procedures (with CALL), Custom foreign data wrappers, BRIN
Patroni
AWS RDS, Self-managed in a private data center
1 TB - 1 PBAWS
Grafana, Metabase, Power BI, Tableau
Postgis, postgres_fdw, pgcrypto
Citus, ltree, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
Elasticsearch, RedisNorth AmericaDatabase AdministratorTRUEApp development, DevOpsTRUE
App development, Dashboarding, DevOps, Finance, Monitoring
Finance / Crypto / FinTech101-50011-20 peopleMoreTRUE
Mailing lists, Slack, conferences
Knowledgeable, helpful, friendly, and respectful help on the mailing lists. Meritocracy of decision making and planning of features. Appreciably transparent core team dialogue for the releases and major decisions.
Lack of a proper bug tracker. Hard to follow commits sometimes.
Better tooling, eg GUIs (not that I use any), failover & replication tooling, better monitoring/visualization built in.
I love the CLI, but past coworkers have griped bitterly that it’s a pain to set up Postgres as a newcomer. I’ve been using it for 15+ years so I don’t really see the problems, but clearly there’s a belief that they exist.
More examples around the GUCs and how to set them properly and why, that tends to be a pain for new folks I’ve noticed.
No
Oracle and MSSQL. Both companies migrated because of cost savings.
83
11-153-5 yearsPostgresBookSQL53No
I haven’t attended any virtual events
JavaScript or TypeScriptAdminerpgcli
Common Table Expressions, Window functions
Non-btree indexes, Pluggable table storage, Procedures (with CALL)
I don’t use an automated failover solution
Self-managed in a private data center
100 - 500 GBI don’t use a cloud providerI don’t use visualization toolsTimescaleDBTimescaleDB, PostGISMongoDB, Redis, DynamoDB
EMEA (Europe, Middle East, Africa)
CTOTRUEApp developmentTRUE
IoT applications, Monitoring, Dashboarding, Real-time analytics
Manufacturing11-502-10 peopleA lot moreTRUE
I personally know several PG contributors, and we hangout in developer chats
The amount of knowledge people have and willing to share with each other
Often people expect some level of expertise from you, and it's harder for them to answer more trivial questions.
Not really. Usually, once a database is selected for a project, another types of databases may be added later, but they never replace the original db completely. I've been part of a project where a relational database were added to a NoSQL project for reporting purposes, or to cover specific scenarios (like billing).

The SQL vs. NoSQL war is a thing in a past. Today, both camps join forces and work together.
From SQL Server. Mostly for better SQL standard support, better support in language-specific libraries, and for extensions like Timescale
84
0-53-5 yearsPostgreSQLWork or colleagueSQL43No
Meetups, Technical workshops, Webinars
3Ruby, SQL, Go, Python
IntelliJ, I don’t use database tools/GUIs
psqlFilter clause for aggregates
JSON/JSONB, Logical replication, Non-btree indexes
I don’t use an automated failover solution
Self-managed in a private data center
1 TB - 1 PBGCPGrafanaNA
Citus, pg\_stat\_statements, postgres\_fdw
MongoDB, Redis, Elasticsearch, Cassandra
APAC (Asia-Pacific)
Software Developer / Engineer
TRUE
Web analytics, Real-time analytics, Finance, DevOps, Dashboarding, SaaS metrics
TRUEWeb analyticsSoftware / SaaS11-5011-20 peopleA lot less
Usually by helping out teammates
The Wide array of usecases
Fragmented knowledge
Active & Open places for community (no slack channels please )
NANA
85
20+6-10 yearsPostgresWork or colleagueEcosystem35No
Conferences, Webinars
4Postgres VisionSQL, Python, Shell scriptsI don’t use database tools/GUIspsql
Full text search, Filter clause for aggregates, Common Table Expressions
JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Self-managed on-site
< 100 GBAWSI don’t use visualization toolsfuzzystrmatch
Citus, ltree, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB
Elasticsearch, CassandraNorth America
Software Developer / Engineer
TRUEFinanceTRUEApp developmentEducation2-10 peopleMoreTRUE
Twitter, Postgres weekly, conference attendance
comprehensive documentation, broad ecosystem
nothing comes to mind
more welcome to Postgres from database X sessions
No
Used MySQL and Oracle in previous experience. Migrated from MySQL to get a richer, more standard, and more performant database. Oracle was an issue of licensing costs.
86
16-2015+ yearsPostgresWork or colleagueReliability45Yes, several timesConferences3Java, C, SQLI don’t use database tools/GUIspsql
Common Table Expressions, Grouping sets, Window functions
JSON/JSONB
I don’t use an automated failover solution
Self-managed in a private data center
501 GB - 999 GBAzure, AWSGrafanaslony, pg_auto_explain
pg\_stat\_statements, pg\_repack, PostGIS
Elasticsearch, RedisNorth America
Software Developer / Engineer
TRUEApp development, OtherTRUE
App development, DevOps, Monitoring
Software / SaaS101-50011-20 peopleAbout the sameFALSE
87
0-511-15 yearsNo preferenceSearch engineLicense33Yes, once or twiceTechnical workshops3llmlmlRubypgAdmin 4psqlTablesamplesLogical decoding
I don’t use an automated failover solution
Self-managed on-site1 TB - 1 PBVMwareTableau.pg\_stat\_statements
I have never used a NoSQL database
North America
Software Developer / Engineer
FALSEFALSEFALSE
88
20+15+ yearsPostgreSQL
Cas study for university project
Reliability54Yes, once or twice
I haven’t attended any virtual events
Go, Python, Ruby, Shell scripts, SQLDBeaverpsql
Window functions, Tablesamples, Lateral joins, Grouping sets, Filter clause for aggregates, Common Table Expressions, Full text search
JSON/JSONB, Logical decoding, Logical replication, Declarative partitioning, Custom foreign data wrappers, BRIN
Patroni
AWS RDS, Google Cloud PostgreSQL, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Self-managed in a private data center, Self-managed on-site
100 - 500 GBAWS, GCPDBeaver, Grafanapg_stat_statements
trgm
timescaledb
pg\_stat\_statements, pg\_prewarm, pg\_repack, postgres\_fdw, PostGIS, TimescaleDB, tablefunc
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Database AdministratorTRUE
IoT applications, Monitoring, Real-time analytics, SaaS metrics, App development
TRUE
App development, DevOps, Dashboarding, IoT applications, Monitoring, Real-time analytics, SaaS metrics
PostgreSQL Consultant0-102-10 peopleAbout the sameTRUE
Volunteer for european meetings (pgconfeurope, fosdem)
French speaking PostgreSQL community creator
Openness
Friendship
Technical excellence
Sometimes technical level is quite high
No. No migration
89
16-206-10 yearsPostgresFriendsReliability43NoWebinars4JavaScript or TypeScript, SQL, GraphQLPostico, DBeaverpsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Event triggers, JSON/JSONB, Procedures (with CALL)
I don’t use an automated failover solution
Self-managed in a private data center, Self-managed on-site
100 - 500 GBI don’t use a cloud providercustom webappplpgsql
pgcrypto
pg_stat_statements
Citus, ltree, pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw, TimescaleDB, ZomboDB
Redis
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
App development, Dashboarding, Monitoring, IoT applications, Real-time analytics
TRUE
App development, Dashboarding, DevOps, IoT applications, Monitoring, Real-time analytics
Software / SaaS0-10Just meA lot moreTRUE
Read blogs, twitter, reddit and hackernews
Variety. People do a lot of crazy stuff with pg
too many competing solutions to hard problems. Hard to find to "right" solution. For replication/failover for example. It'd be great to have an official way.
from sqlite and mysql, used them in legacy projects. Didn't want the mental overhead of using different solutions since postgresql is the best and I was gonna focus on that only.
90
6-106-10 yearsPostgresWork or colleagueUsability33No
I haven’t attended any virtual events
Haskell, ErlangPosticopsql
Common Table Expressions, Full text search, Window functions
JSON/JSONB, Non-btree indexes
I don’t use an automated failover solution
DigitalOcean100 - 500 GBDigitalOcean, AWSDatadog
timescaledb, pg_trgm, pg_stat_statements
pg\_stat\_statements, TimescaleDB
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEApp developmentTRUE
Real-time analytics, App development, Finance
MarTech101-5002-10 peopleMoreTRUEI don't. (I think…)
91
11-153-5 yearsPostgreSQLWork or colleaguePerformance55No
Conferences, Meetups, Webinars
5C, RubyI don’t use database tools/GUIspsql
Common Table Expressions, Filter clause for aggregates, Full text search, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, BRIN, Event triggers, JSON/JSONB, Declarative partitioning, Logical replication, Non-btree indexes, Procedures (with CALL)
AWS RDSAWS RDS100 - 500 GBAWS, VMwareI don’t use visualization toolsuuid-ossp
pg_stat_statements
pgstattuple
ltree, pg\_prewarm, pg\_stat\_statements, PostGIS, postgres\_fdw
Cassandra, Elasticsearch, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Information Technologies / Systems Engineer
TRUEApp developmentTRUE
App development, DevOps, Finance, IoT applications, Monitoring, Real-time analytics, SaaS metrics, Web analytics
Software / SaaS101-5002-10 peopleA lot moreTRUETwitter
GitHub
Conferences
No nonsense, to the pointN/A
More guidance towards official documentation in lieu of sporadic blog posts by individuals
Yes for performance and architectural simplicity
Yes from MySQL for consistency reasons
92
16-203-5 yearsPGSearch enginePerformance44NoConferences, Meetups5PGCon, Postgres ConfGo, Java, JavaScript or TypeScript, SQLIntelliJ, pgAdmin 4psql
Window functions, Lateral joins, Tablesamples, Filter clause for aggregates, Common Table Expressions
Event triggers, JSON/JSONB, Logical replication, Non-btree indexes
Patroni
Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.)
100 - 500 GBAzureGrafana
timescaledb, pgcrypto, postgres_fdw
pg\_stat\_statements, TimescaleDB, postgres\_fdw, PostGIS, ZomboDB
Elasticsearch, Cassandra, MongoDB, Redis
EMEA (Europe, Middle East, Africa)
Software ArchitectFALSETRUE
Dashboarding, App development, Real-time analytics, Monitoring, IoT applications, SaaS metrics, DevOps
IoT11-502-10 peopleMoreFALSE
93
11-151-2 yearsPGSocial mediaEcosystem51NoConferences2Go, JavaScript or TypeScriptOmniDBpsqlFull text search
Custom foreign data wrappers
repmgrAzure Postgres< 100 GBAzure, Oracle CloudGrafana, Power BIN/Apg\_prewarmMongoDBPrefer not to say
Information Technologies / Systems Engineer
TRUEDevOpsFALSEFALSE
94
0-5Less than 1 yearPostgres
Technical forum (e.g., Stack Overflow, Reddit, DBA Exchange)
SQL53No
I haven’t attended any virtual events
Python, SQL, JavaIntelliJ, pgAdmin 4I don’t use CLI toolsCommon Table ExpressionsJSON/JSONB
I don’t use an automated failover solution
Self-managed in a private data center, Self-managed on-site
< 100 GBI don’t use a cloud providerpgAdmin, GrafanaTimeScaleTimescaleDB, PostGISElasticsearch
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
App development, Other, IoT applications
TRUE
Dashboarding, Web analytics, Real-time analytics
Transportation1,001-5,000Just meMoreFALSE
95
0-51-2 yearsPostgresSearch engineLicense33No
I haven’t attended any virtual events
Python, SQLpgAdmin 4pgcliCommon Table ExpressionsEvent triggers
I don’t use an automated failover solution
Self-managed in a private data center
100 - 500 GBI don’t use a cloud providerI don’t use visualization toolsNATimescaleDB
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUE
App development, Dashboarding, Real-time analytics, Web analytics
TRUE
App development, Dashboarding, Monitoring, Real-time analytics
Manufacturing0-102-10 peopleAbout the samenonanana
96
11-1515+ yearsPostgresApt-cache search sqlReliability54Yes, several times
I haven’t attended any virtual events
Python, Shell scripts, SQL, PerlOmniDBpsql
Common Table Expressions, Filter clause for aggregates, Grouping sets, Lateral joins, Window functions
Custom foreign data wrappers, Declarative partitioning, JSON/JSONB, Non-btree indexes
Patroni
Self-managed in a private data center, Self-managed on-site
1 TB - 1 PBI don’t use a cloud providerGrafana
Postgresql-unit pg_stat_statements
pg\_repack, pg\_stat\_statements, PostGIS, postgres\_fdw
I have never used a NoSQL database
EMEA (Europe, Middle East, Africa)
Senior ConsultantTRUEDashboardingTRUE
Monitoring, Real-time analytics, Web analytics, SaaS metrics
Software / SaaS51-1002-10 peopleMoreTRUE
Major contributor, debian packaging, bug reports
Code quality
Getting involved is hard, high hurdles
No
Oracle, MySQL, informix, mssql
97
11-156-10 yearsPostgreSQLTechnical blogLicense43NoWebinars3postgres-cnGo, SQL, CpgAdmin 4, pgAdmin I-IIIpsql
Common Table Expressions, Full text search
Declarative partitioning, Event triggers, JSON/JSONB, Non-btree indexes, BRIN, Logical replication, Procedures (with CALL)
Patroni
Self-managed in a private data center, Self-managed on-site
< 100 GBAlibaba Cloud, DigitalOceanpgAdminpostgis, uuid, timescaledb
TimescaleDB, PostGIS, pg\_stat\_statements, Citus
RedisAPAC (Asia-Pacific)Database AdministratorTRUE
IoT applications, App development, Monitoring
TRUE
App development, IoT applications, Monitoring
IoT101-5002-10 peopleMoreTRUEno, I am just a user now
fully functional and run well, zero cost!
ha is a little weak, postgres is getting improvement quickly version by version
take it into college and educate more new user, database is hard and not sexy though.
no
sql server, pg is cross platform
98
11-156-10 yearsPostgresTechnical blogSQL54No
I haven’t attended any virtual events
Python, SQL, Shell scripts
DBeaver, I don’t use database tools/GUIs
psqlCommon Table ExpressionsJSON/JSONB
I don’t use an automated failover solution
AWS RDS, Self-managed Postgres on a public cloud (AWS, GCP, Azure, etc.), Timescale Cloud or Timescale Forge
< 100 GBAWS, AzureDBeaver, MetabasePostgis, TimescalePostGIS, TimescaleDBElasticsearch, RedisSouth AmericaSoftware ArchitectFALSETRUE
App development, Dashboarding, Monitoring, DevOps, IoT applications
Software / SaaS11-502-10 peopleMoreTRUEI rarely do
Broad support and experience.
Cannot think of it.Cannot think of.
From nosql to sql. Performance is on par for the use cases, and we could leverage other technologies (django) and a more consistent schema to visualize via metabase.
Ive migrated from mysql to postgres, for licencing reasons and lack of schema transactions at the time.
99
11-151-2 yearsPostgreSQLWork or colleagueLicense43No
I haven’t attended any virtual events
C#, SQLpgAdmin 4psql
Filter clause for aggregates, Common Table Expressions, Grouping sets, Lateral joins
JSON/JSONB
I don’t use an automated failover solution
Self-managed in a private data center
100 - 500 GBAzurepgAdminN/ATimescaleDBRedis, MongoDB
EMEA (Europe, Middle East, Africa)
Software Developer / Engineer
TRUEOtherTRUEMonitoringTelecommunications11-502-10 peopleAbout the sameFALSE
100
0-53-5 yearsPostgresWork or colleagueUsability53No
I haven’t attended any virtual events
RubyI don’t use database tools/GUIspsql
Common Table Expressions, Full text search, Grouping sets, Lateral joins, Filter clause for aggregates
JSON/JSONB, Non-btree indexes
Google Cloud HA for CloudSQLGoogle Cloud PostgreSQL100 - 500 GBGCPI don’t use visualization toolspg_trgm, hstorepg\_stat\_statementsRedisNorth America
Software Developer / Engineer
FALSETRUE
Dashboarding, App development, DevOps, Monitoring, Real-time analytics, SaaS metrics, Web analytics
Healthcare / Pharmaceuticals
11-502-10 peopleAbout the sameFALSE