Mailing lists [pgsql-performance]

2 November 2014

• 01:33   Replication Lag Causes Mike Wilson
• 02:14   Re: Replication Lag Causes Valentine Gogichashvili
• 23:58   Re: Replication Lag Causes Mike Wilson

3 November 2014

• 00:16   Re: Replication Lag Causes Mike Wilson
• 17:34   Re: Replication Lag Causes Felipe Santos
• 23:00   assignment vs SELECT INTO Andrew Dunstan
• 23:24   Re: assignment vs SELECT INTO Tom Lane
• 23:27   Re: assignment vs SELECT INTO Matheus de Oliveira
• 23:31   Re: assignment vs SELECT INTO Andrew Dunstan

4 November 2014

• 15:34   Re: Replication Lag Causes Stuart Bishop
• 19:02   Re: unnecessary sort in the execution plan when doing group by Simon Riggs
• 19:28   Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh
• 20:01   9.3 performance issues, lots of bind and parse log entries Tory M Blue
• 22:09   Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh
• 23:07   Re: 9.3 performance issues, lots of bind and parse log entries Tory M Blue
• 23:31   Re: 9.3 performance issues, lots of bind and parse log entries Tomas Vondra

5 November 2014

• 20:41   intel s3500 -- hot stuff Merlin Moncure
• 21:09   Re: intel s3500 -- hot stuff Merlin Moncure
• 22:16   Re: 9.3 performance issues, lots of bind and parse log entries Tory M Blue

6 November 2014

• 00:32   log_temp_files (integer), tuning work_mem Tory M Blue
• 00:42   Index order ignored after `is null` in query Artūras Lapinskas
• 04:55   Re: 9.3 performance issues, lots of bind and parse log entries Tomas Vondra
• 08:30   Index order ignored after `is null` in query Artūras Lapinskas
• 09:32   Re: log_temp_files (integer), tuning work_mem Guillaume Lelarge
• 20:06   Re: Index order ignored after `is null` in query Artūras Lapinskas
• 20:23   Re: Index order ignored after `is null` in query Tom Lane

7 November 2014

• 01:01   Re: pgtune + configurations with 9.3 Josh Berkus
• 07:16   Postgres does not use indexes with OR-conditions arhipov
• 07:38   Re: Postgres does not use indexes with OR-conditions David Rowley
• 08:06   Re: Postgres does not use indexes with OR-conditions Vlad Arkhipov
• 14:15   Re: Index order ignored after `is null` in query Artūras Lapinskas
• 16:55   Re: Postgres does not use indexes with OR-conditions Andrew Dunstan
• 17:13   Re: pgtune + configurations with 9.3 Shaun Thomas
• 17:17   Re: Postgres does not use indexes with OR-conditions Kevin Grittner
• 18:12   Re: Postgres does not use indexes with OR-conditions Tom Lane
• 19:50   Re: Postgres does not use indexes with OR-conditions David G Johnston

8 November 2014

• 16:11   Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio
• 23:36   Re: Postgres slave not catching up (on 9.2) Robert Klemme

10 November 2014

• 01:44   Re: Postgres slave not catching up (on 9.2) Andres Freund
• 13:14   Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio
• 21:13   updating statistics on slow running query Eric Ramirez
• 21:48   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 21:56   Re: 9.3 performance issues, lots of bind and parse log entries Josh Berkus
• 21:57   Re: updating statistics on slow running query desmodemone
• 21:59   Re: Performance bug in prepared statement binding in 9.2? Jeff Janes
• 22:04   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 22:08   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 22:13   Re: Performance bug in prepared statement binding in 9.2? Tom Lane
• 22:34   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 22:50   Lock pileup causes server to stall Josh Berkus
• 23:13   Re: Performance bug in prepared statement binding in 9.2? Jeff Janes

11 November 2014

• 00:41   Re: Lock pileup causes server to stall Alvaro Herrera
• 01:52   Re: updating statistics on slow running query Eric Ramirez
• 02:51   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 09:38   trigger Before or After avpro avpro
• 11:19   Re: [GENERAL] trigger Before or After Albe Laurenz
• 16:59   Re: [GENERAL] trigger Before or After Adrian Klaver
• 20:11   Re: Lock pileup causes server to stall Josh Berkus
• 20:33   Re: Lock pileup causes server to stall Jeff Janes

12 November 2014

• 09:49   Re: Lock pileup causes server to stall Jesper Krogh
• 16:51   Re: Lock pileup causes server to stall Alvaro Herrera
• 20:04   Re: Lock pileup causes server to stall Josh Berkus

13 November 2014

• 09:54   Re: Lock pileup causes server to stall Jesper Krogh
• 11:10   9.0 performance degradation with kernel 3.11 Filip Rembiałkowski

14 November 2014

• 02:09   Increased shared_buffer setting = lower hit ratio ? CS DBA
• 02:16   Re: Increased shared_buffer setting = lower hit ratio ? CS DBA
• 02:35   Re: Increased shared_buffer setting = lower hit ratio ? Tomas Vondra
• 03:02   Re: Increased shared_buffer setting = lower hit ratio ? Jeff Janes
• 17:24   Re[2]: [PERFORM] pgtune + configurations with 9.3 Alexey Vasiliev
• 19:08   Re: 9.0 performance degradation with kernel 3.11 Glyn Astill
• 19:28   Re: pgtune + configurations with 9.3 Shaun Thomas
• 19:40   [PERFORM] pgtune + configurations with 9.3 Alexey Vasiliev
• 20:07   Re: pgtune + configurations with 9.3 Shaun Thomas
• 22:11   Re[2]: [PERFORM] pgtune + configurations with 9.3 Alexey Vasiliev

15 November 2014

• 02:00   Re: pgtune + configurations with 9.3 Mark Kirkwood
• 04:53   Re: updating statistics on slow running query Jim Nasby
• 05:09   Re: pgtune + configurations with 9.3 Jim Nasby
• 05:12   Re: Index order ignored after `is null` in query Jim Nasby
• 06:29   Re: pgtune + configurations with 9.3 Mark Kirkwood

16 November 2014

• 02:16   Plan uses wrong index, preferring to scan pkey index instead Yuri Kunde Schlesner
• 02:24   Re: Plan uses wrong index, preferring to scan pkey index instead Yuri Kunde Schlesner
• 20:18   Re: Plan uses wrong index, preferring to scan pkey index instead Tom Lane

17 November 2014

• 01:25   Re: Partitions and work_mem? Dave Johansen
• 07:52   Re: Re[2]: [PERFORM] pgtune + configurations with 9.3 Stuart Bishop
• 08:17   Re: pgtune + configurations with 9.3 Stuart Bishop
• 09:57   Re: Partitions and work_mem? Magnus Hagander
• 18:14   Re: Partitions and work_mem? Tom Lane

18 November 2014

• 06:34   Re: Partitions and work_mem? Dave Johansen

19 November 2014

• 03:02   Re: Plan uses wrong index, preferring to scan pkey index instead Yuri Kunde Schlesner

21 November 2014

• 08:07   A pessimistic planner Stuart Bishop
• 08:12   Re: A pessimistic planner Tom Lane
• 21:38   Re: Yet another abort-early plan disaster on 9.3 Jeff Janes

23 November 2014

• 23:20   Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra

24 November 2014

• 10:02   Re: pgtune + configurations with 9.3 Johann Spies
• 14:02   Why don't use index on x when ORDER BY x, y? Vlad Arkhipov
• 16:39   Re: Why don't use index on x when ORDER BY x, y? Robert Klemme
• 18:39   Re: Why don't use index on x when ORDER BY x, y? Tom Lane

25 November 2014

• 23:36   Small performance regression in 9.2 has a big impact Scott Marlowe
• 23:59   Re: Small performance regression in 9.2 has a big impact Heikki Linnakangas

26 November 2014

• 00:55   Re: Small performance regression in 9.2 has a big impact Tom Lane
• 01:25   Re: Small performance regression in 9.2 has a big impact Scott Marlowe
• 01:57   Re: Small performance regression in 9.2 has a big impact Tom Lane
• 02:02   Re: Small performance regression in 9.2 has a big impact Tom Lane
• 06:59   Re: Small performance regression in 9.2 has a big impact Tom Lane
• 13:17   issue in postgresql 9.1.3 in using arrow key in Solaris platform M Tarkeshwar Rao
• 16:34   Re: pgtune + configurations with 9.3 Johann Spies
• 16:39   Re: pgtune + configurations with 9.3 Johann Spies
• 17:37   Re: [GENERAL] issue in postgresql 9.1.3 in using arrow key in Solaris platform Adrian Klaver
• 20:21   Re: Small performance regression in 9.2 has a big impact Scott Marlowe

28 November 2014

• 19:21   Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio