pgsql-performance since 2014-12-16 00:00

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

Dec. 16, 2014

Thread Author Time
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Graeme B. Bell 11:47
Re: Tuning the configuration Graeme B. Bell 11:51
Re: Tuning the configuration Evgeniy Shishkin 16:37
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 19:46

Dec. 17, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 07:55
Excessive memory used for INSERT 📎 Alessandro Ipe 15:14
Re: Excessive memory used for INSERT Torsten Zuehlsdorff 15:26
Re: Excessive memory used for INSERT Tom Lane 15:41
Re: Excessive memory used for INSERT Alessandro Ipe 16:57
Re: Excessive memory used for INSERT Alessandro Ipe 17:04
Re: Excessive memory used for INSERT Tom Lane 17:49

Dec. 18, 2014

Thread Author Time
Re: Excessive memory used for INSERT Torsten Förtsch 07:51
Re: Excessive memory used for INSERT Alessandro Ipe 11:16
Re: Excessive memory used for INSERT Alessandro Ipe 15:42
Re: Excessive memory used for INSERT Alessandro Ipe 16:31
Re: Excessive memory used for INSERT Tom Lane 17:05
Question about trigram GIST index Robert DiFalco 17:12
Re: Question about trigram GIST index Tom Lane 17:18
Re: Excessive memory used for INSERT Alessandro Ipe 17:31
Re: Question about trigram GIST index Robert DiFalco 17:32
Re: Question about trigram GIST index Giuseppe Broccolo 18:00
Re: Question about trigram GIST index Robert DiFalco 18:08
Re: Question about trigram GIST index Jeff Janes 18:33
Re: Question about trigram GIST index Robert DiFalco 19:33
Re: Question about trigram GIST index Kevin Grittner 20:03

Dec. 22, 2014

Thread Author Time
Number of Columns and Update Robert DiFalco 20:53
Re: Number of Columns and Update Heikki Linnakangas 21:40
Re: Number of Columns and Update Andrew Dunstan 21:41

Dec. 23, 2014

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3) Heikki Linnakangas 10:28
Re: Excessive memory used for INSERT 📎 Alessandro Ipe 11:56
Re: Excessive memory used for INSERT Tom Lane 20:27

Dec. 30, 2014

Thread Author Time
trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar 20:42

Jan. 1, 2015

Thread Author Time
Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist Michael Paquier 07:17
Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar 20:45

Jan. 6, 2015

Thread Author Time
Re: Excessive memory used for INSERT Alessandro Ipe 17:40

Jan. 9, 2015

Thread Author Time
New server optimization advice Steve Crawford 19:26
Re: New server optimization advice Claudio Freire 19:48

Jan. 12, 2015

Thread Author Time
Re: New server optimization advice Merlin Moncure 16:02

Jan. 14, 2015

Thread Author Time
Performance of Postgresql Foreign Data Wrapper Cassiano, Marco 16:48

Jan. 15, 2015

Thread Author Time
shared_buffers vs Linux file cache Huan Ruan 11:30
Re: shared_buffers vs Linux file cache Glyn Astill 17:10
Re: shared_buffers vs Linux file cache Jeff Janes 22:22
Strange choice of general index over partial index Josh Berkus 22:30
Re: shared_buffers vs Linux file cache Tom Lane 23:24
Re: Strange choice of general index over partial index Jeff Janes 23:39

Jan. 16, 2015

Thread Author Time
Re: Strange choice of general index over partial index Mark Kirkwood 00:37
Autocompletion with full text search Ivan Schneider 00:41
Re: Strange choice of general index over partial index Tom Lane 01:48
Re: Strange choice of general index over partial index 📎 Mark Kirkwood 02:32
Re: Strange choice of general index over partial index Tom Lane 03:03
Re: Strange choice of general index over partial index Mark Kirkwood 03:06
Re: Strange choice of general index over partial index Mark Kirkwood 03:17
Re: Strange choice of general index over partial index Josh Berkus 03:28
Re: shared_buffers vs Linux file cache Huan Ruan 03:32
Re: Strange choice of general index over partial index Mark Kirkwood 04:00
Re: Strange choice of general index over partial index Josh Berkus 04:15
Re: shared_buffers vs Linux file cache Roman Konoval 07:49

Jan. 22, 2015

Thread Author Time
Initial insert Laurent Cathala 16:46

Jan. 23, 2015

Thread Author Time
Re: Initial insert Laurent Cathala 08:54

Jan. 24, 2015

Thread Author Time
How to tell ANALYZE to collect statistics from the whole table? AlexK987 23:33

Jan. 25, 2015

Thread Author Time
Re: How to tell ANALYZE to collect statistics from the whole table? Tomas Vondra 00:49
Re: How to tell ANALYZE to collect statistics from the whole table? AlexK987 01:04
Re: How to tell ANALYZE to collect statistics from the whole table? Tomas Vondra 01:21
Re: Initial insert Tomas Vondra 01:29
Re: How to tell ANALYZE to collect statistics from the whole table? Tom Lane 05:14
Query performance Joe Van Dyk 05:41
Re: Query performance Joe Van Dyk 05:43
Re: Query performance Joe Van Dyk 05:45
Re: Query performance Pavel Stehule 06:12
Re: Query performance Joe Van Dyk 06:38
Re: Query performance Pavel Stehule 07:14
Re: Query performance Joe Van Dyk 07:20
Re: Query performance Pavel Stehule 08:03
Re: Query performance Tomas Vondra 16:57
Re: Query performance Marc Mamin 21:07

Jan. 26, 2015

Thread Author Time
Why is PostgreSQL not using my index? Christian Roche 16:32
Re: How to tell ANALYZE to collect statistics from the whole table? Jeff Janes 16:51
Re: Why is PostgreSQL not using my index? Tom Lane 20:31

Jan. 27, 2015

Thread Author Time
Re: Why is PostgreSQL not using my index? Tomas Vondra 04:25
working around JSONB's lack of stats? Josh Berkus 07:06
Re: Why is PostgreSQL not using my index? Merlin Moncure 14:11

Jan. 28, 2015

Thread Author Time
Re: working around JSONB's lack of stats? Tomas Vondra 19:48
Re: working around JSONB's lack of stats? Josh Berkus 23:03
Re: working around JSONB's lack of stats? Peter Geoghegan 23:34
Re: working around JSONB's lack of stats? Josh Berkus 23:42
Re: working around JSONB's lack of stats? Peter Geoghegan 23:50
Re: working around JSONB's lack of stats? Tomas Vondra 23:55

Jan. 30, 2015

Thread Author Time
Re: working around JSONB's lack of stats? Josh Berkus 20:26
why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)? Slava Mudry 23:44

Jan. 31, 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:28
Re: working around JSONB's lack of stats? Jim Nasby 01:34
Re: Query performance Jim Nasby 01:40
Re: Autocompletion with full text search Jim Nasby 01:57
Re: Performance of Postgresql Foreign Data Wrapper Jim Nasby 02:01
Re: Query performance Pavel Stehule 06:28
Unexpected (bad) performance when querying indexed JSONB column Christian Weyer 16:00
Re: Unexpected (bad) performance when querying indexed JSONB column Christian Weyer 19:02

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

Browse Archives

Prev | Next