Postgres TOTD @postgres_totd
Postgres Tweet of the Day Joined March 2009-
Tweets74
-
Followers480
-
Following1
-
Likes0
Postgres TOTD: Use the 'END' as a shortcut for context-sensitive COMMIT or ROLLBACK.
Postgres TOTD: VACUUM FULL and REINDEX do heavy locking, but with autovacuum you should rarely need them.
Postgres TOTD: Logging can go through syslog: control the facility and ident via postgresql.conf.
Postgres TOTD: Postgres 8.4 has a backwards-compatible psql, including backslash commands (finally!)
Postgres TOTD: A table can be physically reordered based on an index with the CLUSTER command. http://tr.im/sI5d
Postgres TOTD: 8.4 has windowing functions: see how they compare to other dbs: http://tr.im/snRO
Postgres TOTD: ANALYZE can be run on the entire database, on a single table, and even on a single column. http://tr.im/sc1L
Postgres TOTD: View PostgreSQL information in a format similar to the Unix tool 'top' with pg_top: http://tr.im/pNXr
Postgres TOTD: Postgres 8.4 gets rid of max_fsm_pages and max_fsm_relations. Two less knobs to worry about!
Postgres TOTD: Postgres natively supports many DTrace probes as of version 8.2. http://tr.im/pvPk
Postgres TOTD: Don't kill -9 backends. Postgres will survive, but other clients may have to reconnect.
Postgres TOTD: LEFT and RIGHT joins are equivalent, so always use LEFT joins to reduce confusion. http://tr.im/oS3I
Postgres TOTD: Subqueries can be used almost everywhere: select (select 1) as c from (select 1) t where 1 = (select 1) limit (select 1);
Postgres TOTD: Make sure you run a global ANALYZE after restoring a database or any other large data import.
Postgres TOTD: When working on someone else's system, call psql with -X to bypass any unknown conf files.
Postgres TOTD: In psql, see how fast all your queries take by toggling \timing on.
Postgres TOTD: Temporary tables can be set as ON COMMIT DELETE to automatically remove them. http://tr.im/nXRC
Postgres TOTD: Starting in PostgreSQL version 8.4, you can use ON TRUNCATE triggers. http://tr.im/nQ7I
Postgres TOTD: One of the many languages available for PostgreSQL functions is LOLCODE. http://tr.im/nAjS (YA RLY!)
Postgres TOTD: When writing functions, put the LANGUAGE declaration with the rest of the metadata at the top.
kolektiva dot social ... @davidfetter
1K Followers 2K Following Parent, Abolitionist, World-wide speaker, PostgreSQL Expert, jq & vim fan. He/him. 🍉✡ No employer has hired me to speak for them through this account, or will
Gülçin Yıldırım ... @apatheticmagpie
5K Followers 4K Following Postgres contributor, working at @xata 🦋 MSc Computer & Systems Eng @TallinnTech , @kadinyazilimci, @divaconference 👩🎤✨ @PraguePgDevDay, @PrahaPostgreSQL 🐘
Pascal Theroux @PascalTheroux
0 Followers 265 Following
Bassompierre @MBassompierre67
27 Followers 1K Following
hamza @hamza_albderi
8 Followers 375 Following
ferkan @ferkan2694313
16 Followers 731 Following
bach @mbach01
13 Followers 297 Following
Osman DINC @InsaneDBA
212 Followers 1K Following I love and tame databases and share my knowledge on https://t.co/kDxrln8QHP
wormhole1026 @wormhole1026
5 Followers 358 Following
Aarti NR @AartiNadekar
13 Followers 94 Following
Dana Blanc @Dev1Dana
6 Followers 116 Following Backend developer with a knack for solving complex problems🕵️♀️
Hyderabad PUG @HyderabadPUG
7 Followers 59 Following
rough snape @roughsnape
9 Followers 171 Following
すばる 育児中3y @SubaruEkimemo
144 Followers 134 Following 駅メモ用のアカウントです。マスターID: NZTNIV5178 #情報処理安全確保支援士 の仲間を作りたい。
Teddy 🇪🇹 @_tedhub
18 Followers 1K Following Passionate software developer 💻 Creating beautiful designs and functional code that bring ideas to life.
Dan Peder Eriksen @DanPederEriksen
30 Followers 539 Following Tweeting about Cloud, Java and SQL (Postgresql) | Freelancer ex-@Cisco
Juan de la Cruz @jcmejia__
26 Followers 265 Following
Singaravelan @cssingaravelan
0 Followers 57 Following
Lanciaux Maxime @Lanciaux_Maxime
120 Followers 720 Following PPL, Biker & Data System Architect (#hadoop, #Teradata, #GoogleCloud, #PostgreSQL), #yougottofindwhatyoulove. #yourtimeislimited view expressed here are my own.
Shiv Iyer @thewebscaledba
1K Followers 4K Following Principal Data Architect | High-Concurrency Systems | Statistics | SQL | NoSQL | NewSQL | DBaaS | MinervaDB | ChistaDATA | OLTP | OLAP | ColumnStore | HTAP
Miguel Angel @maccgeo
33 Followers 1K Following
EdLauer @edulauer
69 Followers 465 Following
Andre Carvalho @andrecarvalhoac
36 Followers 423 Following
Stephen @friendstephen
300 Followers 2K Following
Anastasia 'Stacy' Ros... @efeiya_grassie
465 Followers 1K Following Head of Marketing with Vettabase Ltd. HAMMER GIRL. Charismarketer. World citizen. This account contains work stuff and personal causes. She/Her
Wes B. @Wfenc
36 Followers 2K Following
Oscar @oki_con
93 Followers 632 Following
Sami Jnih @sami_jnih
43 Followers 111 Following Behind the personal project "Paths of Oblivion" 1st EP "Forever Unknown" 2018: https://t.co/YlXXNtlZTe 2nd EP "Insurrection of Death" (WIP): 2025-2026!
Émerson Engroff 🌹 @eme3mil
206 Followers 5K Following
Gianni Oddone @GianniOddone
8 Followers 69 Following
Juan Rodriguez @jreinom
132 Followers 3K Following A linux administrator who enjoy the linux, opensource and development world.
Emil Janev @ejanev
723 Followers 5K Following #Macedonian Canadian, husband, father of three. Born in #Macedonia living in Canada
PGConf.Brasil @pgconfbr
573 Followers 487 Following O maior evento de #PostgreSQL da América Latina.
阿福Chris @mpplab
3 Followers 126 Following In small flippant attitude of the truth， in the event is not to be trusted.
Indalicio @inda_licio
915 Followers 2K Following Informático - motos y la cerveza artesanal - De River y de Chacarita de Aimogasta La Rioja Facebook: indaliciodeaimogasta
Todo PostgreSQL @todopostgresql
378 Followers 189 Following El lugar de internet para aprender PostgreSQL, desde 2015. Formación continua, online y presencial de nuestro Gestor de BBDD favorito. ¡Únete al club!
Mohamed aldoma @Mohamedaldoma2
6 Followers 301 Following
Carlos Abril @abril_developer
49 Followers 616 Following Desarrollador por mas de 20 años de aplicaciones Lotus Notes y Xpages, con JQuery, HTML, JavaScript, Java e interfaces a bases de datos relacionales usando DECs
Kuntal Ghosh @ghoshkuntal
125 Followers 198 Following SDE-III @ Aurora PostgreSQL. PostgreSQL hacker. Opinions are my own & do not represent Amazon’s position.
Wishful Hope @mixed_rally
149 Followers 408 Following An #intuitive mind, butterfly effect fan, behavioral #psychology! Wishful #writer.
PGConf ASIA @PGConfASIA
200 Followers 142 Following PostgreSQL Conference Asia 2018 10-12 DECEMBER 2018 AKIHABARA TOKYO JAPAN #pgconfasia
Potężny królik @Potezny_krolik
490 Followers 4K Following c̸͔̥̗̮̩̜̄̀͘ơ̴̧͇̥̟̮͔̝̙̹͖͉̺̣͎̣̽̅͒̂́͛͜͠d̴̠͇̠̣̰̭̊̈́͛̇̆̓͋͌̓̉͑̆̓̍͝ę̵̛͈̝̳̀͐̉̾̋̃͝͠r̸̛̠̮̳͔͖̳͈̄͌̐̍̽͐̐͝,̵̠͇̹͕̘͚̙̳̝̻͍̤̯͈͒͊́̀̚͝͠ ̵̡̪̪̞͗̔̇̑̏̍̆̚͘d̴̝̲͆̐̏̍́̒͆̑͒̕̚̚͠a̷͐͆͊̀̅̆́͒͘͝
AmiTechy @amitechy
7 Followers 112 Following
Kumar Babu PG @pulakunta
1 Followers 25 Following
Trends for United States
You might like
