Postgresql notes: Revision history

27 September 2017

• 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
• curprev 16:0116:01, 10 October 2016‎ Helpful talk contribs‎ m 85,586 bytes +2‎ →‎Estimating disk size of things
• curprev 16:0016:00, 10 October 2016‎ Helpful talk contribs‎ m 85,584 bytes +126‎ →‎Estimating disk size of things
• curprev 15:5915:59, 10 October 2016‎ Helpful talk contribs‎ m 85,458 bytes +1,466‎ →‎Estimating disk size of things
• curprev 14:2614:26, 10 October 2016‎ Helpful talk contribs‎ m 83,992 bytes +65‎ →‎TOAST
• curprev 14:2514:25, 10 October 2016‎ Helpful talk contribs‎ m 83,927 bytes −985‎ →‎TOAST, The Oversized-Attribute Storage Technique
• curprev 14:0614:06, 10 October 2016‎ Helpful talk contribs‎ m 84,912 bytes +7‎ →‎Estimating disk size of things
• curprev 14:0514:05, 10 October 2016‎ Helpful talk contribs‎ m 84,905 bytes +1,220‎ →‎Seeing what your server is up to

7 October 2016

• curprev 18:4018:40, 7 October 2016‎ Helpful talk contribs‎ m 83,685 bytes +977‎ →‎Semi-sorted

22 September 2016

• curprev 16:4216:42, 22 September 2016‎ Helpful talk contribs‎ m 82,708 bytes +2‎ →‎Memory related

3 August 2016

• curprev 16:5116:51, 3 August 2016‎ Helpful talk contribs‎ m 82,706 bytes −23‎ →‎Text indices and matching
• curprev 16:4916:49, 3 August 2016‎ Helpful talk contribs‎ m 82,729 bytes +925‎ →‎Indexes
• curprev 16:2016:20, 3 August 2016‎ Helpful talk contribs‎ m 81,804 bytes +1,278‎ →‎Usage notes

1 August 2016

• curprev 15:5115:51, 1 August 2016‎ Helpful talk contribs‎ m 80,526 bytes +170‎ →‎Indexes
• curprev 15:4815:48, 1 August 2016‎ Helpful talk contribs‎ m 80,356 bytes +1,626‎ →‎Indexes
• curprev 14:0314:03, 1 August 2016‎ Helpful talk contribs‎ m 78,730 bytes +74‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 14:0214:02, 1 August 2016‎ Helpful talk contribs‎ m 78,656 bytes +1,329‎ →‎Usage notes
• curprev 14:0114:01, 1 August 2016‎ Helpful talk contribs‎ m 77,327 bytes −1‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 14:0114:01, 1 August 2016‎ Helpful talk contribs‎ m 77,328 bytes −100‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 13:5913:59, 1 August 2016‎ Helpful talk contribs‎ m 77,428 bytes −1,323‎ →‎Roles
• curprev 13:5813:58, 1 August 2016‎ Helpful talk contribs‎ m 78,751 bytes +9‎ →‎"I installed the package, now what?"
• curprev 13:5813:58, 1 August 2016‎ Helpful talk contribs‎ m 78,742 bytes −51‎ →‎Set postgres role's password
• curprev 13:5613:56, 1 August 2016‎ Helpful talk contribs‎ m 78,793 bytes +329‎ →‎Location of postgres

27 July 2016

• curprev 19:0919:09, 27 July 2016‎ Helpful talk contribs‎ m 78,464 bytes +176‎ →‎Location of postgres
• curprev 19:0819:08, 27 July 2016‎ Helpful talk contribs‎ m 78,288 bytes +9‎ →‎"I installed the package, now what?"
• curprev 19:0819:08, 27 July 2016‎ Helpful talk contribs‎ m 78,279 bytes +40‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 19:0819:08, 27 July 2016‎ Helpful talk contribs‎ m 78,239 bytes +6‎ →‎consider creating roles, setting access privileges, and client auth settings
• curprev 19:0719:07, 27 July 2016‎ Helpful talk contribs‎ m 78,233 bytes +121‎ →‎consider creating roles
• curprev 19:0619:06, 27 July 2016‎ Helpful talk contribs‎ m 78,112 bytes −53‎ →‎roles (users/groups), permissions, and client auth
• curprev 19:0619:06, 27 July 2016‎ Helpful talk contribs‎ m 78,165 bytes +151‎ →‎roles (users/groups), permissions, and client auth
• curprev 19:0519:05, 27 July 2016‎ Helpful talk contribs‎ m 78,014 bytes −2‎ →‎Set postgres role's password
• curprev 19:0519:05, 27 July 2016‎ Helpful talk contribs‎ m 78,016 bytes +173‎ →‎Set postgres role's password
• curprev 19:0319:03, 27 July 2016‎ Helpful talk contribs‎ m 77,843 bytes +76‎ →‎Optional and sometimes useful: client authentication (pg_hba)
• curprev 19:0319:03, 27 July 2016‎ Helpful talk contribs‎ m 77,767 bytes +26‎ →‎Initial: set postgres role's password
• curprev 19:0219:02, 27 July 2016‎ Helpful talk contribs‎ m 77,741 bytes +465‎ →‎Debian/ubuntu only: clusters
• curprev 18:5918:59, 27 July 2016‎ Helpful talk contribs‎ m 77,276 bytes −161‎ →‎Initial: set postgres role's password
• curprev 18:5918:59, 27 July 2016‎ Helpful talk contribs‎ m 77,437 bytes +5,345‎ →‎Configuration/admin notes

