Postgresql notes: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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?"

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

curprev 16:5716:57, 11 November 2021‎ Helpful talk contribs‎ m 138,280 bytes +11‎ →‎pg_hba

curprev 12:4512:45, 8 July 2021‎ Helpful talk contribs‎ m 138,281 bytes +209‎ →‎Some distros: clusters

curprev 11:4511:45, 1 July 2021‎ Helpful talk contribs‎ m 138,072 bytes +1‎ →‎Understanding EXPLAIN / queries to rewrite for indices
curprev 11:4411:44, 1 July 2021‎ Helpful talk contribs‎ m 138,071 bytes +667‎ →‎Understanding EXPLAIN / queries to rewrite for indices
curprev 11:2111:21, 1 July 2021‎ Helpful talk contribs‎ m 137,404 bytes +17‎ →‎Understanding EXPLAIN / queries to rewrite for indices

curprev 16:3316:33, 5 April 2021‎ Helpful talk contribs‎ m 137,387 bytes +6‎ →‎psql
curprev 16:3216:32, 5 April 2021‎ Helpful talk contribs‎ m 137,381 bytes +10‎ →‎psql

curprev 17:1517:15, 21 March 2021‎ Helpful talk contribs‎ m 137,371 bytes +704‎ No edit summary

curprev 19:4519:45, 21 January 2021‎ Helpful talk contribs‎ m 136,173 bytes +436‎ →‎Notes on performance and innards

curprev 16:0016:00, 24 December 2020‎ Helpful talk contribs‎ m 135,737 bytes +37‎ →‎On timezones
curprev 15:5815:58, 24 December 2020‎ Helpful talk contribs‎ m 135,700 bytes +366‎ →‎Date math
curprev 14:5114:51, 24 December 2020‎ Helpful talk contribs‎ m 135,334 bytes +57‎ →‎On timezones

curprev 13:2013:20, 26 November 2020‎ Helpful talk contribs‎ m 135,277 bytes +28‎ →‎"idle" and "idle in transaction"

curprev 14:5814:58, 10 November 2020‎ Helpful talk contribs‎ m 134,614 bytes +130‎ →‎Some distros: clusters
curprev 14:5014:50, 10 November 2020‎ Helpful talk contribs‎ m 134,484 bytes −17‎ →‎Some distros: clusters
curprev 14:4914:49, 10 November 2020‎ Helpful talk contribs‎ m 134,501 bytes −6‎ →‎Debian/ubuntu only: clusters

curprev 13:5313:53, 8 November 2020‎ Helpful talk contribs‎ m 134,507 bytes +441‎ →‎Errors
curprev 13:4313:43, 8 November 2020‎ Helpful talk contribs‎ m 134,066 bytes +800‎ →‎ERROR: current transaction is aborted, commands ignored until end of transaction block

curprev 16:5216:52, 19 October 2020‎ Helpful talk contribs‎ m 133,266 bytes +438‎ →‎SAVEPOINT
curprev 16:4316:43, 19 October 2020‎ Helpful talk contribs‎ m 132,828 bytes +160‎ No edit summary

curprev 21:1721:17, 2 October 2020‎ Helpful talk contribs‎ m 132,668 bytes +46‎ →‎"idle" and "idle in transaction"

curprev 02:4802:48, 13 August 2020‎ Helpful talk contribs‎ m 132,622 bytes −3‎ →‎Others
curprev 02:3302:33, 13 August 2020‎ Helpful talk contribs‎ m 132,625 bytes +6‎ →‎work_mem
curprev 02:3002:30, 13 August 2020‎ Helpful talk contribs‎ m 132,619 bytes +74‎ →‎Memory use

curprev 13:3913:39, 14 May 2020‎ Helpful talk contribs‎ m 132,545 bytes +45‎ →‎On TOAST

curprev 19:2419:24, 12 May 2020‎ Helpful talk contribs‎ m 132,500 bytes −82‎ →‎On large binary / text data

