PostgreSQL @PostgreSQL Twitter profile

Pinned Tweet

PostgreSQL

3 months

News: PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!

PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.2, 15.6, 14.11, 13.14, …

www.postgresql.org

5

52

148

Last Seen Profiles

@DansBigRun

@RunesAsFuck

@Sui_A

@ConnorBachh

@facilitatingp

@SuzannaJester

@ProClubRetweet_

@shidhatha

@AsteriadisGp

@MuseosAndaluces

@toonbutch

@meirim_abyss

@IlhamfajriAkba1

@Yeim95906665

@Lifes_Ah_Laugh

@C_Fumbeshi

@vinylhousefilm

@ZalSpace

@almbswift

@TraductTurkka

@stonesimmons17

@oscaravanas

@audreypromos

@Kings_A1

@YLeyfman

@shahprateekd

@UWAdmissions

@szachmad

@jimshapiro

@aitokyouki

@HuntlyYouth

@WeerthDe

@Percolator_HNJ

@kpopchart

@cegilmalik

@Dopp4n

PostgreSQL

@PostgreSQL

8 months

News: PostgreSQL 16 Released!

PostgreSQL 16 Released!

September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of …

www.postgresql.org

16

471

1K

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 Released!

PostgreSQL 15 Released!

**October 13, 2022** - The PostgreSQL Global Development Group today announced the release of [PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest version of …

www.postgresql.org

19

397

1K

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 14 Released!

PostgreSQL 14 Released!

The PostgreSQL Global Development Group today announced the release of [PostgreSQL 14](https://www.postgresql.org/docs/14/release-14.html), the latest version of the world’s [most advanced …

www.postgresql.org

6

370

717

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 13 Released!

PostgreSQL 13 Released!

The PostgreSQL Global Development Group today announced the release of [PostgreSQL 13](https://www.postgresql.org/docs/13/release-13.html), the latest version of the world’s [most advanced …

www.postgresql.org

5

392

698

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11 Released!

11

549

705

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 12 Released!

PostgreSQL 12 Released!

The PostgreSQL Global Development Group today announced the release of [PostgreSQL 12](https://www.postgresql.org/about/news/1976/), the latest version of the world's [most advanced …

www.postgresql.org

5

419

565

PostgreSQL

@PostgreSQL

5 years

We're honored by the recognition and are very happy that people enjoy using @PostgreSQL ! The @PostgreSQL community will continue working hard on building the world's most advanced open source relational database.

DB-Engines

@DBEngines

5 years

#PostgreSQL is the DBMS of the Year for the second year in a row @postgresql

1

89

117

3

72

222

PostgreSQL

@PostgreSQL

1 month

News: Remembering Simon Riggs

Remembering Simon Riggs

The PostgreSQL Core Team is deeply saddened by the loss of our long-time friend and colleague Simon Riggs on the …

www.postgresql.org

8

89

210

PostgreSQL

@PostgreSQL

6 years

Tomorrow, the @PostgreSQL 11 RC (Release Candidate) 1 is made available. If all goes well, PostgreSQL 11 will be made generally available on October 18. This would not be possible without the hard work of everyone who developed, tested, and contributed to the project. Thank you!

1

99

173

PostgreSQL

@PostgreSQL

6 years

What's this? @postgresql has a brand new website? And it's mobile-friendly? Sounds web scale! Check out the new

PostgreSQL

The world's most advanced open source database.

www.postgresql.org

4

107

168

PostgreSQL

@PostgreSQL

6 years

Sometimes what seems like a good idea, isn't! The community has collected a list of gotchas to beware of on the wiki.

3

86

154

PostgreSQL

@PostgreSQL

6 months

News: PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!

PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.1, 15.5, 14.10, 13.13, …

www.postgresql.org

6

41

149

PostgreSQL

@PostgreSQL

6 years

Many applications use pagination for display purposes, and a common technique is to use "OFFSET" in your query, but are there better ways to do it? @MarkusWinand demonstrates some alternatives to using OFFSET:

4

60

145

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released!

PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 14.2, 13.6, 12.10, 11.15, …

www.postgresql.org

3

70

142

PostgreSQL

@PostgreSQL

5 years

A big part of an open source community is maintaining the project infrastructure. Today, the @PostgreSQL website was migrated from using Python 2 to Python 3 to ensure we can continue to support the modern requirements of the community:

2

26

142

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 12.4, 11.9, 10.14, 9.6.19, 9.5.23, and 13 Beta 3 Released!

0

76

140

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 Released!

2

96

137

PostgreSQL

@PostgreSQL

4 years

The PostgreSQL Community would like to extend its appreciation to all the DBAs out there. ❤️🐘 Happy DBA Appreciation Day!

0

47

132

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 Released!

PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 13.1, 12.5, …

www.postgresql.org

3

90

130

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released!

PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 13.2, 12.6, …

www.postgresql.org

4

69

127

PostgreSQL

@PostgreSQL

5 years

Interested in running WebAssembly in @PostgreSQL ? Try out the "wasm" PostgreSQL extension, which lets you run compiled WebAssembly programs: directly in PostgreSQL

GitHub - wasmerio/wasmer-postgres: 💽🕸 Postgres library to run WebAssembly binaries.

💽🕸 Postgres library to run WebAssembly binaries. Contribute to wasmerio/wasmer-postgres development by creating an account on GitHub.

github.com

4

64

127

PostgreSQL

@PostgreSQL

8 months

News: CVE-2020-21469 is not a security vulnerability

CVE-2020-21469 is not a security vulnerability

The [PostgreSQL Security Team](https://www.postgresql.org/support/security/) was made aware of [CVE-2020-21469](https://www.cve.org/CVERecord?id=CVE-2020-21469), which was filed without the prior...

www.postgresql.org

5

30

128

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released!

PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 12.3, 11.8, …

www.postgresql.org

1

75

123

PostgreSQL

@PostgreSQL

1 year

News: PostgreSQL 15.2, 14.7, 13.10, 12.14, and 11.19 Released!

PostgreSQL 15.2, 14.7, 13.10, 12.14, and 11.19 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 15.2, 14.7, 13.10, 12.14, …

www.postgresql.org

3

38

123

PostgreSQL

@PostgreSQL

6 years

Did you know in @PostgreSQL 11, you can now use a "web search" style query with PostgreSQL's full text search functionality? Take a look at the new "websearch_to_tsquery" function, documented here:

2

65

124

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 13 RC 1 Released!

PostgreSQL 13 RC 1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 13 is now available for download. As …

www.postgresql.org

1

58

122

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 14 RC 1 Released!

PostgreSQL 14 RC 1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 14 is now available for download. As …

www.postgresql.org

0

49

122

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 13.4, 12.8, 11.13, 10.18, 9.6.23, and 14 Beta 3 Released!

PostgreSQL 13.4, 12.8, 11.13, 10.18, 9.6.23, and 14 Beta 3 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 13.4, 12.8, …

www.postgresql.org

2

55

117

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 14 Beta 1 Released!

PostgreSQL 14 Beta 1 Released!

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 14 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

2

59

121

PostgreSQL

@PostgreSQL

6 years

`psql @postgresql ` psql (10.4) Type "help" for help @postgresql => SELECT thanks(); thanks -------- We've reached 5432 followers! Thank you for supporting our community twitter feed - we're excited to keep providing helpful content around our database and open source community.

1

47

117

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 Beta 1 Released!

PostgreSQL 15 Beta 1 Released!

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 15 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

1

40

111

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24 Released!

PostgreSQL 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 14.1, 13.5, …

www.postgresql.org

1

62

113

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 13.3, 12.7, 11.12, 10.17, and 9.6.22 Released!

PostgreSQL 13.3, 12.7, 11.12, 10.17, and 9.6.22 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 13.3, 12.7, …

www.postgresql.org

0

56

115

PostgreSQL

@PostgreSQL

3 years

Thanks for the recognition! @PostgreSQL owes its success to its dedicated community of developers, advocates, and users who help make our free and open source database software better every day! Give @PostgreSQL a try:

PostgreSQL

The world's most advanced open source database.

www.postgresql.org

DB-Engines

@DBEngines

3 years

PostgreSQL is the DBMS of the Year @PostgreSQL #PostgreSQL

1

117

261

0

46

114

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released!

3

64

113

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 14.4 Released!

PostgreSQL 14.4 Released!

The PostgreSQL Global Development Group has released PostgreSQL 14.4 to fix an issue that could cause silent data corruption when …

www.postgresql.org

1

56

113

PostgreSQL

@PostgreSQL

5 years

The first release candidate for @PostgreSQL 12 is scheduled for September 26. The GA is tentatively scheduled for October 3. Start catching up on all the new features that will be coming up in the latest release of PostgreSQL!

E.19. Release 12

E.19. Release 12 E.19.1. Overview E.19.2. Migration to Version 12 E.19.3. Changes E.19.4. Acknowledgments Release date: 2019-10-03 E.19.1. Overview Major enhancements in PostgreSQL …

www.postgresql.org

0

66

108

PostgreSQL

@PostgreSQL

1 year

News: PostgreSQL 16 Beta 1 Released!

PostgreSQL 16 Beta 1 Released!

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 16 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

0

41

109

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 13 Beta 1 Released!

PostgreSQL 13 Beta 1 Released!

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 13 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

0

60

104

PostgreSQL

@PostgreSQL

9 months

News: PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3 Released!

PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 15.4, 14.9, 13.12, 12.16, …

www.postgresql.org

1

46

105

PostgreSQL

@PostgreSQL

1 year

News: PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!

PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 15.1, 14.6, 13.9, 12.13, …

www.postgresql.org

1

39

104

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 12 Beta 1 Released!

PostgreSQL 12 Beta 1 Released!

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 12 is now available for download. This …

www.postgresql.org

0

65

105

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 14.5, 13.8, 12.12, 11.17, 10.22, and 15 Beta 3 Released!

PostgreSQL 14.5, 13.8, 12.12, 11.17, 10.22, and 15 Beta 3 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 14.5, 13.8, 12.12, 11.17, …

www.postgresql.org

4

43

102

PostgreSQL

@PostgreSQL

6 years

Did you know that @PostgreSQL lets you set the storage mode for individual columns (e.g. inline vs. TOAST, compressed vs. uncompressed)? @pwramsey demonstrates how modifying the storage mode on a column boosts a @PostGIS query's performance by 500%:

5x Faster Spatial Join with this One Weird Trick

Update: As of PostGIS 3.1, spatial join is much faster due to some caching improvements, and this trick will mostly no longer yield large performance gains, though it still won’t hurt. My go-to...

blog.cleverelephant.ca

1

36

98

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, and 12 Beta 2 Released!

4

73

100

PostgreSQL

@PostgreSQL

6 years

What are "materialized views" and how do they work in @postgresql ? @steph_baltus wrote up a guide for how she used materialized views in her application as well as advice for using them in production:

Materialized views with PostgreSQL for beginners

I was asked to speak at the Postgresql User Group in Paris recently, and I chose to talk about materialized view (aka MatView), as they…

medium.com

2

36

98

PostgreSQL

@PostgreSQL

5 years

Coming in @PostgreSQL 12: No more "recovery.conf" file: all those settings are now set in the main configuration file. A "recovery" or "standby" instance can be initiated with a "recovery.signal" or "standby.signal" file! See the commit here:

3

45

98

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 12 RC 1 Released!

PostgreSQL 12 RC 1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 12 is now available for download. As …

www.postgresql.org

1

71

97

PostgreSQL

@PostgreSQL

6 years

When you create and use an index @postgresql , what is the database actually doing? @louisemeta 's presentation explains how each index works, with a crocodile there to help tell the story:

Indexes in postgres

Indexes in postgres - Download as a PDF or view online for free

www.slideshare.net

0

37

97

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 11.3, 10.8, 9.6.13, 9.5.17, and 9.4.22 Released!

0

75

96

PostgreSQL

@PostgreSQL

5 years

As the year winds down, why not study how @PostgreSQL processes a query? @suzuki_hironobu provides a detailed guide with several examples of how queries are handled internally in PostgreSQL:

0

33

94

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 Beta 2 Released!

PostgreSQL 15 Beta 2 Released!

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 15 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

1

38

93

PostgreSQL

@PostgreSQL

4 years

News: PostgreSQL 13 Beta 2 Released!

0

56

95

PostgreSQL

@PostgreSQL

2 years

The @PostgreSQL website now supports dark mode! Check it out and let us know what you think:

PostgreSQL

The world's most advanced open source database.

www.postgresql.org

7

16

96

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 Released!

1

61

93

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11 RC1 Released!

PostgreSQL 11 RC1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 11 is now available for download. As …

www.postgresql.org

2

70

94

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11 Beta 1 Released!

2

80

92

PostgreSQL

@PostgreSQL

5 years

pgloader is an open source tool that lets you load data from a variety of data sources in @PostgreSQL with support for parallelism. You can learn more about the project here and see if it can help you with your projects!

0

43

91

PostgreSQL

@PostgreSQL

6 years

It's true, using COPY is really fast for data ingestion in @postgresql ! Read how @danielfone turned a potential 16 hour data import into a 4 minute one:

2

29

89

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 RC 1 Released!

PostgreSQL 15 RC 1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 15 is now available for download. As …

www.postgresql.org

3

42

89

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released!

PostgreSQL 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.1, 10.6, …

www.postgresql.org

2

76

87

PostgreSQL

@PostgreSQL

10 months

News: PostgreSQL 16 Beta 2 Released!

PostgreSQL 16 Beta 2 Released!

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 16 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

5

36

86

PostgreSQL

@PostgreSQL

6 years

Congratulations to the new @postgresql committers! Etsuro Fujita Peter Geoghegan Amit Kapila Alexander Korotkov Thomas Munro Michael Paquier Tomas Vondra Read more here:

New committers announced at PGCon 2018

The core team is pleased to announce the appointment of seven new Postgres committers: Etsuro Fujita Peter Geoghegan Amit Kapila …

www.postgresql.org

2

47

88

PostgreSQL

@PostgreSQL

1 year

News: PostgreSQL 15.3, 14.8, 13.11, 12.15, and 11.20 Released!

PostgreSQL 15.3, 14.8, 13.11, 12.15, and 11.20 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 15.3, 14.8, 13.11, 12.15, …

www.postgresql.org

2

34

86

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 RC 2 Released!

PostgreSQL 15 RC 2 Released!

The PostgreSQL Global Development Group announces that the second release candidate of PostgreSQL 15 is now available for download. As …

www.postgresql.org

0

30

84

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL 14 Beta 2 Released!

PostgreSQL 14 Beta 2 Released!

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 14 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

1

38

84

PostgreSQL

@PostgreSQL

6 years

pgcli is an open source command-line interface for PostgreSQL with syntax highlighting and additional autocompletion features.

0

46

85

PostgreSQL

@PostgreSQL

6 years

How does @PostgreSQL go beyond traditional SQL databases? @apatheticmagpie shares her slides from @pgconfeu on some of the unique features of PostgreSQL:

PostgreSQL is NOT your traditional SQL database

This presentation is prepared for PostgreSQL Conference Europe 2018.

slides.com

2

50

84

PostgreSQL

@PostgreSQL

6 years

Don't want to have your primary key to be an ordered sequence of integers that people can easily guess? @emerson_lackey shows how to use @postgresql to create random, unique integers for your PKs:

Postgres Randomized Primary Keys

There are times in your life when you might be asked to randomize the primary keys of a table so that they are numeric, unique, but…

medium.com

2

24

84

PostgreSQL

@PostgreSQL

6 years

The 2018 @postgresql Developer Meeting at @pgcon has concluded! You can read the meeting notes here: And of course, the annual developer photo!

1

32

84

PostgreSQL

@PostgreSQL

6 years

A common pitfall with @postgresql is to create a foreign key constraint, but forget to create an index, and then go perform a lot of lookups on that foreign key! Cameron Ellis demonstrates how to find foreign keys that are missing indexes:

How to find missing indexes on foreign keys.

I’ve been using postgraphile for my new company, WhoTeam. Using postgraphile is, and I’m drastically simplifying here, like an ORM for…

medium.com

0

28

84

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 14.3, 13.7, 12.11, 11.16, and 10.21 Released!

PostgreSQL 14.3, 13.7, 12.11, 11.16, and 10.21 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 14.3, 13.7, 12.11, 11.16, …

www.postgresql.org

3

37

81

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11 Beta 4 Released!

0

53

81

PostgreSQL

@PostgreSQL

6 years

The "feature freeze" for @postgresql 11 is in effect. The community will now be hard at work on making sure that all of the new features will meet the quality standards that @postgresql is known for in time for the release later this year!

0

51

84

PostgreSQL

@PostgreSQL

5 years

News: PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released!

PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.2, 10.7, …

www.postgresql.org

1

75

81

PostgreSQL

@PostgreSQL

6 years

How do you upgrade @postgresql versions for a 50 terabyte database while minimizing downtime? Reinier Hassjes discusses his experience and the solution his team developed:

Updating a 50 terabyte PostgreSQL database

By Reinier Haasjes, Senior System Administrator, Adyen

medium.com

0

45

80

PostgreSQL

@PostgreSQL

6 years

Writing fast @postgresql queries can feel like an art, but understanding how to use tools like EXPLAIN and indexing features can help! @paveltiunov87 wrote up a case-study on using the above to optimize a query in a 10TB database:

Cube Blog

Practical guides on business analytics and machine learning with applications and SQL code. Latest trends in data science for professionals, as long as good old methods for beginners.

cube.dev

2

41

79

PostgreSQL

@PostgreSQL

5 years

The @PostgreSQL Project is not possible without the generous support of our sponsors. The sponsorship committee recently voted to update the list to reflect the significant ongoing contributions of these organizations to @PostgreSQL : Thank you!

0

39

79

PostgreSQL

@PostgreSQL

6 years

It's always a good idea to test your code, even when using @postgresql ! @gwaxgwax demonstrates how to test @postgresql application code with the help of two Python libraries: pytest-pgsql and pgmock:

Better PostgreSQL testing with Python: announcing pytest-pgsql and pgmock

At Clover Health, we are heavy users of PostgreSQL and Python 3 as well as strong believers in the value of testing what we build. Today…

technology.cloverhealth.com

1

33

76

PostgreSQL

@PostgreSQL

5 years

Partitioning, arrays, inheritance, JSON, UNION/INTERSECT/EXCEPT, custom data types, window functions, and more! @NahidulHasan explores @PostgreSQL features that are helpful for application development:

PostgreSQL’s Exciting features, you should know | HackerNoon

PostgreSQL is a powerful,object-relational database system that extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

hackernoon.com

0

30

80

PostgreSQL

@PostgreSQL

5 years

Looking for some more information on getting started with @PostgreSQL , some tips & tricks, or want to test your @PostgreSQL knowledge? We've compiled a set of resources that range from one page guides, interactive exercises, and tutorials!

0

35

74

PostgreSQL

@PostgreSQL

6 years

Want to write complex but easy-to-understand @postgresql queries? @elmaddawg demonstrates how to do so, highlighting features such as subqueries, filtered aggregates, and window functions!

Postgres Query Techniques every Backend Developer should have in their Toolkit

Ever tried to assemble a thorny data calculation for a data migration and couldn’t figure out how to fit the pieces together? It’s…

medium.com

1

29

77

PostgreSQL

@PostgreSQL

3 years

News: PostgreSQL Accepted for Google Summer of Code 2021!

PostgreSQL Accepted for Google Summer of Code 2021!

Greetings, The PostgreSQL Project is excited to announce that we have been accepted to participate in the Google Summer of …

www.postgresql.org

0

24

76

PostgreSQL

@PostgreSQL

6 years

What's better than @PostgreSQL 11? How about PostgreSQL 11.1? The first set of bug fixes will be made available this coming Thursday, November 8, along with bug fixes for the supported versions of PostgreSQL!

0

34

74

PostgreSQL

@PostgreSQL

4 years

There many ways to contribute to @PostgreSQL ! In addition to the core database, there are many software projects that power the infrastructure and advocacy efforts of the PostgreSQL project. We've put together a list of some of these projects here:

0

32

73

PostgreSQL

@PostgreSQL

5 years

Happy Anniversary! Today the official @PostgreSQL community account turns 1! A big thank you to our many wonderful followers and PostgreSQL enthusiasts for helping us to have a great year.

2

12

74

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL Anonymizer 1.0: Privacy By Design For Postgres

PostgreSQL Anonymizer 1.0: Privacy By Design For Postgres

Limoges, France, May 17th, 2022 `PostgreSQL Anonymizer` is an extension that hides or replaces personally identifiable information (PII) or commercially …

www.postgresql.org

0

29

72

PostgreSQL

@PostgreSQL

5 years

Making changes to your @PostgreSQL schema in an highly active production environment requires some additional considerations. Read how Vineet Gopal and team automated their migration process:

Move fast and migrate things: how we automated migrations in Postgres

At Benchling, we’re building a platform to help scientists do research. Hundreds of thousands of scientists across academia and enterprise…

benchling.engineering

0

22

72

PostgreSQL

@PostgreSQL

5 years

It's #FeatureFriday ! @PostgreSQL includes support for LATERAL JOINs. Classic use-case: Need the top-N for some set? SELECT * FROM server set CROSS JOIN LATERAL (SELECT * FROM log WHERE = log.server_id ORDER BY log.received_at DESC LIMIT 20) as topN;

1

21

69

PostgreSQL

@PostgreSQL

6 years

They say it is important to put comments in your code, but what about in your databases? @abdullahalger shows how you can add comments to your @postgresql tables, columns, and other database objects:

1

35

69

PostgreSQL

@PostgreSQL

5 years

Thank you for the recognition #OSCon ! The @PostgreSQL project could not achieve this without the hard work of our dedicated community that builds and advocates for the world's most advanced open source relational database!

Bridget Kromhout

@bridgetkromhout

5 years

Lifetime achievement award at #oscon : @PostgreSQL .

1

5

19

0

21

69

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 11 Beta 2 Released!

1

61

69

PostgreSQL

@PostgreSQL

4 years

News: New PostgreSQL Core Team Members

New PostgreSQL Core Team Members

The PostgreSQL Core Team are pleased to announce the addition of two new members to Core: Andres Freund and Jonathan …

www.postgresql.org

3

20

70

PostgreSQL

@PostgreSQL

6 years

The upcoming @postgresql 11 release adds more support for queries using "WINDOW" functions, but what exactly was added? @JavaOOQ wrote up an analysis of the new features and demonstrates how they work:

0

25

68

PostgreSQL

@PostgreSQL

6 years

You can use the LISTEN/NOTIFY in @postgresql to send asynchronous notifications in your applications! @citizen428 provides an example of how to combine this feature with websockets:

0

24

69

PostgreSQL

@PostgreSQL

8 months

News: PostgreSQL 16 RC1 Released!

PostgreSQL 16 RC1 Released!

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 16 is now available for download. As …

www.postgresql.org

1

35

69

PostgreSQL

@PostgreSQL

2 years

News: PostgreSQL 15 Beta 4 Released!

PostgreSQL 15 Beta 4 Released!

The PostgreSQL Global Development Group announces that the fourth beta release of PostgreSQL 15 is now [available for download](https://www.postgresql.org/download/). This …

www.postgresql.org

0

29

68

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 released!

PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 released!

2018-03-01 Security Update Release ================================== The PostgreSQL Global Development Group has released an update to all supported versions of the …

www.postgresql.org

0

86

66

PostgreSQL

@PostgreSQL

6 years

News: PostgreSQL 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24, and 11 Beta 3 Released!

1

70

67