25 July 2016

• curprev 19:0219:02, 25 July 2016‎ Helpful talk contribs‎ m 72,092 bytes +2‎ →‎TOAST, The Oversized-Attribute Storage Technique
• curprev 19:0219:02, 25 July 2016‎ Helpful talk contribs‎ m 72,090 bytes +15‎ →‎TOAST, The Oversized-Attribute Storage Technique
• curprev 19:0219:02, 25 July 2016‎ Helpful talk contribs‎ m 72,075 bytes +330‎ →‎Semi-sorted
• curprev 18:5518:55, 25 July 2016‎ Helpful talk contribs‎ m 71,745 bytes +93‎ →‎TOAST, The Oversized-Attribute Storage Technique
• curprev 18:5418:54, 25 July 2016‎ Helpful talk contribs‎ m 71,652 bytes +3,039‎ →‎Semi-sorted

14 May 2016

• curprev 16:5516:55, 14 May 2016‎ Helpful talk contribs‎ m 68,613 bytes +432‎ →‎Permission denied - Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

24 April 2016

• curprev 16:0516:05, 24 April 2016‎ Helpful talk contribs‎ m 68,181 bytes −34‎ →‎"idle" and "idle in transaction"

25 March 2016

• curprev 23:2023:20, 25 March 2016‎ Helpful talk contribs‎ m 68,215 bytes +24‎ →‎"idle" and "idle in transaction"
• curprev 21:4521:45, 25 March 2016‎ Helpful talk contribs‎ m 68,191 bytes +58‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 21:4521:45, 25 March 2016‎ Helpful talk contribs‎ m 68,133 bytes +38‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 21:4421:44, 25 March 2016‎ Helpful talk contribs‎ m 68,095 bytes +10‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 21:4421:44, 25 March 2016‎ Helpful talk contribs‎ m 68,085 bytes +21‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 21:3621:36, 25 March 2016‎ Helpful talk contribs‎ m 68,064 bytes +17‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"
• curprev 20:5020:50, 25 March 2016‎ Helpful talk contribs‎ m 68,047 bytes +397‎ →‎Permission denied - Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

24 January 2016

• curprev 22:0822:08, 24 January 2016‎ Helpful talk contribs‎ m 67,650 bytes +91‎ →‎"idle" and "idle in transaction"
• curprev 22:0722:07, 24 January 2016‎ Helpful talk contribs‎ m 67,559 bytes +243‎ →‎"idle" and "idle in transaction"

17 January 2016

• curprev 17:4117:41, 17 January 2016‎ Helpful talk contribs‎ m 67,316 bytes −3‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

7 January 2016

• curprev 17:1117:11, 7 January 2016‎ Helpful talk contribs‎ m 67,319 bytes +75‎ →‎"idle" and "idle in transaction"
• curprev 17:0917:09, 7 January 2016‎ Helpful talk contribs‎ m 67,244 bytes −48‎ →‎"idle" and "idle in transaction"

11 December 2015

• curprev 15:0515:05, 11 December 2015‎ Helpful talk contribs‎ m 67,292 bytes +850‎ →‎ERROR: current transaction is aborted, commands ignored until end of transaction block

1 September 2015

• curprev 13:2613:26, 1 September 2015‎ Helpful talk contribs‎ m 66,442 bytes +499‎ →‎Fill factor
• curprev 13:1913:19, 1 September 2015‎ Helpful talk contribs‎ m 65,943 bytes +152‎ →‎Fill factor

15 April 2015

