Postgresql notes: Revision history

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