Mailing lists [pgsql-performance]

2 April 2014

• 00:51   Re: Sudden crazy high CPU usage Niels Kristian Schjødt
• 01:17   Re: Sudden crazy high CPU usage Andres Freund
• 03:34   Re: Slow Count-Distinct Query bricklen
• 07:22   Re: Slow Count-Distinct Query Christopher Jackson
• 07:48   Re: Slow Count-Distinct Query Michael Paquier
• 07:54   Re: Slow Count-Distinct Query Christopher Jackson
• 12:39   Re: Why shared_buffers max is 8GB? Alexey Klyukin

3 April 2014

• 03:00   Re: Sudden crazy high CPU usage Michael Paquier
• 20:39   PGSQL, checkpoints, and file system syncs Reza Taheri
• 21:01   Re: PGSQL, checkpoints, and file system syncs Heikki Linnakangas
• 21:11   Re: PGSQL, checkpoints, and file system syncs Reza Taheri

4 April 2014

• 09:11   Re: PGSQL, checkpoints, and file system syncs Ilya Kosmodemiansky
• 12:32   Fwd: Slow Count-Distinct Query Varadharajan Mukundan
• 19:29   PGSQL 9.3 - Materialized View - multithreading Nicolas Paris
• 19:54   Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown
• 20:59   Re: Fwd: Slow Count-Distinct Query Jeff Janes
• 22:49   Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas
• 22:57   Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown
• 23:12   Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas
• 23:15   Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown
• 23:26   Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas
• 23:27   Re: PGSQL, checkpoints, and file system syncs Reza Taheri
• 23:34   Re: PGSQL 9.3 - Materialized View - multithreading ktm@rice.edu

5 April 2014

• 04:13   Re: Fwd: Slow Count-Distinct Query Varadharajan Mukundan

6 April 2014

• 05:25   SSI slows down over time Ryan Johnson
• 11:31   Re: SSI slows down over time Heikki Linnakangas
• 17:55   Re: SSI slows down over time Tom Lane
• 20:26   Slow Count-Distinct Query Jeff Janes
• 22:08   Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown

7 April 2014

• 01:22   Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas
• 05:34   Re: Slow Count-Distinct Query Varadharajan Mukundan
• 13:26   The same query - much different runtimes Johann Spies
• 13:29   Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell
• 13:53   Re: SSI slows down over time Ryan Johnson
• 13:59   Re: The same query - much different runtimes Pavan Deolasee
• 14:03   performance degradation after launching postgres cluster using pgpool-II Cora Ma
• 14:03   PGSQL, checkpoints, and file system syncs Reza Taheri
• 14:03   Batch update query performance Hans Drexler
• 15:06   Re: Batch update query performance Albe Laurenz
• 15:49   Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris
• 15:53   Re: Batch update query performance Heikki Linnakangas
• 15:59   Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell
• 16:46   Re: performance degradation after launching postgres cluster using pgpool-II Tatsuo Ishii
• 16:56   Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris
• 17:05   Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell
• 17:36   Re: SSI slows down over time Ryan Johnson
• 17:39   Re: SSI slows down over time Ryan Johnson
• 21:34   Performance regressions in PG 9.3 vs PG 9.0 uher dslij

8 April 2014

• 00:26   Re: Batch update query performance Jeff Janes
• 12:34   Nested loop issue Manoj Gadi
• 14:54   performance drop when function argument is evaluated in WHERE clause Gerardo Herzig
• 15:50   query against large table not using sensible index to find very small amount of data Andrew W. Gibbs
• 16:39   Re: query against large table not using sensible index to find very small amount of data Shaun Thomas
• 16:50   Re: performance drop when function argument is evaluated in WHERE clause Tom Lane
• 16:55   Re: query against large table not using sensible index to find very small amount of data Tom Lane
• 17:00   Re: PGSQL, checkpoints, and file system syncs Shaun Thomas
• 20:33   Re: performance drop when function argument is evaluated in WHERE clause Gerardo Herzig
• 20:41   Re: [SQL] Re: performance drop when function argument is evaluated in WHERE clause Tom Lane
• 22:58   Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij
• 23:40   Re: Nested loop issue Dhananjay Singh

