Mailing lists [pgsql-performance]

1 August 2014

• 01:56   Re: 60 core performance with 9.3 Alvaro Herrera

2 August 2014

• 19:29   Re: High rate of transaction failure with the Serializable Isolation Level Reza Taheri
• 21:13   Re: High rate of transaction failure with the Serializable Isolation Level Ryan Johnson

4 August 2014

• 10:23   Re: Very slow planning performance on partition table Rural Hunter
• 13:12   Re: Very slow planning performance on partition table Rural Hunter

6 August 2014

• 00:38   Query performing very bad and sometimes good Andreas Joseph Krogh
• 03:16   Re: Query performing very bad and sometimes good David G Johnston
• 17:04   Re: Query performing very bad and sometimes good Kevin Grittner

8 August 2014

• 02:22   two table join with order by on both tables attributes Evgeniy Shishkin
• 02:42   Re: two table join with order by on both tables attributes David G Johnston
• 03:03   Re: two table join with order by on both tables attributes Evgeniy Shishkin
• 03:19   Re: two table join with order by on both tables attributes Tom Lane
• 03:43   Re: two table join with order by on both tables attributes Evgeniy Shishkin
• 04:05   Re: two table join with order by on both tables attributes Evgeniy Shishkin
• 16:30   Re: two table join with order by on both tables attributes Marti Raudsepp
• 16:57   Re: two table join with order by on both tables attributes Evgeniy Shishkin
• 22:15   Optimization idea for long IN() lists Josh Berkus

9 August 2014

• 07:22   Re: Optimization idea for long IN() lists Maxim Boguk

12 August 2014

• 05:59   how does the planer to estimate row when i use order by and group by 楊新波
• 07:56   Re: 60 core performance with 9.3 Mark Kirkwood
• 15:47   Re: how does the planer to estimate row when i use order by and group by Marti Raudsepp

14 August 2014

• 21:18   Re: 60 core performance with 9.3 Josh Berkus

15 August 2014

• 01:24   Re: 60 core performance with 9.3 Mark Kirkwood

18 August 2014

• 06:19   select on index column,why PG still use seq scan? Xiaoyulei
• 06:50   Re: select on index column,why PG still use seq scan? Tom Lane

19 August 2014

• 00:02   query against pg_locks leads to large memory alloc Dave Owens
• 00:22   Re: query against pg_locks leads to large memory alloc Matheus de Oliveira
• 00:29   Re: query against pg_locks leads to large memory alloc Merlin Moncure
• 00:37   Re: query against pg_locks leads to large memory alloc Dave Owens
• 01:01   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 02:24   Re: query against pg_locks leads to large memory alloc Tom Lane
• 14:39   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 18:58   Re: query against pg_locks leads to large memory alloc Dave Owens
• 19:40   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 20:15   Re: query against pg_locks leads to large memory alloc Dave Owens
• 20:17   Re: query against pg_locks leads to large memory alloc Andres Freund
• 20:26   Re: query against pg_locks leads to large memory alloc Dave Owens
• 20:51   Re: query against pg_locks leads to large memory alloc Dave Owens
• 20:55   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 21:01   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 21:29   Re: query against pg_locks leads to large memory alloc Dave Owens
• 21:43   Re: query against pg_locks leads to large memory alloc Kevin Grittner

20 August 2014

• 12:30   query on parent partition table has bad performance Huang, Suya
• 16:49   Re: query on parent partition table has bad performance David G Johnston
• 17:12   Re: query on parent partition table has bad performance Tom Lane
• 20:16   Re: query against pg_locks leads to large memory alloc Dave Owens
• 21:15   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 22:13   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 23:36   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Shaun Thomas

21 August 2014

• 00:24   Re: query against pg_locks leads to large memory alloc Kevin Grittner
• 02:14   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Mark Kirkwood
• 02:59   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Peter Geoghegan
• 05:40   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Bruce Momjian
• 05:47   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Tatsuo Ishii
• 07:47   Re: query on parent partition table has bad performance Huang, Suya
• 07:51   Re: High rate of transaction failure with the Serializable Isolation Level Reza Taheri
• 08:10   Re: query on parent partition table has bad performance Tom Lane
• 13:02   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Mark Kirkwood
• 16:30   Window functions, partitioning, and sorting performance Eli Naeher
• 17:02   Re: Window functions, partitioning, and sorting performance Marti Raudsepp
• 17:05   Re: Window functions, partitioning, and sorting performance Shaun Thomas
• 17:15   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Shaun Thomas
• 19:19   Re: Window functions, partitioning, and sorting performance Eli Naeher
• 19:21   Re: Window functions, partitioning, and sorting performance Eli Naeher
• 20:15   Re: Window functions, partitioning, and sorting performance Marti Raudsepp

