Postgresql notes: Revision history

8 August 2018

• curprev 11:5111:51, 8 August 2018‎ Helpful talk contribs‎ m 117,253 bytes +57‎ →‎Check that you can log in
• curprev 11:4911:49, 8 August 2018‎ Helpful talk contribs‎ m 117,196 bytes −202‎ →‎If your packager didn't: create postgres database

7 August 2018

• curprev 17:3817:38, 7 August 2018‎ Helpful talk contribs‎ m 117,398 bytes +15‎ →‎pg_hba
• curprev 17:3717:37, 7 August 2018‎ Helpful talk contribs‎ m 117,383 bytes +62‎ →‎pg_hba
• curprev 17:3617:36, 7 August 2018‎ Helpful talk contribs‎ m 117,321 bytes +431‎ →‎pg_hba
• curprev 17:1417:14, 7 August 2018‎ Helpful talk contribs‎ m 116,890 bytes +12‎ →‎pg_hba
• curprev 17:1317:13, 7 August 2018‎ Helpful talk contribs‎ m 116,878 bytes +27‎ →‎pg_hba
• curprev 17:1117:11, 7 August 2018‎ Helpful talk contribs‎ m 116,851 bytes +6‎ →‎On peer auth (and ident)
• curprev 17:0917:09, 7 August 2018‎ Helpful talk contribs‎ m 116,845 bytes +30‎ →‎FATAL: Peer authentication failed for user "postgres"
• curprev 16:5916:59, 7 August 2018‎ Helpful talk contribs‎ m 116,815 bytes −21‎ →‎FATAL: Ident authentication failed for user "postgres"
• curprev 16:5816:58, 7 August 2018‎ Helpful talk contribs‎ m 116,836 bytes −104‎ →‎FATAL: Ident authentication failed for user "postgres"
• curprev 16:5616:56, 7 August 2018‎ Helpful talk contribs‎ m 116,940 bytes +272‎ →‎On peer auth (and ident)
• curprev 16:5216:52, 7 August 2018‎ Helpful talk contribs‎ m 116,668 bytes +237‎ →‎On peer auth (and ident)
• curprev 13:5813:58, 7 August 2018‎ Helpful talk contribs‎ m 116,431 bytes +35‎ →‎On peer auth (and ident)
• curprev 13:5513:55, 7 August 2018‎ Helpful talk contribs‎ m 116,396 bytes −38‎ →‎pg_hba

12 July 2018

• curprev 16:2316:23, 12 July 2018‎ Helpful talk contribs‎ m 116,434 bytes −74‎ →‎Proximity matching, weighed terms, and ranking

11 July 2018

• curprev 15:3515:35, 11 July 2018‎ Helpful talk contribs‎ m 116,508 bytes +40‎ →‎Proximity matching, weighed terms, and ranking
• curprev 15:1915:19, 11 July 2018‎ Helpful talk contribs‎ m 116,468 bytes +12‎ →‎Proximity matching, weighed terms, and ranking
• curprev 15:1815:18, 11 July 2018‎ Helpful talk contribs‎ m 116,456 bytes −178‎ →‎Proximity matching, weighed terms, and ranking
• curprev 15:1315:13, 11 July 2018‎ Helpful talk contribs‎ m 116,634 bytes +69‎ →‎Search syntax
• curprev 15:1115:11, 11 July 2018‎ Helpful talk contribs‎ m 116,565 bytes −27‎ →‎Search syntax
• curprev 15:1115:11, 11 July 2018‎ Helpful talk contribs‎ m 116,592 bytes −68‎ →‎Practical details - indices, columns, regconfigs
• curprev 15:0815:08, 11 July 2018‎ Helpful talk contribs‎ m 116,660 bytes −7‎ →‎Practical details - indices, columns, regconfigs
• curprev 15:0315:03, 11 July 2018‎ Helpful talk contribs‎ m 116,667 bytes +14‎ →‎Practical details - indices, columns, regconfigs
• curprev 14:5314:53, 11 July 2018‎ Helpful talk contribs‎ m 116,653 bytes −285‎ →‎Full text search notes

3 July 2018

• curprev 19:0019:00, 3 July 2018‎ Helpful talk contribs‎ m 116,938 bytes −2‎ →‎pgadmin notes and errors
• curprev 19:0019:00, 3 July 2018‎ Helpful talk contribs‎ m 116,940 bytes +1,902‎ →‎pg_hba
• curprev 15:1515:15, 3 July 2018‎ Helpful talk contribs‎ m 115,038 bytes +7‎ →‎FATAL: Peer authentication failed for user "postgres"

28 June 2018

• curprev 15:3815:38, 28 June 2018‎ Helpful talk contribs‎ m 115,031 bytes −127‎ →‎"idle" and "idle in transaction"
• curprev 15:2815:28, 28 June 2018‎ Helpful talk contribs‎ m 115,158 bytes +40‎ →‎On prewarming caches with indices and/or data
• curprev 15:2715:27, 28 June 2018‎ Helpful talk contribs‎ m 115,118 bytes +181‎ →‎FATAL: Peer authentication failed for user "postgres"
• curprev 15:1915:19, 28 June 2018‎ Helpful talk contribs‎ m 114,937 bytes +170‎ →‎Use notes
• curprev 14:5214:52, 28 June 2018‎ Helpful talk contribs‎ m 114,767 bytes +9‎ →‎FATAL: Peer authentication failed for user "postgres"

13 June 2018

• curprev 12:5412:54, 13 June 2018‎ Helpful talk contribs‎ m 114,758 bytes 0‎ →‎logging
• curprev 12:3112:31, 13 June 2018‎ Helpful talk contribs‎ m 114,758 bytes +104‎ →‎logging
• curprev 12:3012:30, 13 June 2018‎ Helpful talk contribs‎ m 114,654 bytes +24‎ →‎logging
• curprev 12:3012:30, 13 June 2018‎ Helpful talk contribs‎ m 114,630 bytes +1,178‎ →‎planner costs

13 May 2018

• curprev 18:0418:04, 13 May 2018‎ Helpful talk contribs‎ m 113,452 bytes +254‎ →‎Understanding EXPLAIN / things to rewrite / cases where an index is good
• curprev 18:0318:03, 13 May 2018‎ Helpful talk contribs‎ m 113,198 bytes 0‎ →‎Understanding EXPLAIN / things to rewrite / cases where an index is good
• curprev 18:0218:02, 13 May 2018‎ Helpful talk contribs‎ m 113,198 bytes +79‎ →‎Understanding EXPLAIN / things to rewrite / cases where an index is good
• curprev 18:0118:01, 13 May 2018‎ Helpful talk contribs‎ m 113,119 bytes +86‎ →‎Understanding EXPLAIN / things to rewrite / cases where an index is good
• curprev 18:0018:00, 13 May 2018‎ Helpful talk contribs‎ m 113,033 bytes +979‎ →‎Understanding EXPLAIN
• curprev 14:4814:48, 13 May 2018‎ Helpful talk contribs‎ m 112,054 bytes +1‎ →‎Upserts
• curprev 14:4814:48, 13 May 2018‎ Helpful talk contribs‎ m 112,053 bytes −288‎ →‎Upserts
• curprev 14:4314:43, 13 May 2018‎ Helpful talk contribs‎ m 112,341 bytes −3‎ →‎psql
• curprev 14:4314:43, 13 May 2018‎ Helpful talk contribs‎ m 112,344 bytes −2‎ →‎If your packager didn't: create postgres database
• curprev 14:4114:41, 13 May 2018‎ Helpful talk contribs‎ m 112,346 bytes +3‎ →‎"I installed the package, now what?"
• curprev 14:4114:41, 13 May 2018‎ Helpful talk contribs‎ m 112,343 bytes −160‎ →‎Optional: creating roles, setting access privileges, and client auth settings
• curprev 14:3214:32, 13 May 2018‎ Helpful talk contribs‎ m 112,503 bytes +329‎ →‎Optional: Set password
• curprev 14:2914:29, 13 May 2018‎ Helpful talk contribs‎ m 112,174 bytes +200‎ →‎If your packager didn't: create postgres database
• curprev 14:2614:26, 13 May 2018‎ Helpful talk contribs‎ m 111,974 bytes −304‎ →‎Others
• curprev 14:1914:19, 13 May 2018‎ Helpful talk contribs‎ m 112,278 bytes +15‎ →‎Debian/ubuntu only: clusters
• curprev 14:1814:18, 13 May 2018‎ Helpful talk contribs‎ m 112,263 bytes −1‎ →‎Debian/ubuntu only: clusters
• curprev 14:1714:17, 13 May 2018‎ Helpful talk contribs‎ m 112,264 bytes +200‎ →‎Others
• curprev 14:1414:14, 13 May 2018‎ Helpful talk contribs‎ m 112,064 bytes +10‎ →‎maintenance_work_mem
• curprev 14:1414:14, 13 May 2018‎ Helpful talk contribs‎ m 112,054 bytes +13‎ →‎maintenance_work_mem
• curprev 14:1314:13, 13 May 2018‎ Helpful talk contribs‎ m 112,041 bytes −16‎ →‎work_mem

12 May 2018

• curprev 14:0914:09, 12 May 2018‎ Helpful talk contribs‎ m 112,057 bytes −54‎ →‎Understanding index use (well enough to start using EXPLAIN)

8 May 2018

• curprev 13:1413:14, 8 May 2018‎ Helpful talk contribs‎ m 112,111 bytes +58‎ →‎psql

5 May 2018

• curprev 19:3419:34, 5 May 2018‎ Helpful talk contribs‎ m 112,053 bytes +141‎ →‎shared_buffers
• curprev 19:2819:28, 5 May 2018‎ Helpful talk contribs‎ m 111,912 bytes +1,367‎ →‎Memory related

11 March 2018

• curprev 23:4623:46, 11 March 2018‎ Helpful talk contribs‎ m 110,545 bytes +11‎ →‎Tweaking
• curprev 22:2422:24, 11 March 2018‎ Helpful talk contribs‎ m 110,534 bytes +459‎ →‎Tweaking
• curprev 21:3121:31, 11 March 2018‎ Helpful talk contribs‎ m 110,075 bytes +560‎ →‎Separating different IO streams

7 March 2018

• curprev 11:3511:35, 7 March 2018‎ Helpful talk contribs‎ m 109,515 bytes +57‎ →‎FATAL: Ident authentication failed for user "postgres"

28 February 2018

• curprev 18:2718:27, 28 February 2018‎ Helpful talk contribs‎ m 109,458 bytes +377‎ →‎Errors

27 February 2018

• curprev 17:2517:25, 27 February 2018‎ Helpful talk contribs‎ m 109,081 bytes +94‎ →‎row sizes
• curprev 17:2217:22, 27 February 2018‎ Helpful talk contribs‎ m 108,987 bytes −2‎ →‎Estimating disk size of things
• curprev 17:2217:22, 27 February 2018‎ Helpful talk contribs‎ m 108,989 bytes −8‎ →‎Optional: Set password
• curprev 17:2117:21, 27 February 2018‎ Helpful talk contribs‎ m 108,997 bytes −41‎ →‎Others
• curprev 17:1717:17, 27 February 2018‎ Helpful talk contribs‎ m 109,038 bytes −237‎ →‎work_mem
• curprev 17:1217:12, 27 February 2018‎ Helpful talk contribs‎ m 109,275 bytes +26‎ →‎shared_buffers
• curprev 17:1117:11, 27 February 2018‎ Helpful talk contribs‎ m 109,249 bytes −382‎ →‎shared_buffers
• curprev 01:1901:19, 27 February 2018‎ Helpful talk contribs‎ m 109,631 bytes −7‎ →‎Variations for specific uses
• curprev 01:1901:19, 27 February 2018‎ Helpful talk contribs‎ m 109,638 bytes +37‎ →‎Variations for specific uses
• curprev 00:3600:36, 27 February 2018‎ Helpful talk contribs‎ m 109,601 bytes +205‎ →‎Variations in use

7 February 2018

• curprev 17:4517:45, 7 February 2018‎ Helpful talk contribs‎ m 109,396 bytes +43‎ →‎On TOAST
• curprev 17:4217:42, 7 February 2018‎ Helpful talk contribs‎ m 109,353 bytes +262‎ →‎On TOAST
• curprev 17:3617:36, 7 February 2018‎ Helpful talk contribs‎ m 109,091 bytes +623‎ →‎Use notes
• curprev 16:5816:58, 7 February 2018‎ Helpful talk contribs‎ m 108,468 bytes +411‎ →‎pg_hba
• curprev 16:5016:50, 7 February 2018‎ Helpful talk contribs‎ m 108,057 bytes +17‎ →‎FATAL: Peer authentication failed for user "postgres"
• curprev 16:5016:50, 7 February 2018‎ Helpful talk contribs‎ m 108,040 bytes +41‎ →‎FATAL: Ident authentication failed for user "postgres"

6 February 2018

• curprev 19:0519:05, 6 February 2018‎ Helpful talk contribs‎ m 107,999 bytes +2‎ →‎pg_hba
• curprev 19:0419:04, 6 February 2018‎ Helpful talk contribs‎ m 107,997 bytes +4,012‎ →‎Semi-sorted
• curprev 18:5218:52, 6 February 2018‎ Helpful talk contribs‎ m 103,985 bytes −3,139‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 18:3918:39, 6 February 2018‎ Helpful talk contribs‎ m 107,124 bytes +39‎ →‎Optional: creating roles, setting access privileges, and client auth settings
• curprev 18:3718:37, 6 February 2018‎ Helpful talk contribs‎ m 107,085 bytes +36‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 18:2718:27, 6 February 2018‎ Helpful talk contribs‎ m 107,049 bytes +23‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 18:1018:10, 6 February 2018‎ Helpful talk contribs‎ m 107,026 bytes +12‎ →‎Upserts
• curprev 17:3917:39, 6 February 2018‎ Helpful talk contribs‎ m 107,014 bytes +8‎ →‎pg_dump / pg_dumpall notes
• curprev 17:3917:39, 6 February 2018‎ Helpful talk contribs‎ m 107,006 bytes +165‎ →‎pg_dump / pg_dumpall notes
• curprev 17:2617:26, 6 February 2018‎ Helpful talk contribs‎ m 106,841 bytes +249‎ →‎pg_dump / pg_dumpall notes
• curprev 17:1217:12, 6 February 2018‎ Helpful talk contribs‎ m 106,592 bytes +155‎ →‎Replication, Backup
• curprev 16:4916:49, 6 February 2018‎ Helpful talk contribs‎ m 106,437 bytes −13‎ →‎On TOAST
• curprev 16:4816:48, 6 February 2018‎ Helpful talk contribs‎ m 106,450 bytes +44‎ →‎On TOAST
• curprev 16:4716:47, 6 February 2018‎ Helpful talk contribs‎ m 106,406 bytes +3,436‎ →‎Seeing what your server is up to
• curprev 16:4616:46, 6 February 2018‎ Helpful talk contribs‎ m 102,970 bytes −3,433‎ →‎"idle" and "idle in transaction"
• curprev 16:4616:46, 6 February 2018‎ Helpful talk contribs‎ m 106,403 bytes +1,560‎ →‎On large binary / text data
• curprev 16:4616:46, 6 February 2018‎ Helpful talk contribs‎ m 104,843 bytes −2,071‎ →‎On LO
• curprev 16:3516:35, 6 February 2018‎ Helpful talk contribs‎ m 106,914 bytes +35‎ →‎On TOAST
• curprev 16:3516:35, 6 February 2018‎ Helpful talk contribs‎ m 106,879 bytes +2,094‎ →‎On TOAST
• curprev 16:3416:34, 6 February 2018‎ Helpful talk contribs‎ m 104,785 bytes −2,101‎ →‎On binary data
• curprev 16:3416:34, 6 February 2018‎ Helpful talk contribs‎ m 106,886 bytes +1,383‎ →‎Architecture, and disk related details
• curprev 16:3416:34, 6 February 2018‎ Helpful talk contribs‎ m 105,503 bytes −1,399‎ →‎Fill factor
• curprev 16:3316:33, 6 February 2018‎ Helpful talk contribs‎ m 106,902 bytes −45‎ →‎Full text search notes
• curprev 16:3316:33, 6 February 2018‎ Helpful talk contribs‎ m 106,947 bytes +12,458‎ →‎Semi-sorted
• curprev 16:3316:33, 6 February 2018‎ Helpful talk contribs‎ m 94,489 bytes −12,453‎ →‎Full text search
• curprev 16:2616:26, 6 February 2018‎ Helpful talk contribs‎ m 106,942 bytes +72‎ →‎RHEL
• curprev 16:2316:23, 6 February 2018‎ Helpful talk contribs‎ m 106,870 bytes +62‎ →‎Debian/ubuntu only: clusters

20 January 2018

• curprev 20:0820:08, 20 January 2018‎ Helpful talk contribs‎ m 106,808 bytes +94‎ →‎Full text search

18 January 2018

• curprev 19:5619:56, 18 January 2018‎ Helpful talk contribs‎ m 106,714 bytes +89‎ →‎Practical details - indices, columns, regconfigs
• curprev 19:5019:50, 18 January 2018‎ Helpful talk contribs‎ m 106,625 bytes +27‎ →‎Practical details - indices, columns, regconfigs
• curprev 19:4919:49, 18 January 2018‎ Helpful talk contribs‎ m 106,598 bytes +25‎ →‎Practical details - indices, columns, regconfigs
• curprev 19:4819:48, 18 January 2018‎ Helpful talk contribs‎ m 106,573 bytes +1‎ →‎Basic guts
• curprev 19:4819:48, 18 January 2018‎ Helpful talk contribs‎ m 106,572 bytes +1‎ →‎Basic guts
• curprev 19:4819:48, 18 January 2018‎ Helpful talk contribs‎ m 106,571 bytes +33‎ →‎Basic guts
• curprev 19:4719:47, 18 January 2018‎ Helpful talk contribs‎ m 106,538 bytes +3‎ →‎Basic guts

27 September 2017

• curprev 20:1720:17, 27 September 2017‎ Helpful talk contribs‎ m 106,535 bytes +53‎ →‎Other notes
• curprev 01:0701:07, 27 September 2017‎ Helpful talk contribs‎ m 106,482 bytes +61‎ →‎Understanding index use (well enough to start using EXPLAIN)
• curprev 01:0301:03, 27 September 2017‎ Helpful talk contribs‎ m 106,421 bytes +102‎ →‎column sizes
• curprev 00:5900:59, 27 September 2017‎ Helpful talk contribs‎ m 106,319 bytes +30‎ →‎row sizes
• curprev 00:5700:57, 27 September 2017‎ Helpful talk contribs‎ m 106,289 bytes +114‎ →‎table and index size
• curprev 00:5400:54, 27 September 2017‎ Helpful talk contribs‎ m 106,175 bytes +1‎ →‎table and indices
• curprev 00:5300:53, 27 September 2017‎ Helpful talk contribs‎ m 106,174 bytes +6‎ →‎Estimating disk size of things
• curprev 00:5200:52, 27 September 2017‎ Helpful talk contribs‎ m 106,168 bytes +63‎ →‎Seeing what your server is up to

26 September 2017

• curprev 23:2423:24, 26 September 2017‎ Helpful talk contribs‎ m 106,105 bytes +92‎ →‎On prewarming caches with indices and/or data
• curprev 21:2521:25, 26 September 2017‎ Helpful talk contribs‎ m 106,013 bytes +495‎ →‎Date math
• curprev 17:2917:29, 26 September 2017‎ Helpful talk contribs‎ m 105,518 bytes +18‎ →‎Disk details: WAL, fsync, logging
• curprev 17:2617:26, 26 September 2017‎ Helpful talk contribs‎ m 105,500 bytes −12‎ →‎Disk details: WAL, fsync, logging
• curprev 17:2617:26, 26 September 2017‎ Helpful talk contribs‎ m 105,512 bytes +15‎ →‎Disk details: WAL, fsync, logging
• curprev 17:2517:25, 26 September 2017‎ Helpful talk contribs‎ m 105,497 bytes +2‎ →‎Disk details: WAL, fsync, logging
• curprev 17:2517:25, 26 September 2017‎ Helpful talk contribs‎ m 105,495 bytes −384‎ →‎Disk details: WAL, fsync, logging, separation of different writeables

25 September 2017

• curprev 17:2617:26, 25 September 2017‎ Helpful talk contribs‎ m 105,879 bytes +389‎ →‎Warnings
• curprev 17:1317:13, 25 September 2017‎ Helpful talk contribs‎ m 105,490 bytes −21‎ →‎Disk details: WAL, fsync, logging, separation of different writeables

22 September 2017

• curprev 21:1621:16, 22 September 2017‎ Helpful talk contribs‎ m 105,511 bytes +674‎ →‎Errors

12 September 2017

• curprev 11:3011:30, 12 September 2017‎ Helpful talk contribs‎ m 104,837 bytes +1,162‎ →‎Text and character notes
• curprev 11:0211:02, 12 September 2017‎ Helpful talk contribs‎ m 103,675 bytes −300‎ No edit summary

8 August 2017

• curprev 16:1816:18, 8 August 2017‎ Helpful talk contribs‎ m 103,975 bytes +2‎ →‎On TOAST
• curprev 16:0916:09, 8 August 2017‎ Helpful talk contribs‎ m 103,973 bytes +6‎ →‎On TOAST
• curprev 15:3715:37, 8 August 2017‎ Helpful talk contribs‎ m 103,967 bytes +209‎ →‎On TOAST
• curprev 15:3515:35, 8 August 2017‎ Helpful talk contribs‎ m 103,758 bytes +10‎ →‎On TOAST
• curprev 15:3115:31, 8 August 2017‎ Helpful talk contribs‎ m 103,748 bytes +14‎ →‎On TOAST
• curprev 15:3115:31, 8 August 2017‎ Helpful talk contribs‎ m 103,734 bytes −19‎ →‎On TOAST
• curprev 15:3115:31, 8 August 2017‎ Helpful talk contribs‎ m 103,753 bytes +836‎ →‎On TOAST

1 August 2017

• curprev 17:2917:29, 1 August 2017‎ Helpful talk contribs‎ m 102,917 bytes 0‎ →‎On TOAST
• curprev 17:2817:28, 1 August 2017‎ Helpful talk contribs‎ m 102,917 bytes −5‎ →‎On TOAST
• curprev 17:2817:28, 1 August 2017‎ Helpful talk contribs‎ m 102,922 bytes +90‎ →‎On TOAST
• curprev 17:1917:19, 1 August 2017‎ Helpful talk contribs‎ m 102,832 bytes +965‎ →‎On TOAST

31 July 2017

• curprev 15:3615:36, 31 July 2017‎ Helpful talk contribs‎ m 101,867 bytes −23‎ →‎On TOAST
• curprev 14:2314:23, 31 July 2017‎ Helpful talk contribs‎ m 101,890 bytes +34‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)
• curprev 14:2214:22, 31 July 2017‎ Helpful talk contribs‎ m 101,856 bytes −24‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

17 July 2017

• curprev 15:1815:18, 17 July 2017‎ Helpful talk contribs‎ m 101,880 bytes +806‎ →‎On binary data

16 July 2017

• curprev 16:4316:43, 16 July 2017‎ Helpful talk contribs‎ m 101,074 bytes +9‎ →‎other disk-related details

15 July 2017

• curprev 21:1421:14, 15 July 2017‎ Helpful talk contribs‎ m 101,065 bytes +725‎ →‎Semi-sorted
• curprev 13:1013:10, 15 July 2017‎ Helpful talk contribs‎ m 100,340 bytes +14‎ →‎Memory tables

27 June 2017

