6 June 2011

PostgreSQL - Calculating DB size

SQL> select pg_size_pretty(pg_database_size(current_database())) as dbsize
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Wordpress - Local installation in Vmware

If you're interested in exploring website design with WordPress, this guide will help you set up a WordPress instance on your local mach...

  • LINUX - awk
    To print single column from a text file #awk -F: '{print $1}' /etc/passwd To print multiple columns from a text file # awk -F: '...
  • LINUX - netstat
    1. Using Netstat to Count TCP Connection States netstat -an|awk '/tcp/ {print $6}'|sort|uniq -c 2. List TCP/UDP and it's PID net...
  • POSTGRESQL - Comparison between PostgreSQL vs EDB Postgres Advanced Server
    Your new IT project requires you to setup postgresql database and most of the time we get to the postgresql website and download the version...