tuning   11482

« earlier    

The 15-minute Chromebook tune-up | Computerworld
Make your Chromebook faster, smarter, and more pleasant to use with these easy-to-follow annual steps.
chromebook  tuning  performance  tip 
2 days ago by gilberto5757
Postgres Weekly Issue 288: January 16, 2019
💡 Tip of the Week
Finding which tables need extra indexes

pg_stat_user_tables is a fantastic system view that can show us invaluable information about the tables in our databases and can be used in diagnosing performance issues. Vacuum statistics like last_autovacuum and n_dead_tup will show if there are tables that aren’t being vacuumed efficiently and n_tup_hot_upd if you aren't performing HOT updates.

One of the things to look for first, though, is if there are tables that need new indexes as this can have a significant impact on your database's overall performance:

SELECT relname,
    seq_scan,
    seq_tup_read,
    idx_scan
FROM pg_stat_user_tables
WHERE seq_scan > 0
ORDER BY 3 DESC LIMIT 10;

This simple query will help highlight tables that are heavy on sequential scans and potential candidates for adding an index.

By looking at the seq_scan results, you can see precisely how many sequential scans have happened on a table. Then looking at seq_tup_read you can see how many tuples are being read during those scans. If those numbers are significantly higher on certain tables, some further indexes may be badly needed.
Postgres  Performance  Tuning  DataModeling 
3 days ago by cnk
Is Your Postgres Query Starved for Memory? - DZone Database
Article covering what work_mem is exactly and how it works.
postgres  tuning  article 
11 days ago by csharpsteen

« earlier    

related tags

-  10  2002  2012  administration  ai  aleksi  analysis  and  apache  archery  article  auidio  automobile  autovacuum  aws  bass  bassbauer  benchmark  blog  bmw  build  cache  capo  car  ceph  cgroups  chaos  chapter  choice  chromebook  classic  colundi  config  configuration  container  containers  controlled  curve  database  datamodeling  dba  deployment  devops  diy  docker  documentation  dr-elephant  drums  ebay  ebook  ecm  eks  elasticsearch  elk  engine  envoy  eurobsdcon  fahrradio  faults  filesystem  flask  freebsd  freeipa  freenas  fuel-system  gauge  github  guide  guitar  ha  hackintosh  hadoop  haproxy  hard_hack  hbase  heap  high  history  hive  hortonworks  howto  ifttt  improve  indexes  instrumentenbauer  intervals  java  javascript  jetting  joni  just_intonation  justintonation  jvm  keys  kispolszki  kubernetes  language  laptop  linkedin  linux  logstash  lower  luthier  macbook  machine-learning  macos  martin  matuska  meditation  memory  mitchell  mods  monitoring  mssql  music  mysql  net  netflix  network  networking  nginx  numa  odroid  on  oom  open  openc  opencv  operating  operations  optimization  options  oracle  origo  os  overview  ovuca  parameter  part  path  pd  performance  perl  phoenix  plug  pocket  postgres  postgresql  presentation  prime  processors  production  profiling  project  puredata  puthon  rails  raspberry_pi  reading  redhat  reference  restauration  rhel  ruby  s7  samsung  scalability  scale  scales  script  series  settings  shop  shuffling  sidecars  site  slides  slow  snowflake  spark  speed  sql  ssl  sssd  sysadmin  syscalls  temperament  termperament  tez  that  theory  timbre  time  tip  tips  tolearn  tonymacx86.  tool  torque  torquecars  totry  tounderstand  tune  tuner  turbo  utility  vacuum  vertica  video  vw  web  windows  with  wsgi  x  xcode  zfs  | 

Copy this bookmark:



description:


tags: