pgsql-performance - April 2014

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 4 5 6 7 8 9 11 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29

April 1, 2014

Thread Author Time
Re: Sudden crazy high CPU usage Niels Kristian Schjødt 21:50
Re: Sudden crazy high CPU usage Andres Freund 22:16

April 2, 2014

Thread Author Time
Re: Slow Count-Distinct Query bricklen 00:34
Re: Slow Count-Distinct Query Christopher Jackson 04:22
Re: Slow Count-Distinct Query Michael Paquier 04:48
Re: Slow Count-Distinct Query Christopher Jackson 04:54
Re: Why shared_buffers max is 8GB? Alexey Klyukin 09:38

April 3, 2014

Thread Author Time
Re: Sudden crazy high CPU usage Michael Paquier 00:00
PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 00:38
PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 17:39
Re: PGSQL, checkpoints, and file system syncs Heikki Linnakangas 18:01
Re: PGSQL, checkpoints, and file system syncs Reza Taheri 18:11

April 4, 2014

Thread Author Time
Re: PGSQL, checkpoints, and file system syncs Ilya Kosmodemiansky 06:11
Fwd: Slow Count-Distinct Query Varadharajan Mukundan 09:31
Batch update query performance Hans Drexler 12:00
PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 16:29
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 16:54
Re: Fwd: Slow Count-Distinct Query Jeff Janes 17:59
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 19:49
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 19:57
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 20:07
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 20:14
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 20:26
Re: PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 20:27
Re: PGSQL 9.3 - Materialized View - multithreading ktm@rice.edu 20:34

April 5, 2014

Thread Author Time
Re: Fwd: Slow Count-Distinct Query Varadharajan Mukundan 01:13

April 6, 2014

Thread Author Time
SSI slows down over time Ryan Johnson 02:25
Re: SSI slows down over time Heikki Linnakangas 08:30
Re: SSI slows down over time Tom Lane 14:55
Slow Count-Distinct Query Jeff Janes 17:26
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 19:07
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 22:21

April 7, 2014

Thread Author Time
Re: Slow Count-Distinct Query Varadharajan Mukundan 02:34
The same query - much different runtimes Johann Spies 10:25
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 10:29
Re: SSI slows down over time Ryan Johnson 10:52
Re: The same query - much different runtimes Pavan Deolasee 10:58
Re: Batch update query performance Albe Laurenz 12:06
Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 12:49
Re: Batch update query performance Heikki Linnakangas 12:53
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 12:59
Re: performance degradation after launching postgres cluster using pgpool-II Tatsuo Ishii 13:46
Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 13:56
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 14:05
Re: SSI slows down over time Ryan Johnson 14:11
Re: SSI slows down over time Ryan Johnson 14:36
Re: SSI slows down over time Ryan Johnson 14:38
Performance regressions in PG 9.3 vs PG 9.0 uher dslij 18:34
Re: Batch update query performance Jeff Janes 21:26

April 8, 2014

Thread Author Time
Nested loop issue Manoj Gadi 09:35
performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 11:53
query against large table not using sensible index to find very small amount of data Andrew W. Gibbs 12:48
Re: batch update query performance Hans Drexler 13:21
Re: query against large table not using sensible index to find very small amount of data Shaun Thomas 13:39
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 13:50
Re: query against large table not using sensible index to find very small amount of data Tom Lane 13:55
Re: PGSQL, checkpoints, and file system syncs Shaun Thomas 14:00
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 17:33
Re: Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 17:41
Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij 19:58
Re: Nested loop issue Dhananjay Singh 20:40
Optimizing Time Series Access Robert Burgholzer 21:20
Re: Performance regressions in PG 9.3 vs PG 9.0 Tom Lane 21:26
Re: query against large table not using sensible index to find very small amount of data Jeff Janes 22:51

April 9, 2014

Thread Author Time
Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij 00:16
Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij 00:23
Re: query against large table not using sensible index to find very small amount of data 'Andrew W. Gibbs' 00:57
Re: Performance regressions in PG 9.3 vs PG 9.0 Tom Lane 01:39
Re: Why shared_buffers max is 8GB? Bruce Momjian 11:46
Re: PGSQL, checkpoints, and file system syncs Bruce Momjian 16:42
Re: PGSQL, checkpoints, and file system syncs Bruce Momjian 16:51
Interesting case of index un-usage Claudio Freire 18:56
Re: Optimizing Time Series Access Robert Burgholzer 19:48
Re: SSI slows down over time Bruce Momjian 21:21

April 11, 2014

Thread Author Time
Re: performance degradation after launching postgres cluster using pgpool-II Cora Ma 07:29

