pgsql-performance - February 2015

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 5 6 8 9 10 11 12 13 14 19 20 23 24 25 26 27 28

Feb. 1, 2015

Thread Author Time
Re: Unexpected (bad) performance when querying indexed JSONB column Josh Berkus 21:06
Re: working around JSONB's lack of stats? Josh Berkus 21:08
Re: Unexpected (bad) performance when querying indexed JSONB column Christian Weyer 21:19
Re: Unexpected (bad) performance when querying indexed JSONB column Tom Lane 22:20
Why is GIN index slowing down my query? AlexK987 22:32
Re: Why is GIN index slowing down my query? Tom Lane 23:34

Feb. 2, 2015

Thread Author Time
Re: Why is GIN index slowing down my query? AlexK987 01:37
Re: Why is GIN index slowing down my query? AlexK987 03:00
Re: Why is GIN index slowing down my query? Tom Lane 03:15
Re: Unexpected (bad) performance when querying indexed JSONB column Christian Weyer 06:31
Re: Why is GIN index slowing down my query? Marc Mamin 09:17
Re: Why is GIN index slowing down my query? Marc Mamin 10:31
Re: working around JSONB's lack of stats? Merlin Moncure 15:42

Feb. 3, 2015

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

Feb. 5, 2015

Thread Author Time
slow nested views in 9.3 Pascal Depuis 22:29

Feb. 6, 2015

Thread Author Time
Copy command Faster than original select belal 08:30
Re: Copy command Faster than original select Pavel Stehule 08:38
Re: Copy command Faster than original select Belal Al-Hamed 08:44
Re: Copy command Faster than original select Pavel Stehule 08:54
Re: Copy command Faster than original select Belal Al-Hamed 09:15
Re: Copy command Faster than original select Pavel Stehule 09:31
Re: Copy command Faster than original select Belal Al-Hamed 09:50
Re: Copy command Faster than original select Pavel Stehule 09:55
Re: Copy command Faster than original select Matheus de Oliveira 10:36
Re: Copy command Faster than original select Belal Al-Hamed 12:27
Re: Copy command Faster than original select Matheus de Oliveira 13:12
Re: Copy command Faster than original select Belal Al-Hamed 13:39
Re: Copy command Faster than original select Pavel Stehule 13:49
Re: Copy command Faster than original select Matheus de Oliveira 15:11
Re: Copy command Faster than original select Igor Neyman 15:24
Re: Copy command Faster than original select Tom Lane 15:48

Feb. 8, 2015

Thread Author Time
Re: Copy command Faster than original select Belal Al-Hamed 10:08

Feb. 9, 2015

Thread Author Time
<empty string> Vs NULL sridhar bamandlapally 11:22
Re: [PERFORM] <empty string> Vs NULL Pavel Stehule 11:53
Re: <empty string> Vs NULL Nikolas Everett 12:36
Re: [PERFORM] <empty string> Vs NULL Marc Mamin 12:42
Re: [ADMIN] <empty string> Vs NULL Geoff Winkless 12:48
Re: <empty string> Vs NULL Geoff Winkless 12:57
Re: [PERFORM] <empty string> Vs NULL Marc Mamin 13:02
Migrating a FoxPro system and would like input on the best way to achieve optimal performance TonyS 14:21
Avoiding Refreezing XIDs Repeatedly bkrug 15:58
Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira 16:48
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera 17:06
Re: Migrating a FoxPro system and would like input on the best way to achieve optimal performance David G Johnston 18:17
Re: Avoiding Refreezing XIDs Repeatedly bkrug 18:45
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera 18:53
Re: Avoiding Refreezing XIDs Repeatedly Matheus de Oliveira 18:56
Re: Avoiding Refreezing XIDs Repeatedly bkrug 19:07
Re: Avoiding Refreezing XIDs Repeatedly Alvaro Herrera 19:10
Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior 19:30
Re: Avoiding Refreezing XIDs Repeatedly Tom Lane 20:00
Poor performance when deleting from entity-attribute-value type master-table Andreas Joseph Krogh 21:12
Re: Survey: Max TPS you've ever seen Gavin Flower 21:29
Re: Poor performance when deleting from entity-attribute-value type master-table Igor Neyman 21:36
Re: Poor performance when deleting from entity-attribute-value type master-table Jerry Sievers 21:42
Re: Poor performance when deleting from entity-attribute-value type master-table Andreas Joseph Krogh 21:50
Re: Poor performance when deleting from entity-attribute-value type master-table Josh Berkus 22:04

Feb. 10, 2015

Thread Author Time
Re: [PERFORM] <empty string> Vs NULL sridhar bamandlapally 03:53
Re: [PERFORM] <empty string> Vs NULL Scott Ribe 04:50
Re: [PERFORM] <empty string> Vs NULL David G Johnston 05:02
Re: [PERFORM] <empty string> Vs NULL Florent Guillaume 10:07
Re: [PERFORM] <empty string> Vs NULL sridhar bamandlapally 10:40
Re: Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior 10:48
Re: Survey: Max TPS you've ever seen Graeme B. Bell 11:27
getting client_addr not as a superuser Михаил 12:21
Re: getting client_addr not as a superuser Jov 12:53
Re: getting client_addr not as a superuser Luis Antonio Dias de Sá Junior 14:11
Re: [PERFORM] <empty string> Vs NULL Scott Ribe 14:32

Feb. 11, 2015

Thread Author Time
Re: Survey: Max TPS you've ever seen Mark Kirkwood 00:31
slow query Sathish Nelson 06:41
Re: slow query Torsten Förtsch 13:33
Re: slow query Tom Lane 13:44

Feb. 12, 2015

Thread Author Time
Re: Survey: Max TPS you've ever seen Luis Antonio Dias de Sá Junior 11:12
Re: Survey: Max TPS you've ever seen Gudmundsson Martin (mg) 11:20
Re: Survey: Max TPS you've ever seen Graeme B. Bell 12:26
query - laziness of lateral join with function paulcc 18:07
Re: query - laziness of lateral join with function Tom Lane 21:17
Re: query - laziness of lateral join with function David G Johnston 22:16
Configuration tips for very large database Nico Sabbi 22:25
Re: Configuration tips for very large database Kevin Grittner 22:38
Re: Configuration tips for very large database Nico Sabbi 22:48
Re: Configuration tips for very large database Kevin Grittner 22:55
Re: Survey: Max TPS you've ever seen Mark Kirkwood 23:10
Re: Configuration tips for very large database Mathis, Jason 23:14
Re: Configuration tips for very large database Claudio Freire 23:19
Re: query - laziness of lateral join with function Paul Callaghan 23:28

Feb. 13, 2015

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Michael Paquier 07:16
Re[2]: [ADMIN] getting client_addr not as a superuser Михаил 10:58
Re: Configuration tips for very large database [email protected] 14:01
Re: Configuration tips for very large database Graeme B. Bell 14:09

Feb. 14, 2015

Thread Author Time
Reverse Key Index Sven R. Kunze 18:13
Re: Reverse Key Index Tom Lane 18:18
Re: Reverse Key Index Sven R. Kunze 18:35
Re: Configuration tips for very large database Nico Sabbi 19:42

Feb. 19, 2015

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3) Tomas Vondra 03:08

Feb. 20, 2015

Thread Author Time
PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris 10:28
Re: PG 9.3 materialized view VS Views, indexes, shared memory Matheus de Oliveira 12:36
Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris 13:06
Re: PG 9.3 materialized view VS Views, indexes, shared memory Matheus de Oliveira 14:44
Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris 16:19
Re: PG 9.3 materialized view VS Views, indexes, shared memory Nicolas Paris 18:09

Feb. 23, 2015

Thread Author Time
Regarding "Point-in-time Recovery" feature Saurabh Gupta A 11:38
Re: Regarding "Point-in-time Recovery" feature Mathis, Jason 16:03
Re: Regarding "Point-in-time Recovery" feature luis.sa 16:11

Feb. 24, 2015

Thread Author Time
Issue with a hanging apply process on the replica db after vacuum works on primary Sergey Shchukin 13:42

Feb. 25, 2015

Thread Author Time
Re: Reverse Key Index Josh Berkus 22:31

Feb. 26, 2015

Thread Author Time
Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Sergey Shchukin 06:25
Re: Reverse Key Index Sven R. Kunze 11:04
Re: Reverse Key Index Thomas Kellerer 11:45
Re: Reverse Key Index Sven R. Kunze 12:23
Re: Reverse Key Index Heikki Linnakangas 12:37
Re: Reverse Key Index Thomas Kellerer 12:48
Re: Reverse Key Index Sven R. Kunze 13:20

Feb. 27, 2015

Thread Author Time
Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Jim Nasby 08:52
Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Sergey Shchukin 11:11
Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary Sergey Shchukin 11:42

Feb. 28, 2015

Thread Author Time
Bad cost estimate with FALSE filter condition Josh Berkus 01:28
pushing order by + limit to union subqueries Paolo Losi 09:08
Re: pushing order by + limit to union subqueries Tom Lane 16:24

Browse Archives

Prev | Next
Jump to day: 1 2 3 5 6 8 9 10 11 12 13 14 19 20 23 24 25 26 27 28