• curprev 18:4518:45, 15 April 2015‎ Helpful talk contribs‎ m 65,791 bytes +237‎ →‎Understanding index use (well enough to start using EXPLAIN)
• curprev 18:3318:33, 15 April 2015‎ Helpful talk contribs‎ m 65,554 bytes −79‎ →‎Understanding index use (well enough to start using EXPLAIN)
• curprev 16:4216:42, 15 April 2015‎ Helpful talk contribs‎ m 65,633 bytes +46‎ →‎Rules
• curprev 16:1416:14, 15 April 2015‎ Helpful talk contribs‎ m 65,587 bytes +113‎ →‎Text indices and matching
• curprev 16:0216:02, 15 April 2015‎ Helpful talk contribs‎ m 65,474 bytes +224‎ →‎Indexes
• curprev 15:5915:59, 15 April 2015‎ Helpful talk contribs‎ m 65,250 bytes +4,353‎ →‎Understanding index use (well enough to start using EXPLAIN)

12 April 2015

• curprev 20:5520:55, 12 April 2015‎ Helpful talk contribs‎ m 60,897 bytes +4,115‎ →‎Understanding index use (well enough to start using EXPLAIN)
• curprev 16:3716:37, 12 April 2015‎ Helpful talk contribs‎ m 56,782 bytes +469‎ →‎Memory related
• curprev 15:3015:30, 12 April 2015‎ Helpful talk contribs‎ m 56,313 bytes +875‎ No edit summary
• curprev 15:1215:12, 12 April 2015‎ Helpful talk contribs‎ m 55,438 bytes +2,574‎ →‎Indexes
• curprev 14:2114:21, 12 April 2015‎ Helpful talk contribs‎ m 52,864 bytes +173‎ →‎Memory tables
• curprev 14:1214:12, 12 April 2015‎ Helpful talk contribs‎ m 52,691 bytes +878‎ →‎temporary tables

2 January 2015

• curprev 11:5511:55, 2 January 2015‎ Helpful talk contribs‎ m 51,813 bytes +302‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

1 January 2015

• curprev 22:4322:43, 1 January 2015‎ Helpful talk contribs‎ m 51,511 bytes +97‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

11 July 2014

• curprev 17:3517:35, 11 July 2014‎ Helpful talk contribs‎ m 51,414 bytes −2‎ →‎Full text search
• curprev 17:2017:20, 11 July 2014‎ Helpful talk contribs‎ m 51,416 bytes +6‎ →‎Full text search
• curprev 17:1917:19, 11 July 2014‎ Helpful talk contribs‎ m 51,410 bytes −549‎ →‎Full text search

4 January 2014

• curprev 17:3517:35, 4 January 2014‎ Helpful talk contribs‎ m 51,959 bytes +226‎ →‎Disk details: WAL, fsync, logging, separation of different writeables
• curprev 17:3217:32, 4 January 2014‎ Helpful talk contribs‎ m 51,733 bytes +438‎ →‎temporary tables
• curprev 17:2717:27, 4 January 2014‎ Helpful talk contribs‎ m 51,295 bytes +805‎ →‎Semi-sorted

31 December 2013

• curprev 15:4415:44, 31 December 2013‎ Helpful talk contribs‎ m 50,490 bytes +1,162‎ →‎Semi-sorted

9 July 2013

• curprev 14:2714:27, 9 July 2013‎ Helpful talk contribs‎ m 49,328 bytes +63‎ No edit summary

8 July 2013

• curprev 17:3517:35, 8 July 2013‎ Helpful talk contribs‎ m 49,265 bytes +639‎ No edit summary

30 June 2013

• curprev 11:0311:03, 30 June 2013‎ Helpful talk contribs‎ m 48,626 bytes +1,106‎ →‎Usage notes

27 June 2013

• curprev 16:1216:12, 27 June 2013‎ Helpful talk contribs‎ m 47,520 bytes −8‎ →‎Indexes

24 June 2013

• curprev 18:2718:27, 24 June 2013‎ Helpful talk contribs‎ m 47,528 bytes +1,714‎ →‎Full text search

23 June 2013

• curprev 14:4314:43, 23 June 2013‎ Helpful talk contribs‎ m 45,814 bytes +159‎ →‎Full text search
• curprev 14:2914:29, 23 June 2013‎ Helpful talk contribs‎ m 45,655 bytes +5,095‎ No edit summary
• curprev 12:4212:42, 23 June 2013‎ Helpful talk contribs‎ m 40,560 bytes +63‎ →‎Full text search
• curprev 12:4212:42, 23 June 2013‎ Helpful talk contribs‎ m 40,497 bytes +23‎ →‎Encodings
• curprev 12:4212:42, 23 June 2013‎ Helpful talk contribs‎ m 40,474 bytes 0‎ →‎Unsorted
• curprev 12:4012:40, 23 June 2013‎ Helpful talk contribs‎ m 40,474 bytes −323‎ →‎Disk details: WAL, fsync, logging, separation of different writeables
• curprev 12:2312:23, 23 June 2013‎ Helpful talk contribs‎ m 40,797 bytes −310‎ →‎Semi-sorted

9 April 2013