April 13, 2014

Thread Author Time
Re: query against large table not using sensible index to find very small amount of data Andrew W. Gibbs 00:12

April 14, 2014

Thread Author Time
Re: batch update query performance Jeff Janes 00:02
Checkpoint distribution Borodin Vladimir 09:46
SSI slows down over time Ryan Johnson 12:58
Re: SSI slows down over time Ryan Johnson 12:59
Re: Ye olde slow query Murphy, Kevin 13:55
Re: SSI slows down over time Kevin Grittner 14:14
Re: SSI slows down over time Ryan Johnson 14:22
Re: Getting query plan alternatives from query planner? Kevin Grittner 14:39
Re: Getting query plan alternatives from query planner? Eric Schwarzenbach 14:59
Re: Checkpoint distribution Jeff Janes 15:11
Re: Getting query plan alternatives from query planner? Craig James 15:35
Re: SSI slows down over time Kevin Grittner 15:54
Approach to Data Summary and Analysis Robert DiFalco 16:27
Re: Checkpoint distribution Borodin Vladimir 16:42
Re: Checkpoint distribution Jeff Janes 18:09
Re: Getting query plan alternatives from query planner? Stefan Keller 18:36
Re: Getting query plan alternatives from query planner? Heikki Linnakangas 19:18
Re: SSI slows down over time Ryan Johnson 20:30
Re: Approach to Data Summary and Analysis Vincent Veyron 21:35
Tuning Postgres for Single connection use Nick Eubank 21:46
HFS+ pg_test_fsync performance Mel Llaguno 22:32
Re: Tuning Postgres for Single connection use Gavin Flower 22:41
Re: Tuning Postgres for Single connection use Nick Eubank 23:39

April 15, 2014

Thread Author Time
Re: Tuning Postgres for Single connection use Andrew Dunstan 00:12
Re: Tuning Postgres for Single connection use Jeff Janes 00:19
Re: Tuning Postgres for Single connection use Gavin Flower 00:29
Re: Tuning Postgres for Single connection use Nick Eubank 00:50
Re: SSI slows down over time Ryan Johnson 01:57
Re: Checkpoint distribution Borodin Vladimir 10:16
Re: HFS+ pg_test_fsync performance desmodemone 12:18
Re: HFS+ pg_test_fsync performance Mel Llaguno 14:31
Re: [GENERAL] Approach to Data Summary and Analysis Chris Curvey 14:56
Re: Approach to Data Summary and Analysis Chris Curvey 15:12
Re: [GENERAL] Approach to Data Summary and Analysis Robert DiFalco 15:53
Testing strategies Dave Cramer 15:57
Re: Approach to Data Summary and Analysis Rob Sargent 16:02
Re: Tuning Postgres for Single connection use Nick Eubank 16:12
Re: Tuning Postgres for Single connection use Jeff Janes 16:43
Re: Tuning Postgres for Single connection use Schnabel, Robert D. 16:43
Re: Tuning Postgres for Single connection use Tom Lane 17:05
Tuning Postgres for Single connection use Nick Eubank 18:51
Re: Testing strategies Matheus de Oliveira 20:23
Re: Approach to Data Summary and Analysis Roxanne Reid-Bennett 22:26

April 16, 2014

Thread Author Time
Re: Approach to Data Summary and Analysis Robert DiFalco 01:10
Re: Approach to Data Summary and Analysis Gavin Flower 01:27
Workaround for working_mem max value in windows? Nick Eubank 01:36
Re: Workaround for working_mem max value in windows? Martin French 06:42
Re: Workaround for working_mem max value in windows? amulsul 08:29
Queries very slow after data size increases sheishere b 13:05
unneeded joins on view Linos 15:13
Re: Approach to Data Summary and Analysis Roxanne Reid-Bennett 15:42
Re: unneeded joins on view Heikki Linnakangas 15:57
Re: unneeded joins on view Linos 16:08
Re: Workaround for working_mem max value in windows? Nick Eubank 16:35
Re: Workaround for working_mem max value in windows? Martin French 17:08
Re: Approach to Data Summary and Analysis Robert DiFalco 18:40
Re: Workaround for working_mem max value in windows? Jeff Janes 19:48

April 17, 2014

Thread Author Time
Re: Workaround for working_mem max value in windows? Nick Eubank 01:35
Re: Workaround for working_mem max value in windows? amul sul 07:05
Fast distinct not working as expected Franck Routier 15:11
Re: Fast distinct not working as expected Jeff Janes 15:57
Re: Fast distinct not working as expected Franck Routier 17:17
Re: Fast distinct not working as expected Jeff Janes 18:17

April 18, 2014

