huaweigu

git clean -xfd
git submodule foreach --recursive git clean -xfd
git reset --hard
git submodule foreach --recursive git reset --hard
git submodule update --init --recursive

huaweigu

1. table and index hit
with stats as (
  with table_stats as (
    select psut.relname,
      psut.n_live_tup,
      1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio
    from pg_stat_user_tables psut
    where schemaname = 'txcore'
    order by psut.n_live_tup desc
  ),

huaweigu

Steps to generate self-signed PKCS#12 SSL certificate and export its keys:

1- Create PKCS#12 keystore (.p12 or .pfx file)

keytool -genkeypair -keystore myKeystore.p12 -storetype PKCS12 -storepass MY_PASSWORD -alias KEYSTORE_ENTRY -keyalg RSA -keysize 2048 -validity 99999 -dname "CN=My SSL Certificate, OU=My Team, O=My Company, L=My City, ST=My State, C=SA" -ext san=dns:mydomain.com,dns:localhost,ip:127.0.0.1

• myKeystore.p12 = keystore filename. It can with .pfx extension as well.
• MY_PASSWORD = password used for the keystore and the private key as well.
• CN = commonName, it will be shown as certiciate name in certificates list.
• OU = organizationUnit, department name for example.

huaweigu

Separate subject from body with a blank line
Limit the subject line to 50 characters
Capitalize the subject line
Do not end the subject line with a period
Use the imperative mood in the subject line
Wrap the body at 72 characters
Use the body to explain what and why vs. how

More: https://chris.beams.io/posts/git-commit/

huaweigu

Safe Operations For High Volume PostgreSQL

Safe

• Add a new column
• Drop a column
• Rename a column
• Add an index concurrently (Example), Note: it will still take a long time to run the migration, but it won't write-lock the table.
• Drop a constraint (for example, non-nullable)
• Add a default value to an existing column

huaweigu

DO $$
  DECLARE updated_rows INT;
  BEGIN

    UPDATE some_table
    SET some_column = 'new'
    WHERE some_column = 'old';

    GET DIAGNOSTICS updated_rows = ROW_COUNT;