Category: databases

dstat and disk device names

by Karanbir Singh Email

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

by Karanbir Singh Email

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 »