Pinned Loading

1. PostgreSQL: index stats PostgreSQL: index stats

   1

   SELECT

   2

       psui.relname AS table_name,

   3

       pg_size_pretty(pg_relation_size(psui.relid)) AS table_size,

   4

       psui.indexrelname AS index_name,

   5

       psui.idx_scan AS index_scans_count,

2. PostgreSQL: duplicate a row multiple... PostgreSQL: duplicate a row multiple times

   1

   CREATE TEMPORARY TABLE temporary_table AS SELECT * FROM <my_table> WHERE <condition>;

   2

   3

   -- Remove any columns that will cause a constraint error when re-inserting the row

   4

   ALTER TABLE temporary_table DROP COLUMN id;

   5

3. xxhashct xxhashct Public

   Forked from ekpyron/xxhashct

   Compile time implementation of the xxHash algorithm as C++11 constexpr expression.

   C++