• curprev 11:4311:43, 27 June 2017‎ Helpful talk contribs‎ m 100,326 bytes −24‎ →‎Encodings
• curprev 11:4111:41, 27 June 2017‎ Helpful talk contribs‎ m 100,350 bytes +21‎ →‎Unicode
• curprev 11:4011:40, 27 June 2017‎ Helpful talk contribs‎ m 100,329 bytes +1,285‎ →‎Encodings

25 June 2017

• curprev 14:3114:31, 25 June 2017‎ Helpful talk contribs‎ m 99,044 bytes +6‎ →‎On TOAST

24 June 2017

• curprev 14:4214:42, 24 June 2017‎ Helpful talk contribs‎ m 99,038 bytes −26‎ →‎On TOAST
• curprev 14:3414:34, 24 June 2017‎ Helpful talk contribs‎ m 99,064 bytes +291‎ →‎On TOAST
• curprev 14:1314:13, 24 June 2017‎ Helpful talk contribs‎ m 98,773 bytes +10‎ →‎"I installed the package, now what?"

6 June 2017

• curprev 15:1315:13, 6 June 2017‎ Helpful talk contribs‎ m 98,763 bytes −70‎ →‎Practical details - indices, columns, regconfigs
• curprev 15:0915:09, 6 June 2017‎ Helpful talk contribs‎ m 98,833 bytes +17‎ →‎Practical details - indices, columns, regconfigs
• curprev 14:3714:37, 6 June 2017‎ Helpful talk contribs‎ m 98,816 bytes +117‎ →‎Full text search
• curprev 14:3414:34, 6 June 2017‎ Helpful talk contribs‎ m 98,699 bytes +93‎ →‎Full text search

9 May 2017

• curprev 17:0617:06, 9 May 2017‎ Helpful talk contribs‎ m 98,606 bytes +1,356‎ →‎Optional: creating roles, setting access privileges, and client auth settings
• curprev 16:1216:12, 9 May 2017‎ Helpful talk contribs‎ m 97,250 bytes +143‎ →‎data types
• curprev 16:1016:10, 9 May 2017‎ Helpful talk contribs‎ m 97,107 bytes −1,488‎ →‎Notes on roles
• curprev 16:1016:10, 9 May 2017‎ Helpful talk contribs‎ m 98,595 bytes −2‎ →‎Usage notes

8 May 2017

• curprev 15:0315:03, 8 May 2017‎ Helpful talk contribs‎ m 98,597 bytes +617‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 10:5010:50, 8 May 2017‎ Helpful talk contribs‎ m 97,980 bytes +86‎ →‎Optional: consider creating roles, setting access privileges, and client auth settings
• curprev 10:4510:45, 8 May 2017‎ Helpful talk contribs‎ m 97,894 bytes −53‎ →‎Optional but sometimes useful: set access privileges
• curprev 10:4510:45, 8 May 2017‎ Helpful talk contribs‎ m 97,947 bytes −2‎ →‎Optional but sometimes useful: set access privileges
• curprev 10:4310:43, 8 May 2017‎ Helpful talk contribs‎ m 97,949 bytes +1‎ →‎Optional: consider creating roles, setting access privileges, and client auth settings
• curprev 10:4210:42, 8 May 2017‎ Helpful talk contribs‎ m 97,948 bytes +8‎ →‎Optional: Set password

4 May 2017

• curprev 20:4320:43, 4 May 2017‎ Helpful talk contribs‎ m 97,940 bytes +258‎ No edit summary

3 May 2017

• curprev 13:2613:26, 3 May 2017‎ Helpful talk contribs‎ m 97,682 bytes +60‎ →‎On binary data

2 May 2017

• curprev 21:1521:15, 2 May 2017‎ Helpful talk contribs‎ m 97,622 bytes −122‎ →‎Search syntax
• curprev 18:0318:03, 2 May 2017‎ Helpful talk contribs‎ m 97,744 bytes +186‎ →‎Practical details - indices, columns, regconfigs
• curprev 16:0916:09, 2 May 2017‎ Helpful talk contribs‎ m 97,558 bytes +15‎ →‎work_mem
• curprev 16:0516:05, 2 May 2017‎ Helpful talk contribs‎ m 97,543 bytes +145‎ →‎Memory tables
• curprev 16:0316:03, 2 May 2017‎ Helpful talk contribs‎ m 97,398 bytes +22‎ →‎work_mem
• curprev 15:5915:59, 2 May 2017‎ Helpful talk contribs‎ m 97,376 bytes +1,104‎ →‎temporary tables
• curprev 15:4815:48, 2 May 2017‎ Helpful talk contribs‎ m 96,272 bytes −1‎ →‎Memory tables

22 April 2017

• curprev 02:5402:54, 22 April 2017‎ Helpful talk contribs‎ m 96,273 bytes +38‎ →‎Practical details - indices, columns, regconfigs