• curprev 01:2601:26, 9 April 2013‎ Helpful talk contribs‎ m 41,107 bytes +74‎ No edit summary

3 April 2013

• curprev 14:0514:05, 3 April 2013‎ Helpful talk contribs‎ m 41,033 bytes +1‎ →‎Example: Word counter
• curprev 14:0414:04, 3 April 2013‎ Helpful talk contribs‎ m 41,032 bytes −328‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

6 November 2012

• curprev 14:5614:56, 6 November 2012‎ Helpful talk contribs‎ m 41,360 bytes +33‎ →‎Indices

22 October 2012

• curprev 10:5610:56, 22 October 2012‎ Helpful talk contribs‎ m 41,327 bytes +107‎ →‎"idle in transaction"
• curprev 10:4110:41, 22 October 2012‎ Helpful talk contribs‎ m 41,220 bytes +254‎ →‎Semi-sorted

20 June 2012

• curprev 12:5212:52, 20 June 2012‎ Helpful talk contribs‎ m 40,966 bytes −27‎ →‎"idle in transaction"

18 June 2012

• curprev 15:4315:43, 18 June 2012‎ Helpful talk contribs‎ m 40,993 bytes −78‎ →‎Indexes
• curprev 13:3213:32, 18 June 2012‎ Helpful talk contribs‎ m 41,071 bytes +25‎ →‎serial, bigserial notes

16 June 2012

• curprev 16:1016:10, 16 June 2012‎ Helpful talk contribs‎ m 41,046 bytes +3,308‎ →‎Semi-sorted
• curprev 15:5815:58, 16 June 2012‎ Helpful talk contribs‎ m 37,738 bytes +1‎ →‎Rules

11 June 2012

• curprev 17:3317:33, 11 June 2012‎ Helpful talk contribs‎ m 37,737 bytes +27‎ →‎Indexes
• curprev 17:2817:28, 11 June 2012‎ Helpful talk contribs‎ m 37,710 bytes +259‎ →‎ERROR: current transaction is aborted, commands ignored until end of transaction block
• curprev 17:2417:24, 11 June 2012‎ Helpful talk contribs‎ m 37,451 bytes +18‎ →‎Example: Word counter
• curprev 16:5316:53, 11 June 2012‎ Helpful talk contribs‎ m 37,433 bytes +2,726‎ →‎Indexes
• curprev 15:4915:49, 11 June 2012‎ Helpful talk contribs‎ m 34,707 bytes +1,121‎ No edit summary

13 May 2012

• curprev 15:3515:35, 13 May 2012‎ Helpful talk contribs‎ m 33,586 bytes +821‎ No edit summary
• curprev 03:2203:22, 13 May 2012‎ Helpful talk contribs‎ m 32,765 bytes −292‎ No edit summary

11 May 2012

• curprev 15:5215:52, 11 May 2012‎ Helpful talk contribs‎ m 33,057 bytes +771‎ →‎Disk details: WAL, fsync, logging, separation of different writeables
• curprev 14:4014:40, 11 May 2012‎ Helpful talk contribs‎ m 32,286 bytes +472‎ →‎WAL

10 May 2012

• curprev 03:0503:05, 10 May 2012‎ Helpful talk contribs‎ m 31,814 bytes −14‎ →‎Disk details: fsync, logging, separation of different writeables

9 May 2012

• curprev 22:2822:28, 9 May 2012‎ Helpful talk contribs‎ m 31,828 bytes +1,035‎ →‎WAL

7 May 2012

• curprev 04:0104:01, 7 May 2012‎ Helpful talk contribs‎ m 30,793 bytes +187‎ →‎WAL

3 May 2012

• curprev 20:1820:18, 3 May 2012‎ Helpful talk contribs‎ m 30,606 bytes +47‎ →‎Memory related
• curprev 17:3217:32, 3 May 2012‎ Helpful talk contribs‎ m 30,559 bytes +63‎ →‎Memory related
• curprev 16:4716:47, 3 May 2012‎ Helpful talk contribs‎ m 30,496 bytes −157‎ →‎Memory related

2 May 2012

• curprev 17:0217:02, 2 May 2012‎ Helpful talk contribs‎ m 30,653 bytes −67‎ →‎pg_hba

22 September 2011

• curprev 01:1301:13, 22 September 2011‎ Helpful talk contribs‎ m 30,720 bytes 0‎ →‎Rules

13 July 2011

• curprev 11:5911:59, 13 July 2011‎ Helpful talk contribs‎ m 30,720 bytes +253‎ →‎Text and character notes

10 January 2011

• curprev 21:5621:56, 10 January 2011‎ Helpful talk contribs‎ m 30,467 bytes +30,467‎ →‎Permission denied - Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?