Postgresql notes: Revision history

19 March 2024

• curprev 17:3517:35, 19 March 2024‎ Helpful talk contribs‎ m 148,796 bytes +2‎ →‎WARNING: there is already a transaction in progress
• curprev 17:3517:35, 19 March 2024‎ Helpful talk contribs‎ m 148,794 bytes +15‎ →‎WARNING: there is already a transaction in progress
• curprev 17:3517:35, 19 March 2024‎ Helpful talk contribs‎ m 148,779 bytes +13‎ →‎WARNING: there is already a transaction in progress

22 January 2024

• curprev 17:0117:01, 22 January 2024‎ Helpful talk contribs‎ m 148,766 bytes +14‎ →‎Optional: Set password
• curprev 17:0017:00, 22 January 2024‎ Helpful talk contribs‎ m 148,752 bytes +117‎ →‎Check that you can log in
• curprev 17:0017:00, 22 January 2024‎ Helpful talk contribs‎ m 148,635 bytes 0‎ →‎Check that you can log in
• curprev 17:0017:00, 22 January 2024‎ Helpful talk contribs‎ m 148,635 bytes +11‎ →‎Check that you can log in
• curprev 16:5916:59, 22 January 2024‎ Helpful talk contribs‎ m 148,624 bytes +5‎ →‎If your package makes you care: Clusters

29 November 2023

• curprev 11:3611:36, 29 November 2023‎ Helpful talk contribs‎ m 148,619 bytes +24‎ →‎Others
• curprev 11:3411:34, 29 November 2023‎ Helpful talk contribs‎ m 148,595 bytes +45‎ →‎maintenance_work_mem
• curprev 10:5610:56, 29 November 2023‎ Helpful talk contribs‎ m 148,550 bytes +76‎ →‎maintenance_work_mem
• curprev 10:5610:56, 29 November 2023‎ Helpful talk contribs‎ m 148,474 bytes +15‎ →‎work_mem

9 July 2023

• curprev 19:0819:08, 9 July 2023‎ Helpful talk contribs‎ m 148,459 bytes +110‎ No edit summary

25 March 2023

• curprev 03:0503:05, 25 March 2023‎ Helpful talk contribs‎ m 148,349 bytes +20‎ →‎table and index size

24 March 2023

• curprev 19:2219:22, 24 March 2023‎ Helpful talk contribs‎ m 148,329 bytes +189‎ →‎On large binary/text data; LO versus TOAST

30 January 2023

• curprev 12:4512:45, 30 January 2023‎ Helpful talk contribs‎ m 148,140 bytes −3‎ →‎Memory use

23 November 2022

• curprev 15:1215:12, 23 November 2022‎ Helpful talk contribs‎ m 148,143 bytes +50‎ →‎Basic guts
• curprev 14:5014:50, 23 November 2022‎ Helpful talk contribs‎ m 148,093 bytes +146‎ →‎Basic guts

21 November 2022

• curprev 16:5816:58, 21 November 2022‎ Helpful talk contribs‎ m 147,947 bytes −22‎ →‎Pooling
• curprev 16:5716:57, 21 November 2022‎ Helpful talk contribs‎ m 147,969 bytes +2,212‎ →‎pgpool

14 September 2022

• curprev 13:5013:50, 14 September 2022‎ Helpful talk contribs‎ m 145,757 bytes +131‎ →‎pg_dump / pg_dumpall notes

11 September 2022

• curprev 16:5716:57, 11 September 2022‎ Helpful talk contribs‎ m 145,626 bytes +151‎ →‎Errors

8 September 2022

• curprev 17:4617:46, 8 September 2022‎ Helpful talk contribs‎ m 145,475 bytes −1‎ →‎If your package makes you care: Clusters
• curprev 17:4617:46, 8 September 2022‎ Helpful talk contribs‎ m 145,476 bytes +41‎ →‎If your package makes you care: Clusters
• curprev 17:4317:43, 8 September 2022‎ Helpful talk contribs‎ m 145,435 bytes +4‎ →‎If your package makes you care: Clusters

27 August 2022

• curprev 20:3820:38, 27 August 2022‎ Helpful talk contribs‎ m 145,431 bytes +556‎ →‎Fast count from a table
• curprev 20:3520:35, 27 August 2022‎ Helpful talk contribs‎ m 144,875 bytes +1‎ →‎If your package makes you care: Clusters

22 August 2022

• curprev 10:5710:57, 22 August 2022‎ Helpful talk contribs‎ m 144,874 bytes −2‎ →‎(If your package makes you care:) Clusters
• curprev 10:5710:57, 22 August 2022‎ Helpful talk contribs‎ m 144,876 bytes +14‎ →‎(If your package makes you care:) Clusters
• curprev 10:5710:57, 22 August 2022‎ Helpful talk contribs‎ m 144,862 bytes +253‎ →‎(If your package makes you care:) Clusters
• curprev 10:5010:50, 22 August 2022‎ Helpful talk contribs‎ m 144,609 bytes +22‎ →‎(If your package makes you care:) Clusters
• curprev 10:4910:49, 22 August 2022‎ Helpful talk contribs‎ m 144,587 bytes −1‎ →‎(If your package makes you care:) Clusters=
• curprev 10:4910:49, 22 August 2022‎ Helpful talk contribs‎ m 144,588 bytes −24‎ →‎(If your packager didn't:) create postgres database
• curprev 10:4810:48, 22 August 2022‎ Helpful talk contribs‎ m 144,612 bytes +491‎ →‎See also (install)
• curprev 10:4610:46, 22 August 2022‎ Helpful talk contribs‎ m 144,121 bytes −104‎ →‎Create database
• curprev 10:4610:46, 22 August 2022‎ Helpful talk contribs‎ m 144,225 bytes 0‎ →‎create database
• curprev 10:4610:46, 22 August 2022‎ Helpful talk contribs‎ m 144,225 bytes +105‎ →‎Check that you can log in
• curprev 10:4410:44, 22 August 2022‎ Helpful talk contribs‎ m 144,120 bytes +360‎ →‎(If your packager didn't:) create postgres database
• curprev 10:4110:41, 22 August 2022‎ Helpful talk contribs‎ m 143,760 bytes −386‎ →‎Databases
• curprev 10:4110:41, 22 August 2022‎ Helpful talk contribs‎ m 144,146 bytes +316‎ →‎(If your packager didn't:) create postgres database
• curprev 10:1810:18, 22 August 2022‎ Helpful talk contribs‎ m 143,830 bytes +20‎ →‎(If your packager didn't:) create postgres database
• curprev 10:1710:17, 22 August 2022‎ Helpful talk contribs‎ m 143,810 bytes −1‎ →‎"I installed the package, now what?"

26 June 2022

• curprev 01:0101:01, 26 June 2022‎ Helpful talk contribs‎ m 143,811 bytes +36‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

21 June 2022

• curprev 01:1101:11, 21 June 2022‎ Helpful talk contribs‎ m 143,775 bytes +1,241‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

20 May 2022

• curprev 01:1601:16, 20 May 2022‎ Helpful talk contribs‎ m 142,534 bytes +66‎ →‎Disk details: WAL, fsync, logging

19 May 2022

• curprev 23:1123:11, 19 May 2022‎ Helpful talk contribs‎ m 142,468 bytes −13‎ →‎Architecture, and disk related details
• curprev 23:1123:11, 19 May 2022‎ Helpful talk contribs‎ m 142,481 bytes −453‎ →‎Table fill factor
• curprev 23:0723:07, 19 May 2022‎ Helpful talk contribs‎ m 142,934 bytes −1‎ →‎Indices
• curprev 23:0623:06, 19 May 2022‎ Helpful talk contribs‎ m 142,935 bytes −126‎ →‎Cost-Based Vacuum Delay
• curprev 23:0623:06, 19 May 2022‎ Helpful talk contribs‎ m 143,061 bytes +43‎ →‎Cost-Based Vacuum Delay
• curprev 23:0123:01, 19 May 2022‎ Helpful talk contribs‎ m 143,018 bytes +54‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

18 May 2022

• curprev 17:0617:06, 18 May 2022‎ Helpful talk contribs‎ m 142,964 bytes +20‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)
• curprev 16:2616:26, 18 May 2022‎ Helpful talk contribs‎ m 142,944 bytes +811‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

16 May 2022

• curprev 19:4119:41, 16 May 2022‎ Helpful talk contribs‎ m 142,133 bytes +248‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

8 May 2022

• curprev 18:0118:01, 8 May 2022‎ Helpful talk contribs‎ m 141,885 bytes +162‎ →‎Encodings

5 May 2022

• curprev 14:2914:29, 5 May 2022‎ Helpful talk contribs‎ m 141,723 bytes −6‎ No edit summary

25 April 2022

• curprev 22:2122:21, 25 April 2022‎ Helpful talk contribs‎ m 141,729 bytes +10‎ →‎See also

13 April 2022

• curprev 21:3121:31, 13 April 2022‎ Helpful talk contribs‎ m 141,719 bytes −19‎ →‎Upserts
• curprev 20:2720:27, 13 April 2022‎ Helpful talk contribs‎ m 141,738 bytes +15‎ →‎Upserts

11 April 2022

• curprev 20:5520:55, 11 April 2022‎ Helpful talk contribs‎ m 141,723 bytes +10‎ →‎See also

11 January 2022

• curprev 19:0019:00, 11 January 2022‎ Helpful talk contribs‎ m 141,713 bytes +24‎ →‎On TOAST
• curprev 18:5918:59, 11 January 2022‎ Helpful talk contribs‎ m 141,689 bytes +62‎ →‎On TOAST
• curprev 17:3117:31, 11 January 2022‎ Helpful talk contribs‎ m 141,627 bytes +10‎ →‎Search syntax
• curprev 17:3117:31, 11 January 2022‎ Helpful talk contribs‎ m 141,617 bytes +40‎ →‎Search syntax
• curprev 17:3017:30, 11 January 2022‎ Helpful talk contribs‎ m 141,577 bytes +985‎ →‎Full text search notes

9 January 2022

• curprev 15:5715:57, 9 January 2022‎ Helpful talk contribs‎ m 140,592 bytes +422‎ →‎Upserts

3 January 2022

• curprev 14:2514:25, 3 January 2022‎ Helpful talk contribs‎ m 140,170 bytes +85‎ →‎On timezones

1 January 2022

• curprev 19:0019:00, 1 January 2022‎ Helpful talk contribs‎ m 140,085 bytes +13‎ →‎temporary tables
• curprev 18:5618:56, 1 January 2022‎ Helpful talk contribs‎ m 140,072 bytes +6‎ →‎SAVEPOINT
• curprev 18:5518:55, 1 January 2022‎ Helpful talk contribs‎ m 140,066 bytes +544‎ →‎Some miscellany
• curprev 18:4818:48, 1 January 2022‎ Helpful talk contribs‎ m 139,522 bytes +226‎ →‎See also
• curprev 18:4518:45, 1 January 2022‎ Helpful talk contribs‎ m 139,296 bytes −204‎ →‎Practical details - indices, columns
• curprev 18:4318:43, 1 January 2022‎ Helpful talk contribs‎ m 139,500 bytes −147‎ →‎Practical details - indices, columns
• curprev 18:3718:37, 1 January 2022‎ Helpful talk contribs‎ m 139,647 bytes +187‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:3418:34, 1 January 2022‎ Helpful talk contribs‎ m 139,460 bytes +704‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:2718:27, 1 January 2022‎ Helpful talk contribs‎ m 138,756 bytes −816‎ →‎configurations / regconfigs, a.k.a. parsing behaviour
• curprev 18:2718:27, 1 January 2022‎ Helpful talk contribs‎ m 139,572 bytes 0‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:2618:26, 1 January 2022‎ Helpful talk contribs‎ m 139,572 bytes −2‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:2618:26, 1 January 2022‎ Helpful talk contribs‎ m 139,574 bytes +15‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:2618:26, 1 January 2022‎ Helpful talk contribs‎ m 139,559 bytes −1‎ →‎regconfigs, dictionary, thesaurus
• curprev 18:2618:26, 1 January 2022‎ Helpful talk contribs‎ m 139,560 bytes −1‎ →‎Proximity matching, weighed terms, and ranking
• curprev 18:2118:21, 1 January 2022‎ Helpful talk contribs‎ m 139,561 bytes +56‎ →‎Proximity matching, weighed terms, and ranking
• curprev 18:2018:20, 1 January 2022‎ Helpful talk contribs‎ m 139,505 bytes +652‎ →‎Proximity matching, weighed terms, and ranking
• curprev 17:2017:20, 1 January 2022‎ Helpful talk contribs‎ m 138,853 bytes +9‎ →‎Search syntax
• curprev 17:2017:20, 1 January 2022‎ Helpful talk contribs‎ m 138,844 bytes 0‎ →‎Search syntax
• curprev 17:2017:20, 1 January 2022‎ Helpful talk contribs‎ m 138,844 bytes +5‎ →‎Search syntax
• curprev 17:1917:19, 1 January 2022‎ Helpful talk contribs‎ m 138,839 bytes +43‎ →‎Search syntax
• curprev 17:1717:17, 1 January 2022‎ Helpful talk contribs‎ m 138,796 bytes +28‎ →‎regconfigs, dictionary, thesaurus
• curprev 17:1717:17, 1 January 2022‎ Helpful talk contribs‎ m 138,768 bytes +661‎ →‎regconfigs
• curprev 16:5116:51, 1 January 2022‎ Helpful talk contribs‎ m 138,107 bytes −899‎ →‎Dictionary and thesaurus
• curprev 16:5116:51, 1 January 2022‎ Helpful talk contribs‎ m 139,006 bytes +5‎ →‎Practical details - indices, columns, regconfigs
• curprev 16:4816:48, 1 January 2022‎ Helpful talk contribs‎ m 139,001 bytes +51‎ →‎Search syntax
• curprev 16:1816:18, 1 January 2022‎ Helpful talk contribs‎ m 138,950 bytes +32‎ →‎Full text search notes

31 December 2021

• curprev 02:0602:06, 31 December 2021‎ Helpful talk contribs‎ m 138,918 bytes +299‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

23 December 2021

• curprev 04:0104:01, 23 December 2021‎ Helpful talk contribs‎ m 138,619 bytes +19‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)

21 December 2021

• curprev 17:5617:56, 21 December 2021‎ Helpful talk contribs‎ m 138,600 bytes +135‎ →‎Check that you can log in
• curprev 17:5217:52, 21 December 2021‎ Helpful talk contribs‎ m 138,465 bytes +10‎ →‎Some distros: clusters
• curprev 17:5117:51, 21 December 2021‎ Helpful talk contribs‎ m 138,455 bytes +3‎ →‎Some distros: clusters
• curprev 17:5017:50, 21 December 2021‎ Helpful talk contribs‎ m 138,452 bytes −21‎ →‎"I installed the package, now what?"

16 November 2021

• curprev 14:1514:15, 16 November 2021‎ Helpful talk contribs‎ m 138,473 bytes +146‎ →‎JSON notes