18 April 2017

• curprev 13:5413:54, 18 April 2017‎ Helpful talk contribs‎ m 96,235 bytes +13‎ →‎Search syntax
• curprev 13:5313:53, 18 April 2017‎ Helpful talk contribs‎ m 96,222 bytes +5‎ →‎Search syntax
• curprev 13:5213:52, 18 April 2017‎ Helpful talk contribs‎ m 96,217 bytes +1‎ →‎Search syntax
• curprev 13:5213:52, 18 April 2017‎ Helpful talk contribs‎ m 96,216 bytes +2‎ →‎Search syntax
• curprev 13:5113:51, 18 April 2017‎ Helpful talk contribs‎ m 96,214 bytes +832‎ →‎Search syntax
• curprev 10:2810:28, 18 April 2017‎ Helpful talk contribs‎ m 95,382 bytes +17‎ →‎Basic guts
• curprev 10:2710:27, 18 April 2017‎ Helpful talk contribs‎ m 95,365 bytes +229‎ →‎Practical details - indices, columns, regconfigs
• curprev 10:2610:26, 18 April 2017‎ Helpful talk contribs‎ m 95,136 bytes −310‎ →‎Basic matching
• curprev 02:0002:00, 18 April 2017‎ Helpful talk contribs‎ m 95,446 bytes +83‎ →‎Indices on tsvectors - practical details
• curprev 01:5801:58, 18 April 2017‎ Helpful talk contribs‎ m 95,363 bytes +566‎ →‎Indices on tsvectors - practical details
• curprev 01:4901:49, 18 April 2017‎ Helpful talk contribs‎ m 94,797 bytes +781‎ →‎On indices and tsvectors

11 April 2017

• curprev 13:2413:24, 11 April 2017‎ Helpful talk contribs‎ m 94,016 bytes +159‎ →‎Notes on roles

10 April 2017

• curprev 19:1519:15, 10 April 2017‎ Helpful talk contribs‎ m 93,857 bytes +77‎ →‎"I installed the package, now what?"
• curprev 19:1519:15, 10 April 2017‎ Helpful talk contribs‎ m 93,780 bytes +215‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 19:1119:11, 10 April 2017‎ Helpful talk contribs‎ m 93,565 bytes +229‎ →‎Set postgres role's password
• curprev 19:0919:09, 10 April 2017‎ Helpful talk contribs‎ m 93,336 bytes +25‎ →‎Create postgres database
• curprev 17:2517:25, 10 April 2017‎ Helpful talk contribs‎ m 93,311 bytes −18‎ →‎Set postgres role's password
• curprev 16:0216:02, 10 April 2017‎ Helpful talk contribs‎ m 93,329 bytes +57‎ →‎See also
• curprev 16:0216:02, 10 April 2017‎ Helpful talk contribs‎ m 93,272 bytes +9‎ →‎Proximity matching, weighed terms, and ranking
• curprev 16:0116:01, 10 April 2017‎ Helpful talk contribs‎ m 93,263 bytes −5‎ →‎On indices and tsvectors
• curprev 15:5315:53, 10 April 2017‎ Helpful talk contribs‎ m 93,268 bytes +3,089‎ →‎Full text search

9 April 2017

• curprev 15:1415:14, 9 April 2017‎ Helpful talk contribs‎ m 90,179 bytes +500‎ →‎Notes on performance and innards
• curprev 04:3504:35, 9 April 2017‎ Helpful talk contribs‎ m 89,679 bytes −65‎ →‎"idle" and "idle in transaction"
• curprev 04:3104:31, 9 April 2017‎ Helpful talk contribs‎ m 89,744 bytes −35‎ →‎"idle" and "idle in transaction"
• curprev 04:3004:30, 9 April 2017‎ Helpful talk contribs‎ m 89,779 bytes −183‎ →‎"idle" and "idle in transaction"

29 March 2017

• curprev 13:4213:42, 29 March 2017‎ Helpful talk contribs‎ m 89,962 bytes +25‎ →‎ENUM
• curprev 13:4113:41, 29 March 2017‎ Helpful talk contribs‎ m 89,937 bytes +601‎ →‎ENUM

13 February 2017

• curprev 21:2521:25, 13 February 2017‎ Helpful talk contribs‎ m 89,336 bytes +89‎ →‎Estimating disk size of things
• curprev 20:4220:42, 13 February 2017‎ Helpful talk contribs‎ m 89,247 bytes −8‎ →‎Estimating disk size of things
• curprev 20:4120:41, 13 February 2017‎ Helpful talk contribs‎ m 89,255 bytes +1,138‎ →‎Estimating disk size of things
• curprev 15:3815:38, 13 February 2017‎ Helpful talk contribs‎ m 88,117 bytes +138‎ →‎Estimating disk size of things

11 February 2017