Thread Author Time
Re: Approach to Data Summary and Analysis Roxanne Reid-Bennett 05:46
Re: Fast distinct not working as expected Franck Routier 07:22
Re: Fast distinct not working as expected Franck Routier 08:07
Hot standby 9.2.1 PANIC: WAL contains references to invalid pages Vishalakshi Navaneethakrishnan 08:23
Help on migrating data from MSSQL2008R2 to PostgreSQL 9.3 Wureka JI 08:33

April 19, 2014

Thread Author Time
tsearch2, large data and indexes Ivan Voras 23:15
Re: Hot standby 9.2.1 PANIC: WAL contains references to invalid pages Sergey Konoplev 23:41

April 20, 2014

Thread Author Time
IP addresses, NetBlocks, and ASNs Gary Warner 02:12
Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Laurence Parry 04:30
Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Oleg Bartunov 04:46
Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Laurence Parry 05:44
Re: IP addresses, NetBlocks, and ASNs Steve Atkins 14:57
Re: IP addresses, NetBlocks, and ASNs Gary Warner 21:01

April 21, 2014

Thread Author Time
Re: Fast distinct not working as expected Merlin Moncure 14:16

April 22, 2014

Thread Author Time
Best practices for update timestamp with/without triggers Verghese, Riya 01:16
Best practice question Tory M Blue 01:19
Re: Best practice question David G Johnston 01:31
Re: Best practice question Sergey Konoplev 02:01
Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Heikki Linnakangas 06:28
Re: tsearch2, large data and indexes Heikki Linnakangas 06:40
Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Oleg Bartunov 07:15
Re: tsearch2, large data and indexes Ivan Voras 07:57
Query on partitioned table not using index Souquieres Adam 10:14
Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Tom Lane 13:58
Re: Stalls on PGSemaphoreLock Matthew Spilich 15:12
Re: Stalls on PGSemaphoreLock Matheus de Oliveira 15:48
Re: tsearch2, large data and indexes Jeff Janes 15:58

April 23, 2014

Thread Author Time
Re: Best practices for update timestamp with/without triggers hubert depesz lubaczewski 10:28
Re: tsearch2, large data and indexes Ivan Voras 11:08
Re: tsearch2, large data and indexes Matheus de Oliveira 12:26
Re: tsearch2, large data and indexes Heikki Linnakangas 13:00
Re: Adding new field to big table RichmondDyes 17:59
Re: HFS+ pg_test_fsync performance Josh Berkus 18:04
Re: HFS+ pg_test_fsync performance Mel Llaguno 18:19
Re: HFS+ pg_test_fsync performance Josh Berkus 18:29
Re: tsearch2, large data and indexes Sergey Konoplev 22:56

April 24, 2014

Thread Author Time
Re: tsearch2, large data and indexes Heikki Linnakangas 11:34
Re: tsearch2, large data and indexes Ivan Voras 12:34
Re: tsearch2, large data and indexes Sergey Konoplev 19:27
Poor performance for delete query Jonatan Evald Buus 19:42
Re: tsearch2, large data and indexes Sergey Konoplev 19:57
Re: Poor performance for delete query Tom Lane 20:29
Re: Poor performance for delete query Jonatan Evald Buus 20:57
Re: Poor performance for delete query Tom Lane 21:25

April 25, 2014

Thread Author Time
Re: Poor performance for delete query Jonatan Evald Buus 05:04
Re: tsearch2, large data and indexes Heikki Linnakangas 06:37
Server vacuuming the same table again and again Дмитрий Шалашов 07:47
Re: Server vacuuming the same table again and again Ilya Kosmodemiansky 08:12
Re: Server vacuuming the same table again and again Дмитрий Шалашов 08:22
Re: Server vacuuming the same table again and again Дмитрий Шалашов 08:29
pl/pgsql performance Mehdi Ravanbakhsh 08:48
Re: pl/pgsql performance Pavel Stehule 08:53
Re: Server vacuuming the same table again and again Ilya Kosmodemiansky 09:19
Re: Server vacuuming the same table again and again Ilya Kosmodemiansky 09:22
Re: Server vacuuming the same table again and again Дмитрий Шалашов 09:31
Re: Server vacuuming the same table again and again Ilya Kosmodemiansky 09:46
Re: Server vacuuming the same table again and again Torsten Förtsch 09:47
Re: Server vacuuming the same table again and again Дмитрий Шалашов 10:36
Re: Poor performance for delete query Tom Lane 14:36

April 27, 2014

Thread Author Time
Checkpoints and slow queries Elanchezhiyan Elango 12:08
Re: pl/pgsql performance Michael Paquier 12:41

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 11 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29