Category: databases
dstat and disk device names
Running dstat normally gives you something like this :
# dstat --nocolor
----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system--
usr sys idl wai hiq siq| read writ| recv send| in out | int csw
3 0 97 0 0 0| 820k… more »
Removing lots of data from a DB table
If you need to remove large amounts of data from a table ( specially when you need to remove *all* the data in a table), remember its faster to drop the table, and recreate it rather than doing a 'delete from tablename;'.
eg: this is against a postgre… more »
12/Jun/2009 11:04:37 am, 