PGDay UK · @postgresuk
14 followers · 26 posts · Server fosstodon.org
Vincent O’Dea finished out the morning teaching us about DevSecOps.
PGDay UK · @postgresuk
13 followers · 23 posts · Server fosstodon.org
@intrbiz continues the morning with #PostgreSQL for the internet of strange things. #PGDayUK
Jimmy Angelakos :postgresql: · @vyruss
318 followers · 461 posts · Server fosstodon.org
@michristofides speqking about #Postgres buffers and #performance at PGDay UK
#PGDayUK #postgresql
#postgres #performance #pgdayuk #postgresql
PGDay UK · @postgresuk
13 followers · 23 posts · Server fosstodon.org
PGDay UK · @postgresuk
13 followers · 19 posts · Server fosstodon.org
PGDay UK · @postgresuk
13 followers · 17 posts · Server fosstodon.org
Flávio Heleno · @flavioheleno
34 followers · 124 posts · Server phpc.socialI'm a dev working on Kahu.io, but I want to take a little break from it (~1 week or so). Let me know if I can build something useful for you using #tailwindcss #php #postgresql #rabbitmq #redis #docker (RT if you want to help improve my offer reach)
#tailwindcss #php #postgresql #rabbitmq #redis #docker
PgUS · @pgus
45 followers · 152 posts · Server fosstodon.org
LAST CALL!!!
If you haven’t already made your reservation at Club Quarters Grand Central, do it now! The hotel block closes tonight at midnight EDT! Don’t miss out!
@PostgreSQL
#PostgreSQL #postgres #conference #pgconfnyc
#postgresql #postgres #conference #pgconfnyc
· @thomasmey
76 followers · 1286 posts · Server social.tchncs.deTIL:
Oracle just executes this:
SELECT COUNT(*) FROM TABLE ORDER BY COLUMN
it does not really make any sense IMHO, but #postgresql is much more picky with ORDER BY and COUNT star/any... even in this special case!
also depending on Oracle version the plan seems to differ, see this old thread:
https://stackoverflow.com/questions/9070527/select-count-with-an-order-by
Ringo De Smet · @ringods
153 followers · 270 posts · Server hachyderm.ioTIL: http://Kubeblocks.io to run databases on #kubernetes with both day 1 and day 2 support!
#KubernetesDatabase #KubeBlocks #mysql #PostgreSQL #PostgreSQLKubernetes
#kubernetes #kubernetesdatabase #kubeblocks #mysql #postgresql #postgresqlkubernetes
Nicolas Buduroi · @budu
27 followers · 108 posts · Server ruby.social
Lots of great tips for #postgresql
https://hakibenita.com/postgresql-unknown-features
PgUS · @pgus
45 followers · 151 posts · Server fosstodon.org
The hotel block closes on Monday, September 11th! That’s tomorrow! Book your room now at the lovely (and conveniently located) Club Quarters Grand Central!
@PostgreSQL
#PostgreSQL #postgres #conference #pgconfnyc
#postgresql #postgres #conference #pgconfnyc
ConstantOrbit · @constantorbit
1008 followers · 2613 posts · Server hachyderm.io@tuckerteague 😆 since this is getting a lot of boosts, I WILL also say that on the current project I'm on, with a thoroughly microservices architecture, we're NOT using PostgreSQL (or any relational db -- datastores are primarily mongodb/DocumentDB), and in this case it feels appropriate.
#postgresql #sql #mongodb #nosql
ConstantOrbit · @constantorbit
1008 followers · 2613 posts · Server hachyderm.io@tuckerteague PostgreSQL is the go-to datastore on almost ALL projects I've been on for the last 10 years... or more.
It's awesome. Frankly, for *almost* all purposes where people are using these hip NoSQL, timeseries, geospatial, etc things and whatnot, at the scale 99% of us need, pg will handle it JUST fine. Seriously.
And as others have said, very solid but also VERY powerful.
Florent Jardin · @fljdin
27 followers · 60 posts · Server fosstodon.orgOn my way to London! Excited to attend the first PGDay UK next Tuesday. #postgresql @postgresuk
PGDay UK · @postgresuk
13 followers · 17 posts · Server fosstodon.orgCome see Michael Christofides (@michristofides@twitter.com) talk about "Using buffers for query optimisation"!
#postgresql #conference #pgdayuk
PGDay UK · @postgresuk
13 followers · 17 posts · Server fosstodon.orgCome see Tomas Vondra (@fuzzycz@twitter.com) talk about "BRIN improvements and new opclasses"!
#postgresql #conference #pgdayuk
old sysops · @oldsysops
348 followers · 686 posts · Server mamot.frEvery think you need to know about #PGbouncer : https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html
TL;DR it's friday just put it in your tab/bookmark ;-) #postgresql
Dougas J Hunley · @hunleyd
108 followers · 688 posts · Server fosstodon.orgPostGIS, ArcGIS Enterprise and the Tour de France route https://www.cybertec-postgresql.com/en/postgis-arcgis-enterprise-tour-de-france-route/ #gis #postgresql
Dougas J Hunley · @hunleyd
108 followers · 688 posts · Server fosstodon.org
Subqueries and performance in #PostgreSQL - CYBERTEC https://www.cybertec-postgresql.com/en/subqueries-and-performance-in-postgresql/