Mailing lists [pgsql-performance]

2 February 2015

• 00:06   Re: Unexpected (bad) performance when querying indexed JSONB column Josh Berkus
• 00:08   Re: working around JSONB's lack of stats? Josh Berkus
• 00:31   Re: Unexpected (bad) performance when querying indexed JSONB column Christian Weyer
• 01:21   Re: Unexpected (bad) performance when querying indexed JSONB column Tom Lane
• 01:32   Why is GIN index slowing down my query? AlexK987
• 02:34   Re: Why is GIN index slowing down my query? Tom Lane
• 04:37   Re: Why is GIN index slowing down my query? AlexK987
• 06:00   Re: Why is GIN index slowing down my query? AlexK987
• 06:15   Re: Why is GIN index slowing down my query? Tom Lane
• 09:44   Re: Unexpected (bad) performance when querying indexed JSONB column Christian Weyer
• 12:17   Re: Why is GIN index slowing down my query? Marc Mamin
• 13:31   Re: Why is GIN index slowing down my query? Marc Mamin
• 18:43   Re: working around JSONB's lack of stats? Merlin Moncure

3 February 2015

• 04:36   Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)? Jim Nasby
• 04:48   Re: working around JSONB's lack of stats? Jim Nasby
• 04:52   Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)? Jim Nasby
• 06:37   Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)? Slava Mudry
• 07:17   Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)? Jim Nasby
• 22:07   Re: working around JSONB's lack of stats? Josh Berkus

6 February 2015

• 11:30   Copy command Faster than original select belal
• 11:39   Re: Copy command Faster than original select Pavel Stehule
• 11:44   Re: Copy command Faster than original select Belal Al-Hamed
• 11:55   Re: Copy command Faster than original select Pavel Stehule
• 12:15   Re: Copy command Faster than original select Belal Al-Hamed
• 12:32   Re: Copy command Faster than original select Pavel Stehule
• 12:50   Re: Copy command Faster than original select Belal Al-Hamed
• 12:56   Re: Copy command Faster than original select Pavel Stehule
• 13:37   Re: Copy command Faster than original select Matheus de Oliveira
• 15:27   Re: Copy command Faster than original select Belal Al-Hamed
• 16:13   Re: Copy command Faster than original select Matheus de Oliveira
• 16:39   Re: Copy command Faster than original select Belal Al-Hamed
• 16:50   Re: Copy command Faster than original select Pavel Stehule
• 18:12   Re: Copy command Faster than original select Matheus de Oliveira
• 18:25   Re: Copy command Faster than original select Igor Neyman
• 18:48   Re: Copy command Faster than original select Tom Lane

8 February 2015

• 13:08   Re: Copy command Faster than original select Belal Al-Hamed

9 February 2015

• 14:23   Vs NULL sridhar bamandlapally
• 14:54   Re: Vs NULL Pavel Stehule
• 15:36   Re: Vs NULL Nikolas Everett
• 15:42   Re: [ADMIN] Vs NULL Marc Mamin
• 15:49   Re: [ADMIN] Vs NULL Geoff Winkless
• 15:57   Re: [ADMIN] Vs NULL Geoff Winkless
• 17:21   Migrating a FoxPro system and would like input on the best way to achieve optimal performance TonyS
• 18:58   Avoiding Refreezing XIDs Repeatedly bkrug
• 19:48   Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira
• 20:06   Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera
• 21:17   Re: Migrating a FoxPro system and would like input on the best way to achieve optimal performance David G Johnston
• 21:46   Re: Avoiding Refreezing XIDs Repeatedly bkrug
• 21:52   Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera
• 21:56   Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira
• 22:07   Re: Avoiding Refreezing XIDs Repeatedly bkrug
• 22:10   Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera
• 22:30   Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior
• 23:00   Re: Avoiding Refreezing XIDs Repeatedly Tom Lane

10 February 2015

