Guest User

Why is PostgreSQL eating up all my precious HD space

a guest
Feb 27th, 2012
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  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);
Add Comment
Please, Sign In to add comment