pgsql-performance - September 2015

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

Browse Archives

Prev | Next

Sept. 1, 2015

Thread Author Time
Re: Re: Query > 1000× slowdown after adding datetime comparison twoflower 07:53
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison 林士博 09:45
Re: Re: Query > 1000× slowdown after adding datetime comparison twoflower 09:51
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison 林士博 10:15
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison 林士博 10:25

Sept. 2, 2015

Thread Author Time
PostgreSQL Tuning for Messaging/Messenger/Chatting Application FattahRozzaq 12:16
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 13:53
query with pg_trgm sometimes very slow Volker Böhm 14:00
Re: Allow a per-tablespace effective_io_concurrency setting Tomas Vondra 16:06
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 16:45
Re: Allow a per-tablespace effective_io_concurrency setting Greg Stark 18:49
Re: Allow a per-tablespace effective_io_concurrency setting Julien Rouhaud 19:12
Re: query with pg_trgm sometimes very slow Jeff Janes 19:29
Re: Allow a per-tablespace effective_io_concurrency setting Julien Rouhaud 20:21
Re: Allow a per-tablespace effective_io_concurrency setting Tomas Vondra 21:25
Re: Allow a per-tablespace effective_io_concurrency setting Josh Berkus 21:31
Re: Allow a per-tablespace effective_io_concurrency setting Merlin Moncure 21:58
Re: Allow a per-tablespace effective_io_concurrency setting Jeff Janes 22:10
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 22:23
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 22:38
Re: Allow a per-tablespace effective_io_concurrency setting Tomas Vondra 23:59

Sept. 3, 2015

Thread Author Time
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 00:24
Re: Allow a per-tablespace effective_io_concurrency setting Greg Stark 01:44
Re: Server slowing down over time Igor Neyman 13:07
Re: Allow a per-tablespace effective_io_concurrency setting Merlin Moncure 13:13
Re: PostgreSQL Tuning for Messaging/Messenger/Chatting Application Sridhar N Bamandlapally 13:40
Re: query with pg_trgm sometimes very slow Claudio Freire 23:19

Sept. 4, 2015

Thread Author Time
Re: Server slowing down over time Wei Shan 06:13
Re: Server slowing down over time Tomas Vondra 11:59
Re: Allow a per-tablespace effective_io_concurrency setting Greg Stark 16:21
Re: Allow a per-tablespace effective_io_concurrency setting Bruce Momjian 16:23
Re: Allow a per-tablespace effective_io_concurrency setting Andres Freund 16:37

Sept. 5, 2015

Thread Author Time
Re: Allow a per-tablespace effective_io_concurrency setting Merlin Moncure 18:12

Sept. 6, 2015

Thread Author Time
Re: Allow a per-tablespace effective_io_concurrency setting 📎 Julien Rouhaud 13:49

Sept. 8, 2015

Thread Author Time
Re: Allow a per-tablespace effective_io_concurrency setting Alvaro Herrera 16:00
Re: Allow a per-tablespace effective_io_concurrency setting Julien Rouhaud 18:26
Re: query with pg_trgm sometimes very slow Merlin Moncure 19:15
Re: query with pg_trgm sometimes very slow Tomas Vondra 21:21
Re: query with pg_trgm sometimes very slow Merlin Moncure 21:24

Sept. 9, 2015

Thread Author Time
VACUUM VERBOSE ANALYZE taking long time to process. anil7385 10:43
Re: pg_stat_all_indexes understand Bruce Momjian 21:51

Sept. 10, 2015

Thread Author Time
Announcing the public availability of the TPCx-V prototype Reza Taheri 18:59

Sept. 14, 2015

Thread Author Time
Re: Server slowing down over time Jim Nasby 22:08

Sept. 15, 2015

Thread Author Time
Re: VACUUM VERBOSE ANALYZE taking long time to process. Ben Chobot 23:52

Sept. 17, 2015

Thread Author Time
degrading inser performance Eildert Groeneveld 11:32
Re: degrading inser performance Ladislav Lenart 12:11
Re: degrading inser performance Eildert Groeneveld 12:19
Re: degrading inser performance Matheus de Oliveira 14:21
Re: degrading inser performance Eildert Groeneveld 14:41
Occasional Really Slow Running Updates/Inserts Dave Stibrany 19:14
Re: Occasional Really Slow Running Updates/Inserts [email protected] 20:12
Re: degrading inser performance Dave Cramer 20:13
Re: Occasional Really Slow Running Updates/Inserts Dave Stibrany 22:14

Sept. 25, 2015

Thread Author Time
dump restoration performance rlemaroi 13:43

Sept. 26, 2015

Thread Author Time
Queries Per Second (QPS) Adam Scott 16:24

Sept. 27, 2015

Thread Author Time
Re: Queries Per Second (QPS) Guillaume Lelarge 06:02
Re: Queries Per Second (QPS) Guillaume Lelarge 06:06
Re: Queries Per Second (QPS) Jeff Janes 17:34

Sept. 29, 2015

Thread Author Time
Another parallel postgres project... Graeme B. Bell 08:41
Performance problem with gin index Bertrand Paquet 15:45
Re: Performance problem with gin index [email protected] 16:12
Re: Another parallel postgres project... Corey Huinker 16:25
Re: Performance problem with gin index Jeff Janes 17:17
Re: Performance problem with gin index Bertrand Paquet 20:51

Sept. 30, 2015

Thread Author Time
Re: dump restoration performance Michael Paquier 02:38
Re: Queries Per Second (QPS) Josh Berkus 17:06

Browse Archives

Prev | Next