• 00:13   Poor performance when deleting from entity-attribute-value type master-table Andreas Joseph Krogh
• 00:29   Re: Survey: Max TPS you've ever seen Gavin Flower
• 00:37   Re: Poor performance when deleting from entity-attribute-value type master-table Igor Neyman
• 00:42   Re: Poor performance when deleting from entity-attribute-value type master-table Jerry Sievers
• 00:50   Re: Poor performance when deleting from entity-attribute-value type master-table Andreas Joseph Krogh
• 01:04   Re: Poor performance when deleting from entity-attribute-value type master-table Josh Berkus
• 06:53   Re: [ADMIN] Vs NULL sridhar bamandlapally
• 13:07   Re: [ADMIN] Vs NULL Florent Guillaume
• 13:48   Re: Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior
• 15:12   Re: Survey: Max TPS you've ever seen Graeme B. Bell

11 February 2015

• 03:31   Re: Survey: Max TPS you've ever seen Mark Kirkwood
• 05:54   slow nested views in 9.3 Pascal Depuis
• 09:41   slow query Sathish Nelson
• 16:33   Re: slow query Torsten Förtsch
• 16:45   Re: slow query Tom Lane

12 February 2015

• 14:12   Re: Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior
• 14:20   Re: Survey: Max TPS you've ever seen Gudmundsson Martin (mg)
• 17:30   Re: Survey: Max TPS you've ever seen Graeme B. Bell
• 21:07   query - laziness of lateral join with function paulcc

13 February 2015

• 00:17   Re: query - laziness of lateral join with function Tom Lane
• 01:16   Re: query - laziness of lateral join with function David G Johnston
• 01:19   Configuration tips for very large database Nico Sabbi
• 01:38   Re: Configuration tips for very large database Kevin Grittner
• 01:41   Re: Configuration tips for very large database Nico Sabbi
• 01:55   Re: Configuration tips for very large database Kevin Grittner
• 02:11   Re: Survey: Max TPS you've ever seen Mark Kirkwood
• 02:14   Re: Configuration tips for very large database Mathis, Jason
• 02:19   Re: Configuration tips for very large database Claudio Freire
• 02:28   Re: query - laziness of lateral join with function Paul Callaghan
• 10:16   Re: Yet another abort-early plan disaster on 9.3 Michael Paquier
• 17:01   Re: Configuration tips for very large database ktm@rice.edu
• 17:43   Re: Configuration tips for very large database Graeme B. Bell

14 February 2015

• 21:12   Reverse Key Index Sven R. Kunze
• 21:18   Re: Reverse Key Index Tom Lane
• 21:34   Re: Reverse Key Index Sven R. Kunze
• 22:35   Re: Configuration tips for very large database Nico Sabbi

20 February 2015

• 13:28   PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris
• 15:37   Re: PG 9.3 materialized view VS Views, indexes, shared memory Matheus de Oliveira
• 16:06   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris
• 17:45   Re: PG 9.3 materialized view VS Views, indexes, shared memory Matheus de Oliveira
• 19:19   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris
• 21:09   Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris

23 February 2015

• 14:38   Regarding "Point-in-time Recovery" feature Saurabh Gupta A
• 19:03   Re: Regarding "Point-in-time Recovery" feature Mathis, Jason
• 19:11   Re: Regarding "Point-in-time Recovery" feature luis.sa@htip.com.br

26 February 2015

• 01:31   Re: Reverse Key Index Josh Berkus
• 14:12   Re: Reverse Key Index Sven R. Kunze
• 14:46   Re: Reverse Key Index Thomas Kellerer
• 15:23   Re: Reverse Key Index Sven R. Kunze
• 15:37   Re: Reverse Key Index Heikki Linnakangas
• 15:48   Re: Reverse Key Index Thomas Kellerer
• 16:20   Re: Reverse Key Index Sven R. Kunze

28 February 2015

• 04:28   Bad cost estimate with FALSE filter condition Josh Berkus
• 12:08   pushing order by + limit to union subqueries Paolo Losi
• 19:24   Re: pushing order by + limit to union subqueries Tom Lane