Picture

Postgres TOTD @postgres_totd

Postgres Tweet of the Day Joined March 2009
  • Tweets
    74
  • Followers
    479
  • Following
    1
  • Likes
    0
postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Use the 'END' as a shortcut for context-sensitive COMMIT or ROLLBACK.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: VACUUM FULL and REINDEX do heavy locking, but with autovacuum you should rarely need them.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Logging can go through syslog: control the facility and ident via postgresql.conf.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Postgres 8.4 has a backwards-compatible psql, including backslash commands (finally!)

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: A table can be physically reordered based on an index with the CLUSTER command. http://tr.im/sI5d

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: 8.4 has windowing functions: see how they compare to other dbs: http://tr.im/snRO

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

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 Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: View PostgreSQL information in a format similar to the Unix tool 'top' with pg_top: http://tr.im/pNXr

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Postgres 8.4 gets rid of max_fsm_pages and max_fsm_relations. Two less knobs to worry about!

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Postgres natively supports many DTrace probes as of version 8.2. http://tr.im/pvPk

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Don't kill -9 backends. Postgres will survive, but other clients may have to reconnect.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: LEFT and RIGHT joins are equivalent, so always use LEFT joins to reduce confusion. http://tr.im/oS3I

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

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 Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Make sure you run a global ANALYZE after restoring a database or any other large data import.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: When working on someone else's system, call psql with -X to bypass any unknown conf files.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: In psql, see how fast all your queries take by toggling \timing on.

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

16 years ago

Postgres TOTD: Temporary tables can be set as ON COMMIT DELETE to automatically remove them. http://tr.im/nXRC

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

17 years ago

Postgres TOTD: Starting in PostgreSQL version 8.4, you can use ON TRUNCATE triggers. http://tr.im/nQ7I

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

17 years ago

Postgres TOTD: One of the many languages available for PostgreSQL functions is LOLCODE. http://tr.im/nAjS (YA RLY!)

postgres_totd Profile Picture

Postgres TOTD @postgres_totd

17 years ago

Postgres TOTD: When writing functions, put the LANGUAGE declaration with the rest of the metadata at the top.

Trends for United States

Dansby
2.916 posts
Cubs
27,8 B posts
Tigers
59,9 B posts
Michael Busch
Tatis
3.201 posts
Jihad
68,8 B posts
Darvish
3.905 posts
Padres
45,6 B posts
#RepDetroit
2.659 posts
Taillon
2.781 posts
Arraez
1.405 posts
Guardians
18,8 B posts
Project 2025
129 B posts
Robert Morris
7.343 posts
Estrada
10,8 B posts
#BO7Beta
2.910 posts
#BuiltForOctober
5.323 posts
ALDS
8.383 posts
charli
40,7 B posts
Perez
48 B posts

You might like

The oldest Postgres company in North America, offering Postgres full stack support, consulting, and development. Do you want a vendor or a partner in success?
Command Prompt, Inc.
@cmdpromptinc
1K Followers
I help people Postgres. I enjoy root beer & road trips. My favorite colour is Amber. #WebOps #DBRE #pgtreats #🥑
xzilla
@robtreat2
1K Followers
Twój jedyny portal pracy w branży tech w tym pięknym kraju nad Wisłą ( ͡° ͜ʖ ͡°) 🇵🇱🚀
Just Join IT
@Just_Join_IT
4K Followers
👨🏽‍💻Software developer. 🐘PostgreSQL contributor. 🇧🇷 Goiano. Goianiense. 🔴⚫ACG-GO.
Euler Taveira
@eulerto
440 Followers