Mailing lists [pgsql-performance]

5 August 2015

• 04:41   Slow HashAggregate/cache access Alexandre de Arruda Paes
• 06:40   Re: Performance issue with NestedLoop query Ram N
• 20:12   Re: Performance issue with NestedLoop query Qingqing Zhou
• 20:25   Re: Slow HashAggregate/cache access Kevin Grittner
• 21:26   Re: Slow HashAggregate/cache access Maxim Boguk
• 22:29   Re: Slow HashAggregate/cache access Alexandre de Arruda Paes
• 22:56   Re: Slow HashAggregate/cache access Andreas Joseph Krogh
• 23:53   Re: Slow HashAggregate/cache access Alexandre de Arruda Paes

6 August 2015

• 00:00   Re: Slow HashAggregate/cache access Andreas Joseph Krogh
• 00:06   Re: Slow HashAggregate/cache access David Rowley
• 01:07   Re: Slow HashAggregate/cache access David Rowley
• 02:59   Re: Slow HashAggregate/cache access Alexandre de Arruda Paes
• 04:10   Re: Slow HashAggregate/cache access Alexandre de Arruda Paes
• 13:05   Re: Slow HashAggregate/cache access Andreas Joseph Krogh

10 August 2015

• 06:16   Re: Slow HashAggregate/cache access David Rowley

11 August 2015

• 11:46   Query Plan Performance on Partitioned Table Rural Hunter
• 14:44   Re: Query Plan Performance on Partitioned Table Maxim Boguk
• 16:44   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 16:53   Re: Query Plan Performance on Partitioned Table Maxim Boguk
• 17:01   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 17:01   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 17:43   Re: Query Plan Performance on Partitioned Table Maxim Boguk
• 17:51   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 20:03   Re: Query Plan Performance on Partitioned Table Pietro Pugni

12 August 2015

• 04:49   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 05:34   Slow Query robbyc
• 07:08   Re: Slow Query Venkata Balaji N
• 08:29   Re: Slow Query robbyc
• 09:08   Re: Slow Query Venkata Balaji N
• 10:00   Re: Query Plan Performance on Partitioned Table Pietro Pugni
• 11:25   Re: Query Plan Performance on Partitioned Table Rural Hunter
• 14:34   Re: Slow Query Vik Fearing

13 August 2015

• 03:50   Re: Slow Query robbyc
• 12:21   Re: Slow Query 林士博
• 20:11   Strange query stalls on replica in 9.3.9 Josh Berkus
• 23:24   Re: Strange query stalls on replica in 9.3.9 Kevin Grittner
• 23:59   Re: Strange query stalls on replica in 9.3.9 Jeff Janes

14 August 2015

• 06:15   Re: Slow Query robbyc
• 08:10   Re: Slow Query 林士博
• 09:10   Re: Slow Query 林士博
• 19:34   Re: Strange query stalls on replica in 9.3.9 Josh Berkus
• 19:54   Re: Strange query stalls on replica in 9.3.9 Jeff Janes

18 August 2015

• 20:44   Re: Strange query stalls on replica in 9.3.9 Jeff Janes

20 August 2015

• 11:27   Re: incredible surprise news from intel/micron right now... Graeme B. Bell

21 August 2015

• 03:03   Most efficient way of querying M 'related' tables where N out of M may contain the key Stephane Bailliez
• 03:19   Re: Most efficient way of querying M 'related' tables where N out of M may contain the key David G. Johnston
• 15:07   Re: Most efficient way of querying M 'related' tables where N out of M may contain the key Stephane Bailliez
• 15:24   Re: Most efficient way of querying M 'related' tables where N out of M may contain the key David G. Johnston
• 15:49   Performance bottleneck due to array manipulation Genc, Ömer
• 17:06   Re: Performance bottleneck due to array manipulation Tom Lane
• 17:11   Re: Performance bottleneck due to array manipulation Félix GERZAGUET
• 17:50   Re: Performance bottleneck due to array manipulation Igor Neyman

22 August 2015

• 04:56   query not using GIN index Guo, Yun
• 07:36   Re: query not using GIN index Tomas Vondra

24 August 2015

• 10:04   problem with select * bhuvan Mitra
• 10:13   Re: problem with select * Wei Shan
• 11:59   Re: problem with select * Andreas Joseph Krogh
• 13:22   Re: Performance bottleneck due to array manipulation Genc, Ömer
• 14:44   Re: problem with select * Andrew Dunstan
• 17:45   Re: query not using GIN index Guo, Yun
• 18:08   Re: query not using GIN index Guo, Yun
• 20:04   Re: query not using GIN index Jeff Janes

25 August 2015

• 10:22   Long running query: How to monitor the progress Johann Spies
• 16:11   Gist indexing performance with cidr types Henrik Thostrup Jensen
• 16:50   Re: Long running query: How to monitor the progress Tom Lane
• 17:26   Re: Gist indexing performance with cidr types Emre Hasegeli

26 August 2015

• 10:58   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen
• 12:00   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen
• 12:47   Re: Gist indexing performance with cidr types Emre Hasegeli
• 14:28   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen
• 16:46   Re: Gist indexing performance with cidr types Emre Hasegeli
• 19:08   Re: Gist indexing performance with cidr types Jeff Janes
• 22:14   Index creation running now for 14 hours Tory M Blue
• 22:18   Re: Index creation running now for 14 hours Igor Neyman
• 22:25   Re: Index creation running now for 14 hours Tory M Blue
• 22:36   Re: Index creation running now for 14 hours Igor Neyman
• 23:26   Re: Index creation running now for 14 hours Tory M Blue

27 August 2015

• 00:45   Re: Index creation running now for 14 hours Qingqing Zhou
• 00:53   Re: Index creation running now for 14 hours Tory M Blue
• 01:36   Re: Index creation running now for 14 hours Tomas Vondra
• 01:42   Re: Index creation running now for 14 hours Tomas Vondra
• 01:58   Re: Index creation running now for 14 hours Peter Geoghegan
• 12:21   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen
• 12:35   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen
• 19:05   Re: Gist indexing performance with cidr types Emre Hasegeli

28 August 2015

• 17:05   Re: Gist indexing performance with cidr types Henrik Thostrup Jensen

31 August 2015

• 16:52   is there any way we can push join predicate into inner table 挨踢人
• 17:36   Re: is there any way we can push join predicate into inner table Tom Lane
• 19:09   Query > 1000× slowdown after adding datetime comparison twoflower
• 19:19   Re: Query > 1000× slowdown after adding datetime comparison Tomas Vondra
• 19:35   Re: [PERFORM] Query > 1000× slowdown after adding datetime comparison David G. Johnston
• 22:03   Re: Query > 1000× slowdown after adding datetime comparison twoflower
• 22:19   Re: Query > 1000× slowdown after adding datetime comparison twoflower
• 22:23   Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison David G. Johnston
• 22:29   Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison David G. Johnston
• 22:47   Re: Re: Query > 1000× slowdown after adding datetime comparison twoflower
• 23:24   Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison Stefan Keller
• 23:30   Re: Re: Query > 1000× slowdown after adding datetime comparison twoflower