Mailing lists [pgsql-performance]

4 March 2015

• 22:03   EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Gunnlaugur Thor Briem
• 22:31   slow server : s_lock and _bt_checkkeys on perf top Soni M
• 23:11   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Marc Mamin

5 March 2015

• 12:17   Re: Reverse Key Index Sven R. Kunze
• 18:02   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Gunnlaugur Thor Briem
• 19:25   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Vladimir Sitnikov

6 March 2015

• 00:14   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Marc Mamin
• 03:20   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tomas Vondra
• 03:45   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tom Lane
• 04:29   Re: slow server : s_lock and _bt_checkkeys on perf top Jim Nasby
• 04:41   Re: PG 9.3 materialized view VS Views, indexes, shared memory Jim Nasby
• 11:17   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris
• 12:32   Re: PG 9.3 materialized view VS Views, indexes, shared memory Jim Nasby
• 13:25   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris
• 17:31   Re: slow server : s_lock and _bt_checkkeys on perf top Merlin Moncure
• 19:04   Re: slow server : s_lock and _bt_checkkeys on perf top Soni M
• 20:19   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tomas Vondra
• 21:18   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Jeff Janes
• 21:36   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tom Lane
• 23:26   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris

7 March 2015

• 04:24   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Kevin Grittner
• 04:38   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tom Lane
• 05:26   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Jeff Janes
• 13:30   CREATE INDEX uses INDEX ? Nicolas Paris
• 14:56   Re: CREATE INDEX uses INDEX ? Guillaume Lelarge
• 18:44   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tomas Vondra

8 March 2015

• 12:04   Re: CREATE INDEX uses INDEX ? Nicolas Paris
• 12:09   Re: CREATE INDEX uses INDEX ? Guillaume Lelarge

9 March 2015

• 16:17   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris

10 March 2015

• 11:31   Re: PG 9.3 materialized view VS Views, indexes, shared memory Jim Nasby
• 11:53   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris

11 March 2015

• 18:55   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Gunnlaugur Thor Briem
• 19:15   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tom Lane
• 20:01   How to get explain plan to prefer Hash Join atxcanadian
• 20:30   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Jeff Janes
• 20:55   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Tomas Vondra

12 March 2015

• 00:13   Re: How to get explain plan to prefer Hash Join Nicholson, Brad (Toronto, ON, CA)
• 01:33   Re: How to get explain plan to prefer Hash Join Jeff Janes
• 03:36   Re: How to get explain plan to prefer Hash Join atxcanadian
• 08:43   Re: How to get explain plan to prefer Hash Join Pavel Stehule
• 18:45   Re: How to get explain plan to prefer Hash Join atxcanadian
• 18:53   Re: How to get explain plan to prefer Hash Join Jeff Janes
• 18:59   Re: How to get explain plan to prefer Hash Join atxcanadian
• 19:25   Re: How to get explain plan to prefer Hash Join Jeff Janes
• 20:58   Re: How to get explain plan to prefer Hash Join atxcanadian

13 March 2015

• 14:44   Performance issues Vivekanand Joshi
• 15:58   Re: Performance issues Varadharajan Mukundan
• 16:03   Re: Performance issues Vivekanand Joshi
• 16:10   Re: Performance issues Varadharajan Mukundan
• 22:18   Anyone have experience using PG on a NetApp All-Flash FAS8000? Mel Llaguno
• 22:59   Re: Performance issues Vivekanand Joshi
• 23:37   Re: Performance issues Tomas Vondra
• 23:46   Re: Performance issues Vivekanand Joshi

14 March 2015

• 00:20   Re: Performance issues Tomas Vondra
• 00:27   Postgres inconsistent use of Index vs. Seq Scan Jim Carroll
• 01:03   Re: Performance issues Varadharajan Mukundan
• 01:04   Re: Postgres inconsistent use of Index vs. Seq Scan Tom Lane
• 01:25   Re: Performance issues Scott Marlowe
• 02:28   Re: Performance issues Vivekanand Joshi
• 03:13   Re: Performance issues Tomas Vondra
• 10:02   Re: Anyone have experience using PG on a NetApp All-Flash FAS8000? Varadharajan Mukundan

15 March 2015

• 00:06   Re: Performance issues Gavin Flower
• 00:23   Re: Performance issues Varadharajan Mukundan
• 00:32   Re: Performance issues Gavin Flower
• 13:54   MusicBrainz postgres performance issues Robert Kaye
• 14:14   Re: MusicBrainz postgres performance issues Josh Krupka
• 14:41   Re: MusicBrainz postgres performance issues Andreas Kretschmer
• 15:07   Re: MusicBrainz postgres performance issues Robert Kaye
• 15:08   Re: MusicBrainz postgres performance issues Robert Kaye
• 15:30   Re: MusicBrainz postgres performance issues Rural Hunter
• 15:32   Re: MusicBrainz postgres performance issues Andres Freund
• 15:46   Re: MusicBrainz postgres performance issues Josh Krupka
• 16:27   Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky
• 16:29   Re: MusicBrainz postgres performance issues Tomas Vondra
• 16:30   Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky
• 16:50   Re: MusicBrainz postgres performance issues Andres Freund
• 19:43   Re: MusicBrainz postgres performance issues Scott Marlowe
• 19:47   Re: MusicBrainz postgres performance issues Joshua D. Drake
• 19:49   Re: MusicBrainz postgres performance issues Joshua D. Drake
• 20:09   Re: MusicBrainz postgres performance issues Scott Marlowe
• 20:11   Re: MusicBrainz postgres performance issues Scott Marlowe
• 20:20   Re: MusicBrainz postgres performance issues Andres Freund
• 20:43   Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky
• 20:46   Re: MusicBrainz postgres performance issues Andres Freund
• 20:55   Re: MusicBrainz postgres performance issues Ilya Kosmodemiansky
• 21:25   Re: MusicBrainz postgres performance issues Scott Marlowe

16 March 2015

• 01:48   Re: MusicBrainz postgres performance issues Andres Freund
• 02:15   Re: MusicBrainz postgres performance issues michael@sqlexec.com
• 02:29   Re: MusicBrainz postgres performance issues Tomas Vondra
• 02:31   Re: MusicBrainz postgres performance issues Andres Freund
• 02:42   Re: MusicBrainz postgres performance issues Tomas Vondra
• 02:55   Re: MusicBrainz postgres performance issues michael@sqlexec.com
• 03:07   Re: MusicBrainz postgres performance issues Tomas Vondra
• 03:12   Re: MusicBrainz postgres performance issues Andres Freund
• 03:17   Re: MusicBrainz postgres performance issues michael@sqlexec.com
• 03:23   Re: MusicBrainz postgres performance issues Gavin Flower
• 05:24   Re: MusicBrainz postgres performance issues Roxanne Reid-Bennett
• 08:08   Best VPS provider for running performant PostgreSQL database server Some Developer
• 15:24   Re: Performance issues Vivekanand Joshi
• 16:00   Re: MusicBrainz postgres performance issues Robert Kaye
• 16:23   Re: MusicBrainz postgres performance issues Thomas Kellerer
• 16:38   Re: MusicBrainz postgres performance issues Andreas Kretschmer
• 17:33   Re: MusicBrainz postgres performance issues Robert Kaye
• 20:16   Re: Bad cost estimate with FALSE filter condition Josh Berkus
• 20:47   Re: MusicBrainz postgres performance issues Josh Berkus
• 20:50   Re: Performance issues Marc Mamin
• 21:24   Re: Performance issues Tomas Vondra
• 21:27   Re: Bad cost estimate with FALSE filter condition Tom Lane
• 21:32   Re: Performance issues Vivekanand Joshi
• 22:12   Re: Bad cost estimate with FALSE filter condition Josh Berkus
• 22:23   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Jim Nasby
• 22:24   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Jim Nasby
• 22:25   Re: MusicBrainz postgres performance issues Joao Junior
• 22:33   Re: Best VPS provider for running performant PostgreSQL database server Jim Nasby
• 22:43   Re: Performance issues Jim Nasby
• 23:01   Re: MusicBrainz postgres performance issues Jim Nasby
• 23:29   Re: MusicBrainz postgres performance issues Scott Marlowe
• 23:59   Re: Performance issues Tomas Vondra

17 March 2015

• 00:08   Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT Gunnlaugur Thor Briem
• 03:06   Re: Performance issues Jim Nasby
• 10:41   Re: Performance issues Vivekanand Joshi
• 14:07   Re: Performance issues Vivekanand Joshi
• 14:42   Re: Performance issues Tomas Vondra
• 14:45   Re: Performance issues Tomas Vondra
• 15:06   Re: Performance issues Vivekanand Joshi
• 15:10   Re: Performance issues Vivekanand Joshi
• 16:55   Re: Performance issues Tomas Vondra
• 17:19   Re: Performance issues Thomas Kellerer
• 17:43   Re: Performance issues Tomas Vondra
• 18:10   Re: Performance issues Vivekanand Joshi
• 18:16   Re: Performance issues Vivekanand Joshi
• 18:24   Re: Performance issues Thomas Kellerer
• 18:28   Re: Performance issues Tomas Vondra
• 18:30   Re: Performance issues Tomas Vondra

18 March 2015

• 14:21   Very slow checkpoints Steven Jones
• 14:25   Re: Very slow checkpoints Steven Jones
• 14:43   Re: Very slow checkpoints Ilya Kosmodemiansky
• 14:58   Re: Very slow checkpoints Steven Jones
• 15:14   Re: Very slow checkpoints Ilya Kosmodemiansky
• 15:18   Re: Very slow checkpoints Ilya Kosmodemiansky
• 15:19   Re: Very slow checkpoints Steven Jones
• 15:21   Re: Very slow checkpoints Steven Jones
• 15:29   Re: Very slow checkpoints Ilya Kosmodemiansky
• 18:27   Re: Very slow checkpoints didier
• 20:00   views much slower in 9.3 than 8.4 Carson, Leonard
• 20:16   Re: views much slower in 9.3 than 8.4 Kevin Grittner
• 20:31   Re: Performance issues Vivekanand Joshi
• 20:51   Re: Performance issues Felipe Santos
• 21:36   Re: Performance issues Jerry Sievers
• 21:48   Re: Performance issues Vivekanand Joshi
• 22:07   Re: Performance issues Vitalii Tymchyshyn
• 22:07   Hardware Configuration and other Stuff Vivekanand Joshi
• 22:23   Re: Performance issues Tomas Vondra
• 22:37   Re: [ADMIN] Hardware Configuration and other Stuff Joshua D. Drake
• 22:39   Re: Hardware Configuration and other Stuff Tomas Vondra
• 22:41   Re: Hardware Configuration and other Stuff Pavel Stehule

19 March 2015

• 01:18   Fwd: views much slower in 9.3 than 8.4 Carson, Leonard
• 01:41   Re: Fwd: views much slower in 9.3 than 8.4 Tom Lane
• 08:28   Re: Very slow checkpoints Steven Jones
• 09:23   Merge Join chooses very slow index scan Jake Magner
• 09:42   Re: Merge Join chooses very slow index scan Pavel Stehule
• 10:04   Re: Merge Join chooses very slow index scan Jake Magner
• 17:29   Re: Merge Join chooses very slow index scan Tom Lane
• 17:58   Re: Merge Join chooses very slow index scan Tom Lane
• 19:40   Re: Merge Join chooses very slow index scan Jake Magner
• 20:24   Re: views much slower in 9.3 than 8.4 Carson, Leonard
• 20:31   Re: [GENERAL] Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Sergey Shchukin
• 22:15   Re: Merge Join chooses very slow index scan Jake Magner
• 22:40   Re: Very slow checkpoints Joao Junior

20 March 2015

• 02:04   Re: views much slower in 9.3 than 8.4 Tom Lane
• 18:00   Re: [GENERAL] [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Vladimir Borodin
• 22:01   Query RE: Optimising UUID Lookups Roland Dunn

21 March 2015

• 10:40   Re: Performance issues Josh Krupka
• 12:11   Re: Query RE: Optimising UUID Lookups Maxim Boguk
• 13:34   Re: Query RE: Optimising UUID Lookups Roland Dunn

23 March 2015

• 00:50   Re: Performance issues Vivekanand Joshi
• 01:01   Re: Performance issues Tomas Vondra

24 March 2015

• 08:28   Re: Query RE: Optimising UUID Lookups Maxim Boguk
• 10:49   Re: Query RE: Optimising UUID Lookups David Rowley
• 13:45   Re: Query RE: Optimising UUID Lookups Roland Dunn
• 14:43   Re: Query RE: Optimising UUID Lookups Maxim Boguk

25 March 2015

• 15:04   Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen
• 15:45   Re: Index only scan sometimes switches to sequential scan for small amount of rows Tomas Vondra
• 17:22   Re: Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen
• 19:07   Re: Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen
• 20:26   Re: Index only scan sometimes switches to sequential scan for small amount of rows Tom Lane
• 21:07   Re: Index only scan sometimes switches to sequential scan for small amount of rows Jeff Janes
• 23:00   Re: Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen

26 March 2015

• 00:45   Re: Index only scan sometimes switches to sequential scan for small amount of rows Jeff Janes
• 10:48   Re: Index only scan sometimes switches to sequential scan for small amount of rows Jeff Janes
• 11:18   Re: Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen
• 11:26   Re: Index only scan sometimes switches to sequential scan for small amount of rows Feike Steenbergen
• 13:47   query faster with a foreign table Dominique Vallée
• 15:44   Re: Index only scan sometimes switches to sequential scan for small amount of rows Tomas Vondra
• 19:36   Re: Index only scan sometimes switches to sequential scan for small amount of rows Jeff Janes

27 March 2015

• 01:19   Re: Index only scan sometimes switches to sequential scan for small amount of rows Tomas Vondra

28 March 2015

• 20:14   Re: views much slower in 9.3 than 8.4 Tom Lane

30 March 2015

• 17:47   Re: views much slower in 9.3 than 8.4 Kevin Grittner
• 18:52   Re: views much slower in 9.3 than 8.4 Tom Lane

31 March 2015

• 11:53   Weird CASE WHEN behaviour causing query to be suddenly very slow Kevin Viraud
• 12:09   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Pavel Stehule
• 12:19   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Kevin Viraud
• 12:42   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Pavel Stehule
• 16:58   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Tom Lane
• 18:59   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow Kevin Viraud
• 20:03   Re: Weird CASE WHEN behaviour causing query to be suddenly very slow David G. Johnston
• 22:52   Some performance testing? Josh Berkus
• 23:42   Re: Some performance testing? Mel Llaguno