Mailing lists [pgsql-performance]

3 February 2014

• 02:52   Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server Tom Kincaid
• 22:29   Planner estimates and VACUUM/autovacuum Artur Zając

4 February 2014

• 00:03   Re: Planner estimates and VACUUM/autovacuum Tom Lane

5 February 2014

• 03:37   Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 Dattaram Porob
• 03:37   Planner estimates and VACUUM/autovacuum Artur Zając CFI
• 03:37   Postgres Query Plan Live Lock Pweaver (Paul Weaver)
• 04:32   Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 Claudio Freire
• 05:03   Re: Postgres Query Plan Live Lock Peter Geoghegan
• 14:50   increasing query time after analyze Katharina Koobs
• 15:16   Re: increasing query time after analyze Pavel Stehule
• 17:52   Postgres Query Plan Live Lock Jeff Janes
• 18:28   Re: increasing query time after analyze Claudio Freire
• 19:39   Re: Postgres Query Plan Live Lock bricklen

6 February 2014

• 05:20   Re: Postgres Query Plan Live Lock Pweaver (Paul Weaver)
• 05:20   Re: Postgres Query Plan Live Lock Pweaver (Paul Weaver)
• 05:42   Re: Postgres Query Plan Live Lock Claudio Freire

7 February 2014

• 21:47   Bloated tables and why is vacuum full the only option Claudio Freire

8 February 2014

• 06:36   Performance Benchmarking for data-warehousing instance? Huy Nguyen
• 07:12   Re: Performance Benchmarking for data-warehousing instance? Peter Geoghegan
• 09:41   Re: Performance Benchmarking for data-warehousing instance? Huy Nguyen
• 11:25   Re: Performance Benchmarking for data-warehousing instance? Wattana Hinchaisri

9 February 2014

• 18:42   Re: Performance Benchmarking for data-warehousing instance? Tomas Vondra
• 18:50   Re: Bloated tables and why is vacuum full the only option Tomas Vondra
• 22:14   Re: Bloated tables and why is vacuum full the only option Claudio Freire
• 22:40   Re: Bloated tables and why is vacuum full the only option Tom Lane
• 22:48   Re: Bloated tables and why is vacuum full the only option Claudio Freire

10 February 2014

• 01:32   Re: Bloated tables and why is vacuum full the only option Sergey Konoplev
• 01:59   Re: Bloated tables and why is vacuum full the only option Claudio Freire
• 02:30   Re: Bloated tables and why is vacuum full the only option Sergey Konoplev
• 22:53   Strange performance boost with random() M Putz
• 23:03   Re: Strange performance boost with random() Heikki Linnakangas

11 February 2014

• 18:22   Re: Strange performance boost with random() Sébastien Lorion
• 18:38   Re: Strange performance boost with random() Tom Lane
• 23:54   list number of entries to be delete in cascading deletes Eildert Groeneveld
• 23:58   Re: list number of entries to be delete in cascading deletes Claudio Freire

12 February 2014

• 02:29   Re: Bloated tables and why is vacuum full the only option Jeff Janes
• 02:36   Re: Bloated tables and why is vacuum full the only option Claudio Freire
• 02:50   Re: Postgres Query Plan Live Lock Jeff Janes
• 11:58   increasing query time after analyze Katharina Koobs
• 12:21   Re: increasing query time after analyze Pavel Stehule
• 13:43   Re: list number of entries to be delete in cascading deletes Eildert Groeneveld
• 19:59   Problem with ExclusiveLock on inserts Бородин Владимир
• 20:31   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky
• 20:43   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 20:57   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky
• 22:20   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 22:38   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky
• 22:57   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 23:15   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky

13 February 2014

• 11:35   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 12:14   Re: Problem with ExclusiveLock on inserts Emre Hasegeli
• 12:23   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 12:29   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky
• 13:01   Re: Problem with ExclusiveLock on inserts Emre Hasegeli
• 13:26   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 15:20   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky

15 February 2014

• 00:06   Can one Dump schema without index/constraints? Tory M Blue
• 04:55   Re: Can one Dump schema without index/constraints? Michael Paquier
• 08:40   Re: Can one Dump schema without index/constraints? Tory M Blue

17 February 2014

• 18:03   Optimal settings for RAID controller - optimized for writes Niels Kristian Schjødt
• 18:29   Re: Optimal settings for RAID controller - optimized for writes DFE
• 18:40   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra
• 18:54   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra

18 February 2014

• 00:54   Why is the optimiser choosing the slower query, or, understanding explain analyze output Alistair Bayley
• 01:15   DB size and TABLE sizes don't seem to add up David Wall
• 01:48   Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Jeff Janes
• 04:17   Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa
• 04:40   Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Tom Lane
• 05:18   Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Alistair Bayley
• 05:30   Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Tom Lane
• 07:04   Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe
• 11:34   Re: DB size and TABLE sizes don't seem to add up Heikki Linnakangas
• 17:25   Re: Optimal settings for RAID controller - optimized for writes Michael Stone
• 20:49   Re: DB size and TABLE sizes don't seem to add up David Wall
• 23:41   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra

19 February 2014

• 05:39   Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa
• 18:13   Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure
• 21:09   Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe

20 February 2014

• 03:13   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra
• 03:18   Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure
• 03:26   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra
• 04:10   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra
• 04:48   Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe
• 06:24   Re: Problem with ExclusiveLock on inserts Ilya Kosmodemiansky
• 06:24   Optimal settings for RAID controller - optimized for writes Niels Kristian Schjødt
• 11:23   Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa

21 February 2014

• 01:58   Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra
• 15:22   Postgresql tunning-- help needed Ashutosh Durugkar
• 21:01   Lack of index usage when doing array casts Alexey Klyukin
• 22:05   Re: Lack of index usage when doing array casts Tom Lane

22 February 2014

• 01:12   Re: Lack of index usage when doing array casts Tom Lane
• 01:38   Re: Lack of index usage when doing array casts Alexey Klyukin
• 01:45   Re: Lack of index usage when doing array casts Peter Geoghegan

23 February 2014

• 23:42   9.1.2 Postgres corruption, any way to recover? Tory M Blue

24 February 2014

• 00:58   Re: 9.1.2 Postgres corruption, any way to recover? Tomas Vondra

25 February 2014

• 00:43   Re: Bloated tables and why is vacuum full the only option Claudio Freire
• 19:07   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Tom Lane

26 February 2014

• 03:21   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Josh Berkus
• 09:32   Re: Problem with ExclusiveLock on inserts Бородин Владимир
• 18:17   9.2.4 specified item offset is too large, now what? Tory M Blue
• 18:41   Query taking long time acanada

27 February 2014

• 03:08   Re: Postgresql tunning-- help needed Tomas Vondra
• 13:31   Re: Query taking long time acanada
• 17:08   not using my GIN index in JOIN expression Jean-Max Reymond
• 17:20   Re: not using my GIN index in JOIN expression Heikki Linnakangas
• 17:46   Re: not using my GIN index in JOIN expression Jean-Max Reymond
• 19:57   Inefficient filter order in query plan Tom Coogan
• 20:04   Re: Inefficient filter order in query plan Tom Lane
• 21:23   Re: Inefficient filter order in query plan Stephen Frost
• 22:02   Re: Inefficient filter order in query plan Tom Lane
• 23:34   Re: Inefficient filter order in query plan Tom Coogan
• 23:47   Re: Inefficient filter order in query plan Tom Lane

28 February 2014

• 21:29   Re: Inefficient filter order in query plan Tom Coogan