This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Why is PostgreSQL eating up all my precious HD space

By: a guest on Feb 27th, 2012  |  syntax: None  |  size: 0.19 KB  |  views: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT pl_namespace, COUNT(*) FROM pagelinks GROUP BY (pl_namespace);
  2.        
  3. SELECT pl_namespace, COUNT(*)
  4. FROM pagelinks
  5. WHERE pl_namespace between 1 and 50000000
  6. GROUP BY (pl_namespace);
clone this paste RAW Paste Data