curprev 20:2820:28, 10 April 2020‎ Helpful talk contribs‎ m 132,582 bytes +38‎ →‎Error: Cannot stat /var/run/postgresql / No PostgreSQL clusters exist; see "man pg_createcluster"

curprev 17:3417:34, 10 March 2020‎ Helpful talk contribs‎ m 132,544 bytes +82‎ →‎Debian/ubuntu only: clusters
curprev 17:3317:33, 10 March 2020‎ Helpful talk contribs‎ m 132,462 bytes +2‎ →‎(If your packager didn't:) create postgres database

curprev 16:0716:07, 6 October 2019‎ Helpful talk contribs‎ m 131,569 bytes +578‎ →‎serial, bigserial notes

curprev 20:1620:16, 25 September 2019‎ Helpful talk contribs‎ m 130,991 bytes −8‎ →‎Disk details: WAL, fsync, logging
curprev 20:1520:15, 25 September 2019‎ Helpful talk contribs‎ m 130,999 bytes −81‎ →‎Disk details: WAL, fsync, logging
curprev 12:1112:11, 25 September 2019‎ Helpful talk contribs‎ m 131,080 bytes −701‎ →‎Disk details: WAL, fsync, logging

curprev 13:2313:23, 19 September 2019‎ Helpful talk contribs‎ m 131,781 bytes +110‎ →‎checkpoints are occurring too frequently

curprev 18:2618:26, 22 July 2019‎ Helpful talk contribs‎ m 130,531 bytes +2,791‎ →‎Date math
curprev 16:4416:44, 22 July 2019‎ Helpful talk contribs‎ m 127,740 bytes −11‎ →‎psql

curprev 19:2319:23, 11 July 2019‎ Helpful talk contribs‎ m 127,751 bytes +6‎ →‎On TOAST

curprev 16:3216:32, 28 June 2019‎ Helpful talk contribs‎ m 127,745 bytes +1,907‎ →‎temporary tables
curprev 16:1216:12, 28 June 2019‎ Helpful talk contribs‎ m 125,838 bytes +29‎ →‎Disk details: WAL, fsync, logging
curprev 15:3315:33, 28 June 2019‎ Helpful talk contribs‎ m 125,809 bytes −156‎ →‎psycopg and transactions

curprev 13:5013:50, 5 June 2019‎ Helpful talk contribs‎ m 125,965 bytes +142‎ →‎pg_hba

curprev 17:1317:13, 14 May 2019‎ Helpful talk contribs‎ m 125,823 bytes +82‎ →‎Debian/ubuntu only: clusters
curprev 17:1317:13, 14 May 2019‎ Helpful talk contribs‎ m 125,741 bytes +54‎ →‎Debian/ubuntu only: clusters

curprev 19:5419:54, 25 April 2019‎ Helpful talk contribs‎ m 125,687 bytes +495‎ →‎Errors

curprev 15:2115:21, 28 March 2019‎ Helpful talk contribs‎ m 125,192 bytes +969‎ →‎Encodings

curprev 23:2623:26, 17 February 2019‎ Helpful talk contribs‎ m 123,848 bytes −87‎ →‎column sizes
curprev 23:1623:16, 17 February 2019‎ Helpful talk contribs‎ m 123,935 bytes +322‎ →‎Fast count from a table
curprev 22:5522:55, 17 February 2019‎ Helpful talk contribs‎ m 123,613 bytes +16‎ →‎Fast count from a table
curprev 22:5422:54, 17 February 2019‎ Helpful talk contribs‎ m 123,597 bytes +60‎ →‎Fast count from a table

curprev 13:3813:38, 24 January 2019‎ Helpful talk contribs‎ m 123,537 bytes +66‎ →‎Debian/ubuntu only: clusters

curprev 16:1316:13, 22 January 2019‎ Helpful talk contribs‎ m 123,471 bytes −1,546‎ →‎counting is slow

curprev 16:0516:05, 17 January 2019‎ Helpful talk contribs‎ m 125,017 bytes +221‎ →‎Other notes
curprev 00:5500:55, 17 January 2019‎ Helpful talk contribs‎ m 124,796 bytes −32‎ →‎Encodings

curprev 18:4418:44, 14 January 2019‎ Helpful talk contribs‎ m 124,828 bytes +4‎ →‎On large binary / text data

curprev 17:2917:29, 13 January 2019‎ Helpful talk contribs‎ m 124,824 bytes +1,431‎ →‎Understanding EXPLAIN / queries to rewrite for indices

curprev 15:4315:43, 11 January 2019‎ Helpful talk contribs‎ m 123,393 bytes +28‎ →‎Encodings
curprev 13:0613:06, 11 January 2019‎ Helpful talk contribs‎ m 123,365 bytes +3‎ →‎psycopg and transactions

curprev 17:1717:17, 10 January 2019‎ Helpful talk contribs‎ m 123,362 bytes +209‎ →‎VACUUM, VACUUM FULL (MVCC and the FSM)
curprev 16:5716:57, 10 January 2019‎ Helpful talk contribs‎ m 123,153 bytes +1,110‎ →‎Notes on performance and innards

curprev 17:2717:27, 28 December 2018‎ Helpful talk contribs‎ m 121,597 bytes +198‎ →‎"idle" and "idle in transaction"

curprev 15:5915:59, 12 October 2018‎ Helpful talk contribs‎ m 121,110 bytes +272‎ No edit summary

curprev 19:0919:09, 20 August 2018‎ Helpful talk contribs‎ m 120,838 bytes −162‎ No edit summary
curprev 15:3315:33, 20 August 2018‎ Helpful talk contribs‎ m 121,000 bytes +551‎ No edit summary
curprev 14:4714:47, 20 August 2018‎ Helpful talk contribs‎ m 120,449 bytes +72‎ No edit summary

curprev 18:4618:46, 15 August 2018‎ Helpful talk contribs‎ m 118,900 bytes +187‎ No edit summary
curprev 18:4218:42, 15 August 2018‎ Helpful talk contribs‎ m 118,713 bytes +1,708‎ No edit summary

curprev 11:5611:56, 8 August 2018‎ Helpful talk contribs‎ m 117,411 bytes −8‎ →‎Optional: creating roles, setting access privileges, and client auth settings
curprev 11:5411:54, 8 August 2018‎ Helpful talk contribs‎ m 117,419 bytes +146‎ →‎Optional: Set password
curprev 11:5111:51, 8 August 2018‎ Helpful talk contribs‎ m 117,273 bytes +20‎ →‎Check that you can log in

Postgresql notes: Revision history

19 March 2024

22 January 2024

29 November 2023

9 July 2023

25 March 2023

24 March 2023

30 January 2023

23 November 2022

21 November 2022

14 September 2022

11 September 2022

8 September 2022

27 August 2022

22 August 2022

26 June 2022

21 June 2022

20 May 2022

19 May 2022

18 May 2022

16 May 2022

8 May 2022

5 May 2022

25 April 2022

13 April 2022

11 April 2022

11 January 2022

9 January 2022

3 January 2022

1 January 2022

31 December 2021

23 December 2021

21 December 2021

16 November 2021

11 November 2021

10 November 2021

8 July 2021

1 July 2021

5 April 2021

21 March 2021

24 January 2021

21 January 2021

24 December 2020

26 November 2020

25 November 2020

10 November 2020

8 November 2020

19 October 2020

2 October 2020

13 August 2020

14 May 2020

12 May 2020

10 April 2020

10 March 2020

21 November 2019

22 October 2019

7 October 2019

6 October 2019

25 September 2019

19 September 2019

18 September 2019

4 August 2019

22 July 2019

11 July 2019

28 June 2019

5 June 2019

14 May 2019

25 April 2019

28 March 2019

18 March 2019

17 February 2019

24 January 2019

22 January 2019

17 January 2019

14 January 2019

13 January 2019

11 January 2019

10 January 2019

1 January 2019

28 December 2018