9 April 2014

• 00:21   Optimizing Time Series Access Robert Burgholzer
• 00:26   Re: Performance regressions in PG 9.3 vs PG 9.0 Tom Lane
• 01:51   Re: query against large table not using sensible index to find very small amount of data Jeff Janes
• 03:16   Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij
• 03:23   Re: Performance regressions in PG 9.3 vs PG 9.0 uher dslij
• 03:57   Re: query against large table not using sensible index to find very small amount of data 'Andrew W. Gibbs'
• 04:39   Re: Performance regressions in PG 9.3 vs PG 9.0 Tom Lane
• 14:46   Re: Why shared_buffers max is 8GB? Bruce Momjian
• 19:42   Re: PGSQL, checkpoints, and file system syncs Bruce Momjian
• 19:51   Re: PGSQL, checkpoints, and file system syncs Bruce Momjian
• 21:56   Interesting case of index un-usage Claudio Freire
• 22:49   Re: Optimizing Time Series Access Robert Burgholzer

10 April 2014

• 00:21   Re: SSI slows down over time Bruce Momjian

12 April 2014

• 21:20   Re: SSI slows down over time Ryan Johnson
• 21:20   Re: batch update query performance Hans Drexler
• 21:20   Re: performance degradation after launching postgres cluster using pgpool-II Cora Ma

13 April 2014

• 03:12   Re: query against large table not using sensible index to find very small amount of data Andrew W. Gibbs

14 April 2014

• 03:02   Re: batch update query performance Jeff Janes
• 12:47   Checkpoint distribution Borodin Vladimir
• 15:58   SSI slows down over time Ryan Johnson
• 15:59   Re: SSI slows down over time Ryan Johnson
• 16:56   Re: Ye olde slow query Murphy, Kevin
• 17:14   Re: SSI slows down over time Kevin Grittner
• 17:22   Re: SSI slows down over time Ryan Johnson
• 17:39   Re: Getting query plan alternatives from query planner? Kevin Grittner
• 18:00   Re: Getting query plan alternatives from query planner? Eric Schwarzenbach
• 18:11   Re: Checkpoint distribution Jeff Janes
• 18:35   Re: Getting query plan alternatives from query planner? Craig James
• 18:54   Re: SSI slows down over time Kevin Grittner
• 19:27   Approach to Data Summary and Analysis Robert DiFalco
• 19:42   Re: Checkpoint distribution Borodin Vladimir
• 21:09   Re: Checkpoint distribution Jeff Janes
• 21:36   Re: Getting query plan alternatives from query planner? Stefan Keller
• 22:18   Re: Getting query plan alternatives from query planner? Heikki Linnakangas
• 23:31   Re: SSI slows down over time Ryan Johnson

15 April 2014

• 00:46   Tuning Postgres for Single connection use Nick Eubank
• 01:32   HFS+ pg_test_fsync performance Mel Llaguno
• 01:42   Re: Tuning Postgres for Single connection use Gavin Flower
• 02:39   Re: Tuning Postgres for Single connection use Nick Eubank
• 03:12   Re: Tuning Postgres for Single connection use Andrew Dunstan
• 03:19   Re: Tuning Postgres for Single connection use Jeff Janes
• 03:29   Re: Tuning Postgres for Single connection use Gavin Flower
• 03:50   Re: Tuning Postgres for Single connection use Nick Eubank
• 04:57   Re: SSI slows down over time Ryan Johnson
• 13:16   Re: Checkpoint distribution Borodin Vladimir
• 15:18   Re: HFS+ pg_test_fsync performance desmodemone
• 17:31   Re: HFS+ pg_test_fsync performance Mel Llaguno
• 17:56   Re: [GENERAL] Approach to Data Summary and Analysis Chris Curvey
• 18:13   Re: [GENERAL] Approach to Data Summary and Analysis Chris Curvey
• 18:53   Re: [GENERAL] Approach to Data Summary and Analysis Robert DiFalco
• 18:57   Testing strategies Dave Cramer
• 19:12   Re: Tuning Postgres for Single connection use Nick Eubank
• 19:43   Re: Tuning Postgres for Single connection use Jeff Janes
• 19:43   Re: Tuning Postgres for Single connection use Schnabel, Robert D.
• 20:05   Re: Tuning Postgres for Single connection use Tom Lane
• 21:52   Tuning Postgres for Single connection use Nick Eubank
• 23:24   Re: Testing strategies Matheus de Oliveira