• curprev 19:1819:18, 11 February 2017‎ Helpful talk contribs‎ m 87,979 bytes +56‎ →‎Full text search
• curprev 19:1819:18, 11 February 2017‎ Helpful talk contribs‎ m 87,923 bytes −13‎ →‎Full text search
• curprev 18:3218:32, 11 February 2017‎ Helpful talk contribs‎ m 87,936 bytes +2,569‎ →‎data types
• curprev 18:3218:32, 11 February 2017‎ Helpful talk contribs‎ m 85,367 bytes −2,568‎ →‎TOAST
• curprev 18:3218:32, 11 February 2017‎ Helpful talk contribs‎ m 87,935 bytes +281‎ →‎data types
• curprev 18:3118:31, 11 February 2017‎ Helpful talk contribs‎ m 87,654 bytes −280‎ →‎on ENUM
• curprev 18:2918:29, 11 February 2017‎ Helpful talk contribs‎ m 87,934 bytes +280‎ →‎Semi-sorted
• curprev 18:2618:26, 11 February 2017‎ Helpful talk contribs‎ m 87,654 bytes +412‎ →‎Estimating disk size of things

9 January 2017

• curprev 18:2718:27, 9 January 2017‎ Helpful talk contribs‎ m 87,242 bytes −3‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)
• curprev 18:1818:18, 9 January 2017‎ Helpful talk contribs‎ m 87,245 bytes +209‎ →‎Memory related

8 January 2017

• curprev 19:3519:35, 8 January 2017‎ Helpful talk contribs‎ m 87,036 bytes +112‎ →‎No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 19:2519:25, 8 January 2017‎ Helpful talk contribs‎ m 86,924 bytes +88‎ →‎No PostgreSQL clusters exist; see "man pg_createcluster"

4 January 2017

• curprev 17:0217:02, 4 January 2017‎ Helpful talk contribs‎ m 86,836 bytes +20‎ →‎Other notes
• curprev 16:5816:58, 4 January 2017‎ Helpful talk contribs‎ m 86,816 bytes +49‎ →‎TOAST
• curprev 16:5716:57, 4 January 2017‎ Helpful talk contribs‎ m 86,767 bytes 0‎ →‎TOAST
• curprev 16:5716:57, 4 January 2017‎ Helpful talk contribs‎ m 86,767 bytes −36‎ →‎TOAST
• curprev 16:5416:54, 4 January 2017‎ Helpful talk contribs‎ m 86,803 bytes +2‎ →‎TOAST

17 December 2016

• curprev 17:1117:11, 17 December 2016‎ Helpful talk contribs‎ m 86,801 bytes −13‎ →‎"idle" and "idle in transaction"

24 October 2016

• curprev 17:0417:04, 24 October 2016‎ Helpful talk contribs‎ m 86,814 bytes +203‎ →‎"idle" and "idle in transaction"

15 October 2016

• curprev 14:3314:33, 15 October 2016‎ Helpful talk contribs‎ m 86,611 bytes +99‎ →‎Upserts
• curprev 12:3012:30, 15 October 2016‎ Helpful talk contribs‎ m 86,512 bytes −13‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 12:2612:26, 15 October 2016‎ Helpful talk contribs‎ m 86,525 bytes +1‎ →‎Set postgres role's password
• curprev 12:2612:26, 15 October 2016‎ Helpful talk contribs‎ m 86,524 bytes −26‎ →‎Create postgres database

14 October 2016

• curprev 14:2614:26, 14 October 2016‎ Helpful talk contribs‎ m 86,550 bytes +158‎ →‎Estimating disk size of things
• curprev 14:2414:24, 14 October 2016‎ Helpful talk contribs‎ m 86,392 bytes +15‎ →‎Estimating disk size of things

11 October 2016

• curprev 18:0718:07, 11 October 2016‎ Helpful talk contribs‎ m 86,377 bytes +209‎ →‎Indexes
• curprev 18:0018:00, 11 October 2016‎ Helpful talk contribs‎ m 86,168 bytes +94‎ →‎Date and time notes
• curprev 17:5317:53, 11 October 2016‎ Helpful talk contribs‎ m 86,074 bytes +422‎ →‎When/why is an index not used?

10 October 2016

• curprev 16:1116:11, 10 October 2016‎ Helpful talk contribs‎ m 85,652 bytes −14‎ →‎Fast count from a table
• curprev 16:1116:11, 10 October 2016‎ Helpful talk contribs‎ m 85,666 bytes +44‎ →‎Fast count from a table
• curprev 16:0316:03, 10 October 2016‎ Helpful talk contribs‎ m 85,622 bytes 0‎ →‎Fast count from a table
• curprev 16:0216:02, 10 October 2016‎ Helpful talk contribs‎ m 85,622 bytes +30‎ →‎Fill factor
• curprev 16:0116:01, 10 October 2016‎ Helpful talk contribs‎ m 85,592 bytes +6‎ →‎Estimating disk size of things