22 August 2014

• 00:02   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 00:11   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Bruce Momjian
• 00:17   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 00:26   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Bruce Momjian
• 00:26   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Scott Marlowe
• 00:43   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Scott Marlowe
• 01:07   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Graeme B. Bell
• 01:51   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 02:08   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Steve Crawford
• 02:29   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 02:32   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Mark Kirkwood
• 03:04   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Joshua D. Drake
• 09:37   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Scott Marlowe
• 16:01   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Shaun Thomas
• 17:28   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Andres Freund
• 23:50   autocommit (true/false) for more than 1 million records Emi Lu
• 23:58   Re: autocommit (true/false) for more than 1 million records David G Johnston

23 August 2014

• 00:00   Re: autocommit (true/false) for more than 1 million records Stephen Frost
• 00:11   Re: autocommit (true/false) for more than 1 million records Emi Lu
• 00:21   Re: autocommit (true/false) for more than 1 million records Stephen Frost

25 August 2014

• 16:40   Re: autocommit (true/false) for more than 1 million records Emi Lu
• 16:51   Re: autocommit (true/false) for more than 1 million records David Johnston
• 17:03   Re: autocommit (true/false) for more than 1 million records Felipe Santos
• 18:48   Re: autocommit (true/false) for more than 1 million records Jeff Janes
• 21:47   tuning postgresql 9.3.5 and multiple cores Jeison Bedoya Delgado
• 23:27   From: Rich Rich

26 August 2014

• 01:14   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Josh Berkus
• 04:51   Re: tuning postgresql 9.3.5 and multiple cores Jeff Janes
• 05:04   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Mark Kirkwood
• 12:50   Re: tuning postgresql 9.3.5 and multiple cores Soni M
• 13:10   Re: tuning postgresql 9.3.5 and multiple cores Mark Kirkwood

27 August 2014

• 01:10   Re: autocommit (true/false) for more than 1 million records Alex Goncharov
• 01:33   Re: autocommit (true/false) for more than 1 million records Kevin Grittner
• 04:20   Re: autocommit (true/false) for more than 1 million records Alex Goncharov
• 06:40   Re: autocommit (true/false) for more than 1 million records David G Johnston
• 07:24   Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 Mark Kirkwood
• 08:02   Re: autocommit (true/false) for more than 1 million records Alex Goncharov
• 09:10   Re: autocommit (true/false) for more than 1 million records David Johnston
• 11:43   Re: autocommit (true/false) for more than 1 million records Albe Laurenz
• 14:51   Re: autocommit (true/false) for more than 1 million records Felipe Santos
• 15:41   Re: autocommit (true/false) for more than 1 million records Albe Laurenz
• 15:59   Re: autocommit (true/false) for more than 1 million records Kevin Grittner

28 August 2014

• 11:50   Performance issue: index not used on GROUP BY... gmb
• 11:57   Re: Performance issue: index not used on GROUP BY... Victor Yegorov
• 12:09   Re: Performance issue: index not used on GROUP BY... gmb
• 12:28   Re: Performance issue: index not used on GROUP BY... Victor Yegorov
• 12:30   Re: Performance issue: index not used on GROUP BY... Marti Raudsepp
• 14:29   Re: Performance issue: index not used on GROUP BY... gmb
• 15:26   Re: Performance issue: index not used on GROUP BY... Victor Yegorov
• 17:49   Re: autocommit (true/false) for more than 1 million records Emi Lu
• 23:48   Re: Performance issue: index not used on GROUP BY... Josh Berkus

29 August 2014

• 07:31   Very slow running query PostgreSQL 9.3.4 Burgess, Freddie
• 09:39   Re: Very slow running query PostgreSQL 9.3.4 Victor Yegorov