pgsql-performance since 2014-11-01 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

Nov. 1, 2014

Thread	Author	Time
Replication Lag Causes	Mike Wilson	22:33
Re: Replication Lag Causes	Valentine Gogichashvili	23:14

Nov. 2, 2014

Thread	Author	Time
Re: Replication Lag Causes	Mike Wilson	20:58
Re: Replication Lag Causes	Mike Wilson	21:16

Nov. 3, 2014

Thread	Author	Time
Index order ignored after `is null` in query	Artūras Lapinskas	01:40
Re: Replication Lag Causes	Felipe Santos	14:34
assignment vs SELECT INTO	Andrew Dunstan	20:00
Re: assignment vs SELECT INTO	Tom Lane	20:24
Re: assignment vs SELECT INTO	Matheus de Oliveira	20:27
Re: assignment vs SELECT INTO	Andrew Dunstan	20:31

Nov. 4, 2014

Thread	Author	Time
Re: Replication Lag Causes	Stuart Bishop	12:34
Re: unnecessary sort in the execution plan when doing group by	Simon Riggs	16:02
Re: Incredibly slow restore times after 9.0>9.2 upgrade	jmcdonagh	16:28
9.3 performance issues, lots of bind and parse log entries	Tory M Blue	17:01
Re: Incredibly slow restore times after 9.0>9.2 upgrade	jmcdonagh	18:59
Re: 9.3 performance issues, lots of bind and parse log entries	Tory M Blue	20:07
Re: 9.3 performance issues, lots of bind and parse log entries	Tomas Vondra	20:31

Nov. 5, 2014

Thread	Author	Time
intel s3500 -- hot stuff	Merlin Moncure	17:40
Re: intel s3500 -- hot stuff	Merlin Moncure	18:09
Re: 9.3 performance issues, lots of bind and parse log entries	Tory M Blue	19:16
log_temp_files (integer), tuning work_mem	Tory M Blue	21:32
Index order ignored after `is null` in query	Artūras Lapinskas	21:42

Nov. 6, 2014

Thread	Author	Time
Re: 9.3 performance issues, lots of bind and parse log entries	Tomas Vondra	01:54
Re: log_temp_files (integer), tuning work_mem	Guillaume Lelarge	06:31
Re: Index order ignored after `is null` in query	Artūras Lapinskas	17:06
Re: Index order ignored after `is null` in query	Tom Lane	17:23
Re: pgtune + configurations with 9.3	Josh Berkus	22:01

Nov. 7, 2014

Thread	Author	Time
Postgres does not use indexes with OR-conditions	arhipov	04:16
Re: Postgres does not use indexes with OR-conditions	David Rowley	04:38
Re: Postgres does not use indexes with OR-conditions	Vlad Arkhipov	05:06
Re: Index order ignored after `is null` in query	Artūras Lapinskas	11:14
Re: Postgres does not use indexes with OR-conditions	Andrew Dunstan	13:55
Re: pgtune + configurations with 9.3	Shaun Thomas	14:13
Re: Postgres does not use indexes with OR-conditions	Kevin Grittner	14:17
Re: Postgres does not use indexes with OR-conditions	Tom Lane	15:11
Re: Postgres does not use indexes with OR-conditions	David G Johnston	16:50

Nov. 8, 2014

Thread	Author	Time
Postgres slave not catching up (on 9.2)	Ruben Domingo Gaspar Aparicio	13:11
Re: Postgres slave not catching up (on 9.2)	Robert Klemme	20:35

Nov. 9, 2014

Thread	Author	Time
Re: Postgres slave not catching up (on 9.2)	Andres Freund	22:44

Nov. 10, 2014

Thread	Author	Time
Re: Postgres slave not catching up (on 9.2)	Ruben Domingo Gaspar Aparicio	10:14
updating statistics on slow running query	Eric Ramirez	17:43
Re: Performance bug in prepared statement binding in 9.2?	Josh Berkus	18:48
Re: 9.3 performance issues, lots of bind and parse log entries	Josh Berkus	18:56
Re: updating statistics on slow running query	desmodemone	18:57
Re: Performance bug in prepared statement binding in 9.2?	Jeff Janes	18:59
Re: Performance bug in prepared statement binding in 9.2?	Josh Berkus	19:04
Re: Performance bug in prepared statement binding in 9.2?	Andres Freund	19:08
Re: Performance bug in prepared statement binding in 9.2?	Tom Lane	19:11
Re: Performance bug in prepared statement binding in 9.2?	Josh Berkus	19:34
Lock pileup causes server to stall	Josh Berkus	19:50
Re: Performance bug in prepared statement binding in 9.2?	Jeff Janes	20:13
Re: Lock pileup causes server to stall	Alvaro Herrera	21:40
Re: updating statistics on slow running query	Eric Ramirez	22:52
Re: Performance bug in prepared statement binding in 9.2?	Josh Berkus	23:51

Nov. 11, 2014

Thread	Author	Time
trigger Before or After	avpro avpro	06:38
Re: [GENERAL] trigger Before or After	Albe Laurenz	08:19
Re: trigger Before or After	Adrian Klaver	13:58
Re: Lock pileup causes server to stall	Josh Berkus	17:11
Re: Lock pileup causes server to stall	Jeff Janes	17:33

Nov. 12, 2014

Thread	Author	Time
Re: Lock pileup causes server to stall	Jesper Krogh	06:49
Re: Lock pileup causes server to stall	Alvaro Herrera	13:51
Re: Lock pileup causes server to stall	Josh Berkus	17:04

Nov. 13, 2014

Thread	Author	Time
Re: Lock pileup causes server to stall	Jesper Krogh	06:53
9.0 performance degradation with kernel 3.11	Filip Rembiałkowski	08:10
Increased shared_buffer setting = lower hit ratio ?	CS DBA	23:09
Re: Increased shared_buffer setting = lower hit ratio ?	CS DBA	23:16
Re: Increased shared_buffer setting = lower hit ratio ?	Tomas Vondra	23:35

Nov. 14, 2014

Thread	Author	Time
Re: Increased shared_buffer setting = lower hit ratio ?	Jeff Janes	00:01
Re[2]: [PERFORM] pgtune + configurations with 9.3	Alexey Vasiliev	14:23
Re: 9.0 performance degradation with kernel 3.11	Glyn Astill	16:08
Re: pgtune + configurations with 9.3	Shaun Thomas	16:28
[PERFORM] pgtune + configurations with 9.3	Alexey Vasiliev	16:40
Re: pgtune + configurations with 9.3	Shaun Thomas	17:06
Re[2]: [PERFORM] pgtune + configurations with 9.3	Alexey Vasiliev	19:10
Re: pgtune + configurations with 9.3	Mark Kirkwood	23:00

Nov. 15, 2014

Thread	Author	Time
Re: updating statistics on slow running query	Jim Nasby	01:53
Re: pgtune + configurations with 9.3	Jim Nasby	02:08
Re: Index order ignored after `is null` in query	Jim Nasby	02:12
Re: pgtune + configurations with 9.3	Mark Kirkwood	03:29
Plan uses wrong index, preferring to scan pkey index instead	Yuri Kunde Schlesner	23:16
Re: Plan uses wrong index, preferring to scan pkey index instead	Yuri Kunde Schlesner	23:24

Nov. 16, 2014

Thread	Author	Time
Re: Plan uses wrong index, preferring to scan pkey index instead	Tom Lane	17:18
Re: Partitions and work_mem?	Dave Johansen	22:25

Nov. 17, 2014

Thread	Author	Time
Re: Re[2]: [PERFORM] pgtune + configurations with 9.3	Stuart Bishop	04:52
Re: pgtune + configurations with 9.3	Stuart Bishop	05:17
Re: Partitions and work_mem?	Magnus Hagander	06:57
Re: Partitions and work_mem?	Tom Lane	15:13

Nov. 18, 2014

Thread	Author	Time
Re: Partitions and work_mem?	Dave Johansen	03:34

Nov. 19, 2014

Thread	Author	Time
Re: Plan uses wrong index, preferring to scan pkey index instead	Yuri Kunde Schlesner	00:02

Nov. 21, 2014

Thread	Author	Time
A pessimistic planner	Stuart Bishop	05:07
Re: A pessimistic planner	Tom Lane	05:12
Re: Yet another abort-early plan disaster on 9.3	Jeff Janes	18:38

Nov. 23, 2014

Thread	Author	Time
Re: Yet another abort-early plan disaster on 9.3 📎	Tomas Vondra	20:19

Nov. 24, 2014

Thread	Author	Time
Re: pgtune + configurations with 9.3	Johann Spies	07:01
Why don't use index on x when ORDER BY x, y?	Vlad Arkhipov	11:02
Re: Why don't use index on x when ORDER BY x, y?	Robert Klemme	13:39
Re: Why don't use index on x when ORDER BY x, y?	Tom Lane	15:38

Nov. 25, 2014

Thread	Author	Time
Small performance regression in 9.2 has a big impact 📎	Scott Marlowe	20:36
Re: Small performance regression in 9.2 has a big impact	Heikki Linnakangas	20:58
Re: Small performance regression in 9.2 has a big impact	Tom Lane	21:55
Re: Small performance regression in 9.2 has a big impact	Scott Marlowe	22:25
Re: Small performance regression in 9.2 has a big impact	Tom Lane	22:57
Re: Small performance regression in 9.2 has a big impact	Tom Lane	23:02

Nov. 26, 2014

Thread	Author	Time
Re: Small performance regression in 9.2 has a big impact 📎	Tom Lane	03:59
issue in postgresql 9.1.3 in using arrow key in Solaris platform	M Tarkeshwar Rao	10:16
Re: pgtune + configurations with 9.3 📎	Johann Spies	13:34
Re: pgtune + configurations with 9.3 📎	Johann Spies	13:39
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform	Adrian Klaver	14:37
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform	Tom Lane	15:27
Re: Small performance regression in 9.2 has a big impact	Scott Marlowe	17:21

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

Browse Archives

Prev | Next