16 April 2014

• 04:36   Workaround for working_mem max value in windows? Nick Eubank
• 09:42   Re: Workaround for working_mem max value in windows? Martin French
• 11:29   Re: Workaround for working_mem max value in windows? amulsul
• 16:05   Queries very slow after data size increases sheishere b
• 18:13   unneeded joins on view Linos
• 18:57   Re: unneeded joins on view Heikki Linnakangas
• 19:08   Re: unneeded joins on view Linos
• 19:35   Re: Workaround for working_mem max value in windows? Nick Eubank
• 20:08   Re: Workaround for working_mem max value in windows? Martin French
• 22:48   Re: Workaround for working_mem max value in windows? Jeff Janes

17 April 2014

• 04:35   Re: Workaround for working_mem max value in windows? Nick Eubank
• 10:06   Re: Workaround for working_mem max value in windows? amul sul
• 18:13   Fast distinct not working as expected Franck Routier
• 18:57   Re: Fast distinct not working as expected Jeff Janes
• 20:18   Re: Fast distinct not working as expected Franck Routier
• 21:17   Re: Fast distinct not working as expected Jeff Janes

18 April 2014

• 10:23   Re: Fast distinct not working as expected Franck Routier
• 11:08   Re: Fast distinct not working as expected Franck Routier
• 11:24   Hot standby 9.2.1 PANIC: WAL contains references to invalid pages Vishalakshi Navaneethakrishnan

20 April 2014

• 02:16   tsearch2, large data and indexes Ivan Voras
• 02:42   Re: Hot standby 9.2.1 PANIC: WAL contains references to invalid pages Sergey Konoplev
• 05:12   IP addresses, NetBlocks, and ASNs Gary Warner
• 07:30   Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Laurence Parry
• 07:46   Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Oleg Bartunov
• 08:44   Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Laurence Parry
• 17:57   Re: IP addresses, NetBlocks, and ASNs Steve Atkins

21 April 2014

• 00:01   Re: IP addresses, NetBlocks, and ASNs Gary Warner
• 17:16   Re: Fast distinct not working as expected Merlin Moncure

22 April 2014

• 04:19   Best practice question Tory M Blue
• 04:31   Re: Best practice question David G Johnston
• 05:02   Re: Best practice question Sergey Konoplev
• 09:28   Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Heikki Linnakangas
• 09:40   Re: tsearch2, large data and indexes Heikki Linnakangas
• 10:15   Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Oleg Bartunov
• 10:58   Re: tsearch2, large data and indexes Ivan Voras
• 13:15   Query on partitioned table not using index Souquieres Adam
• 16:58   Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search Tom Lane
• 18:13   Re: Stalls on PGSemaphoreLock Matthew Spilich
• 18:48   Re: Stalls on PGSemaphoreLock Matheus de Oliveira
• 18:59   Re: tsearch2, large data and indexes Jeff Janes

23 April 2014

• 05:05   Help on migrating data from MSSQL2008R2 to PostgreSQL 9.3 Wureka JI
• 05:05   Best practices for update timestamp with/without triggers Verghese, Riya
• 13:29   Re: Best practices for update timestamp with/without triggers hubert depesz lubaczewski
• 14:09   Re: tsearch2, large data and indexes Ivan Voras
• 15:27   Re: tsearch2, large data and indexes Matheus de Oliveira
• 16:00   Re: tsearch2, large data and indexes Heikki Linnakangas
• 21:05   Re: HFS+ pg_test_fsync performance Josh Berkus
• 21:19   Re: HFS+ pg_test_fsync performance Mel Llaguno
• 21:29   Re: HFS+ pg_test_fsync performance Josh Berkus

