pgsql-performance since 2014-11-28 16:21

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

Nov. 28, 2014

Thread Author Time
Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio 16:21

Dec. 2, 2014

Thread Author Time
CTE query plan ignores selective index Patrick Krecker 20:59
Re: CTE query plan ignores selective index Tom Lane 22:07

Dec. 4, 2014

Thread Author Time
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Josh Berkus 19:10
Query doesn't use index on hstore column Michael Barker 20:42
Re: Query doesn't use index on hstore column ktm@rice.edu 21:46

Dec. 5, 2014

Thread Author Time
Re: Query doesn't use index on hstore column Tom Lane 01:32
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 06:46
Re: Yet another abort-early plan disaster on 9.3 Merlin Moncure 15:45
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 16:04

Dec. 6, 2014

Thread Author Time
Re: Query doesn't use index on hstore column Michael Barker 00:05
Re: intel s3500 -- hot stuff Bruce Momjian 13:08

Dec. 7, 2014

Thread Author Time
PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3) 📎 Tomas Vondra 01:54
querying with index on jsonb slower than standard column. Why? Tim Dudgeon 22:59

Dec. 8, 2014

Thread Author Time
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:19
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 00:43
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:53
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 01:05
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 01:15
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 01:28
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:31
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 15:46
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:50
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 16:44
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 16:56
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 20:53
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:14
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:22
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:34
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tim Dudgeon 21:39
Re: intel s3500 -- hot stuff Merlin Moncure 21:40

Dec. 9, 2014

Thread Author Time
Hardware Requirements Vivekanand Joshi 18:42
Re: Hardware Requirements Claudio Freire 18:55
Re: intel s3500 -- hot stuff Bruce Momjian 20:43
8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 23:28

Dec. 10, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 01:46
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 02:09
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Mark Kirkwood 03:55
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 08:30
Tuning the configuration Maila Fatticcioni 10:44
When does PostgreSQL collapse subqueries to join? Sven R. Kunze 11:31
Re: When does PostgreSQL collapse subqueries to join? Tom Lane 15:34
Re: intel s3500 -- hot stuff Jeff Janes 16:52
Re: Tuning the configuration Patrick Krecker 17:47
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Mark Kirkwood 22:05

Dec. 11, 2014

Thread Author Time
Re: Tuning the configuration Maila Fatticcioni 08:11
Re: Tuning the configuration Andrea Suisani 12:02
Re: Tuning the configuration Evgeniy Shishkin 12:11
Re: Tuning the configuration Maila Fatticcioni 12:48
Re: Tuning the configuration Andrea Suisani 13:16
Re: Tuning the configuration Andrea Suisani 13:26
Re: Tuning the configuration Eric Pierce 22:36

Dec. 12, 2014

Thread Author Time
Re: Tuning the configuration Mark Kirkwood 00:04
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 03:22
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 03:31
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Merlin Moncure 21:06
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Josh Berkus 21:24
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:44
Re: [PERFORM] Re: querying with index on jsonb slower than standard column. Why? Claudio Freire 22:10
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 23:27

Dec. 13, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 01:20
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 03:05
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Claudio Freire 05:38

Dec. 15, 2014

Thread Author Time
Re: Tuning the configuration Graeme B. Bell 13:36
Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio 14:18
Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio 14:32

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

Browse Archives

Prev | Next