postgres   18128

« earlier    

A command-line GO Postgres query visualizer, heavily inspired by the excellent (web-based) pev
postgres  sql  utility  visualization 
yesterday by joecamel
Faster Operations with the JSONB Data Type in PostgreSQL - Compose Articles
book_id serial NOT NULL,
data jsonb

INSERT INTO books VALUES (1, '{"title": "Sleeping Beauties", "genres": ["Fiction", "Thriller", "Horror"], "published": false}');
INSERT INTO books VALUES (2, '{"title": "Influence", "genres": ["Marketing & Sales", "Self-Help ", "Psychology"], "published": true}');
INSERT INTO books VALUES (3, '{"title": "The Dictator''s Handbook", "genres": ["Law", "Politics"], "authors": ["Bruce Bueno de Mesquita", "Alastair Smith"], "published": true}');
INSERT INTO books VALUES (4, '{"title": "Deep Work", "genres": ["Productivity", "Reference"], "published": true}');
INSERT INTO books VALUES (5, '{"title": "Siddhartha", "genres": ["Fiction", "Spirituality"], "published": true}');

SELECT data->'title' AS title FROM books;

SELECT * FROM books WHERE data->'published' = 'false';

SELECT jsonb_array_elements_text(data->'genres') AS genre
FROM books
WHERE book_id = 1;
jsonb  json  postgres  sql  database 
3 days ago by dza
pg_repack 1.4.1 -- Reorganize tables in PostgreSQL databases with minimal locks
"pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly."
pg_repack  postgres  postgresql 
3 days ago by anl

« earlier    

related tags

2017-10-01  2017-10-03  5*  acid  analytics  architecture  art  autovacuum  backend  backup  books  cache  caching  celery  cli  client  cloverpos  columnar  command_line_tools  condition  contribution-opportunity  count  dashboards  data  database-migrations  database  databases  db  dbadmin  debugging  depth  design  dev  distributed-systems  django  dump  elasticsearch  event  event_sourcing  events  explain  feedly  finitestatemachine  full  fulltext  functions  gis  gitlab  google  grafana  gui  guide  gzip  hacker_news  hash  heap  hn  hstore  hypopg  hypothetical  ifttt  import  in-depth  in  indepth  index  indexes  information  interface  javascript  job  jobs  json  jsonb  kafka  location  machine-learning  madusudanan  maps  microservices  monitoring  monitorng  mysql  node  nosql  open_source  optimization  oss  page  pagination  paging  performance  pg_repack  pocket  postgresql  presentation  prior  profiling  programming  psg  psql  python  queue  race  radius  rails  redhat  redshift  release  repl  ruby-on-rails  saas  scaling  search  sql  strategies  techniques  tenant  text  timeseries  tips  tool  tools  tsdb  tuning  used-this  utility  vacuum  videos  visualization  visualizations  visualizer  webapps  window  wraparound  xid  zfs 

Copy this bookmark: