Random bits of info that I want to be able to locate in the future. Might be tech related, sports, photography, whatever. The name? Combination of photography and soccer.
Starting in the 4.x release, you get size info from the gp_toolkit schema. To get the size of all databases and their size in bytes: select sodddatname, sodddatasize from gp_toolkit.gp_size_database; To see the database size in GB, TB, and/or MB. TB: select sodddatname, (sodddatsize/1073741824)/1024 AS sizeinTB from gp_toolkit.gp_size_of_database; GB: select sodddatname, (sodddatsize/1073741824) AS sizeinGB from gp_toolkit.gp_size_of_database; MB: select sodddatname, (sodddatsize/1048576) AS sizeinMB from gp_toolkit.gp_size_of_database; For schema sizes , connect to your database and run: TB: select sosdnsp, (sosdschematablesize/1073741824)/1024 AS schemasizeinTB from gp_toolkit.gp_size_of_schema_disk; GB: select sosdnsp, (sosdschematablesize/1073741824) AS schemasizeinGB from gp_toolkit.gp_size_of_schema_disk; MB: select sosdnsp, (sosdschematablesize/1048576) AS schemasizeinMB from gp_toolkit.gp_size_of_schema_disk; If you want a specific schema only, add ...
I was trying to rsync some iTunes music to an SD card from my Mac. All was working well but all the files were being synced each time. Turns out it's an issue with a Microsoft(FAT32) formatted card, which my Samsung Intercept has. Answer was to add --modify-window=1 as an rsync option. Solution here .
Ever try to run ssh-add and get this message? Could not open a connection to your authentication agent Run this command exec ssh-agent /bin/bash or just add that to your .bash_profile so it runs on login.
Comments
Post a Comment