| Description | Command |
|---|---|
| Start a new session with session name | screen -S <session_name> |
| List running sessions / screens | screen -ls |
| Attach to a running session | screen -x |
| Attach to a running session with name | screen -r |
Diego Benedicto diegobenedicto
henriquemenezes
/ postgresql-set-id-seq.sql
Created
March 31, 2016 12:23
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Get Max ID from table | |
| SELECT MAX(id) FROM table; | |
| -- Get Next ID from table | |
| SELECT nextval('table_id_seq'); | |
| -- Set Next ID Value to MAX ID | |
| SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Tips to inspect memory usage in Chrome | |
| 1. Tools/Task Manager: | |
| In the table header, select context menu (right click) | |
| Select JavaScript Memory | |
| Now the table will show how much memory is used by every Chrome tab. | |
| 2. Inspect JavaScript heap memory usage | |
| Start Chrome from the command line with this argument: --enable-memory-info | |
| For example on a Mac, it could be: |