postgresql   30643

« earlier    

Useful PostgreSQL Queries and Commands
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
14 hours ago by jonesch
tax deductable donations to software projects
Some open source projects (like LibreOffice or PostgreSQL) can be donated to in a tax-deductible fashion through this non-profit.
libreoffice  opensource  taxes  postgresql 
16 hours ago by mcherm
PostgreSQL rocks, except when it blocks: Understanding locks
Handy, covers PG locking discussions I normally have with developers :)
One problem I often see users struggle with when it comes to Postgres is locks. While Postgres is amazing at running multiple operations at the same time, there are a few cases in which Postgres needs to block an operation using a lock. You therefore have to be careful about which locks your transactions take, but with the high-level abstractions that PostgreSQL provides, it can be difficult to know exactly what will happen. This post aims to demystify the locking behaviors in Postgres, and to give advice on how to avoid common problems.
postgres  postgresql 
3 days ago by micktwomey

« earlier    

related tags

admin  advanced  advocacy  algorithm  analytics  appget  apply  architecture  article  aurora  author  aws  backup  bestpractice  bigdata  blocked  book  books  browser  caching  client  clojure  confguration  config  counting  dao  data  database  datascience  db  dbadmin  docker  ecto  editor  elixir  explain  fdw  feature  fiction  floss  functions  generator  golang  graphql  gtd  gui  hierarchical  homebrew  howto  index  intro  javascript  json  lambda  lateraljoin  learning  libreoffice  list  locking  locks  logging  ltree  macos  migrations  monitoring  multitenant  mysql  opensource  optimization  orm  performance  pgadmin4  pl/pgsql  postgres  postgresweekly  presentation  programming  psql  querytool  rails  rdbms  rdbms_tool  realtime  redis  reference  replace  rest  ruby  scalability  science  sequel  settings  sharding  size  slides  software  sql  sqlite  sqlserver  ssl  standard  statistics  storage  streaming  substring  table  tableplus  taxes  testing  text  tipps  tips  tool  tools  tree  tuning  tutorial  usage  window  windows  zabbix  zfs 

Copy this bookmark: