Skip to content

Instantly share code, notes, and snippets.

View jlaffaye's full-sized avatar

Julien Laffaye jlaffaye

View GitHub Profile
@jlaffaye
jlaffaye / OVH_FREEBSD_RAIDZ.md
Created November 22, 2018 19:17
How to install FreeBSD with RAIDZ on OVH

On commence par dézinguer tous les anciens pools ZFS :

zpool import -fR /mnt zroot zpool destroy zroot

On crée ensuite les partitions qui vont bien aller :

une partition de boot de 512ko
une partition de swap de 2Go

le reste en partition de pool ZFS

Keybase proof

I hereby claim:

  • I am jlaffaye on github.
  • I am jlaffaye (https://keybase.io/jlaffaye) on keybase.
  • I have a public key ASCuxEJLmr787Fti-sz-T9EB_u-kvYGxvj8zNXdkjuyzqQo

To claim this, I am signing this object:

@jlaffaye
jlaffaye / postgres_table_size.sql
Created January 12, 2016 18:22
PostgreSQL Table Size
SELECT
relname as "Table",
pg_size_pretty(pg_total_relation_size(relid)) As "Size",
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;