24 April 2014

• 01:56   Re: tsearch2, large data and indexes Sergey Konoplev
• 14:34   Re: tsearch2, large data and indexes Heikki Linnakangas
• 15:34   Re: tsearch2, large data and indexes Ivan Voras
• 22:27   Re: tsearch2, large data and indexes Sergey Konoplev
• 22:42   Poor performance for delete query Jonatan Evald Buus
• 22:58   Re: tsearch2, large data and indexes Sergey Konoplev
• 23:29   Re: Poor performance for delete query Tom Lane
• 23:57   Re: Poor performance for delete query Jonatan Evald Buus

25 April 2014

• 00:25   Re: Poor performance for delete query Tom Lane
• 08:05   Re: Poor performance for delete query Jonatan Evald Buus
• 09:38   Re: tsearch2, large data and indexes Heikki Linnakangas
• 10:48   Server vacuuming the same table again and again Дмитрий Шалашов
• 11:13   Re: Server vacuuming the same table again and again Ilya Kosmodemiansky
• 11:23   Re: Server vacuuming the same table again and again Дмитрий Шалашов
• 11:29   Re: Server vacuuming the same table again and again Дмитрий Шалашов
• 11:48   pl/pgsql performance Mehdi Ravanbakhsh
• 11:53   Re: pl/pgsql performance Pavel Stehule
• 12:19   Re: Server vacuuming the same table again and again Ilya Kosmodemiansky
• 12:23   Re: Server vacuuming the same table again and again Ilya Kosmodemiansky
• 12:32   Re: Server vacuuming the same table again and again Дмитрий Шалашов
• 12:47   Re: Server vacuuming the same table again and again Ilya Kosmodemiansky
• 12:47   Re: Server vacuuming the same table again and again Torsten Förtsch
• 13:36   Re: Server vacuuming the same table again and again Дмитрий Шалашов
• 17:36   Re: Poor performance for delete query Tom Lane

27 April 2014

• 15:41   Re: pl/pgsql performance Michael Paquier

28 April 2014

• 00:02   Checkpoints and slow queries Elanchezhiyan Elango
• 01:46   Re: Checkpoints and slow queries Tomas Vondra
• 08:50   Re: Checkpoints and slow queries Elanchezhiyan Elango
• 16:41   Varying performacne results after instance restart MadDamon
• 17:07   Re: Checkpoints and slow queries Tom Lane
• 18:48   Revisiting disk layout on ZFS systems Karl Denninger
• 20:12   Slow queries on 9.3.1 despite use of index Michael van Rooyen
• 20:50   Re: Slow queries on 9.3.1 despite use of index Tom Lane
• 20:52   Re: Slow queries on 9.3.1 despite use of index Jeff Janes
• 21:04   Re: Revisiting disk layout on ZFS systems Heikki Linnakangas
• 21:07   Re: Revisiting disk layout on ZFS systems Karl Denninger
• 21:22   Re: Revisiting disk layout on ZFS systems Heikki Linnakangas
• 21:26   Re: Revisiting disk layout on ZFS systems Jeff Janes
• 21:27   Re: Revisiting disk layout on ZFS systems Karl Denninger
• 21:29   Re: Revisiting disk layout on ZFS systems Karl Denninger
• 23:41   Re: Checkpoints and slow queries Tomas Vondra
• 23:54   Re: Checkpoints and slow queries Jeff Janes
• 23:59   Re: Checkpoints and slow queries Tomas Vondra

29 April 2014

• 00:10   Re: Checkpoints and slow queries Tomas Vondra
• 00:19   Re: Checkpoints and slow queries Tomas Vondra
• 00:22   Re: Slow queries on 9.3.1 despite use of index Michael van Rooyen
• 02:06   Re: Slow queries on 9.3.1 despite use of index Tom Lane
• 11:13   Re: Revisiting disk layout on ZFS systems Albe Laurenz
• 15:12   Re: Revisiting disk layout on ZFS systems Karl Denninger
• 17:18   Re: Slow queries on 9.3.1 despite use of index Michael van Rooyen