pgsql-performance - October 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

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 2 3 5 6 7 8 9 10 11 12 13 14 16 17 19 20 21 22 23 24 26 27 28 29 30

Oct. 3, 2015

Thread Author Time
Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs 08:39
Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Gavin Flower 09:03
Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Wei Shan 09:15
Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Andres Freund 09:26
Re: Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs 09:34

Oct. 5, 2015

Thread Author Time
shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq 14:51
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure 16:29
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Igor Neyman 18:24
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Igor Neyman 18:29

Oct. 6, 2015

Thread Author Time
One long transaction or multiple short transactions? Carlo 03:10
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq 09:33
Re: One long transaction or multiple short transactions? Igor Neyman 13:10
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Scott Marlowe 15:10
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure 20:35

Oct. 7, 2015

Thread Author Time
Re: Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs 05:08
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Josh Berkus 05:35
Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Scott Marlowe 08:31
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq 10:29
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Scott Marlowe 13:01
Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure 13:59
Re: One long transaction or multiple short transactions? Carlo 23:40

Oct. 8, 2015

Thread Author Time
Re: One long transaction or multiple short transactions? Graeme B. Bell 08:54
large object write performance Bram Van Steenlandt 09:17
Re: large object write performance Graeme B. Bell 09:45
Re: large object write performance Graeme B. Bell 10:25
Re: large object write performance Graeme B. Bell 11:21
Re: large object write performance Bram Van Steenlandt 11:33
Re: large object write performance Graeme B. Bell 11:37
Re: large object write performance Bram Van Steenlandt 11:50
Re: large object write performance Bram Van Steenlandt 12:09
Re: large object write performance Graeme B. Bell 12:10
Re: large object write performance Bram Van Steenlandt 12:29
Re: large object write performance Graeme B. Bell 13:10
Re: large object write performance Bram Van Steenlandt 14:13
Re: One long transaction or multiple short transactions? Carlo 15:08
Re: One long transaction or multiple short transactions? [email protected] 17:00
Re: One long transaction or multiple short transactions? Carlo 21:43
Re: One long transaction or multiple short transactions? [email protected] 21:59

Oct. 9, 2015

Thread Author Time
Re: One long transaction or multiple short transactions? Laurent Martelli 06:45
Re: One long transaction or multiple short transactions? Graeme B. Bell 08:33
Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Kevin Grittner 13:01

Oct. 10, 2015

Thread Author Time
LIMIT 1 poor query plan Marcio Ribeiro 08:52
Re: LIMIT 1 poor query plan Tom Lane 15:45
Re: LIMIT 1 poor query plan Marcio Ribeiro 17:45

Oct. 11, 2015

Thread Author Time
3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab 08:05
Re: 3000x Slower query when using Foreign Data Wrapper vs. local desmodemone 09:42
Re: 3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab 10:10
Re: 3000x Slower query when using Foreign Data Wrapper vs. local desmodemone 10:48
Re: 3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab 10:58

Oct. 12, 2015

Thread Author Time
Having some problems with concurrent COPY commands Shaun Thomas 18:17
Re: Having some problems with concurrent COPY commands Andres Freund 18:28
Re: Having some problems with concurrent COPY commands Jeff Janes 18:56
Re: Having some problems with concurrent COPY commands Shaun Thomas 20:14

Oct. 13, 2015

Thread Author Time
V8 optimisation (if you're using javascript in postgres) Graeme B. Bell 08:47
Re: Having some problems with concurrent COPY commands 📎 Heikki Linnakangas 09:32
Re: Having some problems with concurrent COPY commands Shaun Thomas 14:14
Re: Having some problems with concurrent COPY commands Andres Freund 14:23
Re: Having some problems with concurrent COPY commands Shaun Thomas 19:33
Re: Having some problems with concurrent COPY commands David Rowley 21:44

Oct. 14, 2015

Thread Author Time
SELECT slows down on sixth execution Jonathan Rogers 07:38
Re: SELECT slows down on sixth execution Albe Laurenz 09:00
Re: SELECT slows down on sixth execution Pavel Stehule 09:01
Re: SELECT slows down on sixth execution Jonathan Rogers 15:28

Oct. 16, 2015

Thread Author Time
Re: SELECT slows down on sixth execution Albe Laurenz 12:37
query partitioned table is very slow Vladimir Yavoskiy 22:02
Re: query partitioned table is very slow Tom Lane 23:02

Oct. 17, 2015

Thread Author Time
Re: SELECT slows down on sixth execution Jonathan Rogers 02:14
Re: SELECT slows down on sixth execution Jonathan Rogers 02:29
Re: SELECT slows down on sixth execution Pavel Stehule 03:51
Re: SELECT slows down on sixth execution Yves Dorfsman 13:29
Re: SELECT slows down on sixth execution Pavel Stehule 14:33
Re: One long transaction or multiple short transactions? Jim Nasby 15:26
Re: One long transaction or multiple short transactions? Andres Freund 17:13
Re: One long transaction or multiple short transactions? Jim Nasby 20:43

Oct. 19, 2015

Thread Author Time
Re: SELECT slows down on sixth execution Merlin Moncure 16:47

Oct. 20, 2015

Thread Author Time
Re: SELECT slows down on sixth execution Thomas Kellerer 06:55
Re: SELECT slows down on sixth execution Pavel Stehule 07:45
Re: SELECT slows down on sixth execution Jonathan Rogers 14:48
Re: SELECT slows down on sixth execution Pavel Stehule 15:01
Recursive query performance issue Jamie Koceniak 17:34

Oct. 21, 2015

Thread Author Time
Re: Recursive query performance issue Pavel Stehule 07:03
Re: Recursive query performance issue Merlin Moncure 13:22
Re: Recursive query performance issue Jamie Koceniak 17:55
Re: Recursive query performance issue Pavel Stehule 18:23
Re: Recursive query performance issue Jamie Koceniak 18:40
Re: Recursive query performance issue Jamie Koceniak 18:51
Re: Recursive query performance issue Pavel Stehule 19:25
Re: Recursive query performance issue Jamie Koceniak 19:32
Re: Recursive query performance issue Pavel Stehule 19:45
Re: Recursive query performance issue Merlin Moncure 19:49

Oct. 22, 2015

Thread Author Time
Re: Recursive query performance issue vincent elschot 14:48

Oct. 23, 2015

Thread Author Time
GroupAggregate and Integer Arrays David Osborne 14:29
Re: GroupAggregate and Integer Arrays Jeff Janes 16:15
Re: GroupAggregate and Integer Arrays David Osborne 16:26
Re: GroupAggregate and Integer Arrays Merlin Moncure 17:35
Re: Recursive query performance issue Jamie Koceniak 17:45
Re: Recursive query performance issue Pavel Stehule 18:00

Oct. 24, 2015

Thread Author Time
Re: GroupAggregate and Integer Arrays Jeff Janes 19:27
Re: GroupAggregate and Integer Arrays Marc Mamin 20:23

Oct. 26, 2015

Thread Author Time
Re: Recursive query performance issue Merlin Moncure 15:03
Re: GroupAggregate and Integer Arrays David Osborne 17:45
Re: GroupAggregate and Integer Arrays Merlin Moncure 18:21

Oct. 27, 2015

Thread Author Time
Query planner wants to use seq scan Bertrand Paquet 09:35
Re: Query planner wants to use seq scan Alex Ignatov 11:08
Re: Query planner wants to use seq scan Bertrand Paquet 11:10
Re: Query planner wants to use seq scan Alex Ignatov 11:17
Re: Query planner wants to use seq scan Bertrand Paquet 11:19
Re: Query planner wants to use seq scan Alex Ignatov 11:30
Re: Query planner wants to use seq scan Tom Lane 12:03
Re: Query planner wants to use seq scan Bertrand Paquet 13:06
Re: Query planner wants to use seq scan Bertrand Paquet 13:06
Re: Query planner wants to use seq scan Bertrand Paquet 17:33
Partition Constraint Exclusion Limits GMail 18:29
Re: Partition Constraint Exclusion Limits David G. Johnston 19:03
Re: Partition Constraint Exclusion Limits Vitalii Tymchyshyn 20:33
Re: Query planner wants to use seq scan Bertrand Paquet 20:56

Oct. 28, 2015

Thread Author Time
Re: Partition Constraint Exclusion Limits Jim Nasby 02:59
Re: Query planner wants to use seq scan Jim Nasby 03:07
Scalability to more than 64 cores With PG 9.4 and RHEL 7.1 Kernel 3.10 Javier Muro 05:04

Oct. 29, 2015

Thread Author Time
Re: Query planner wants to use seq scan Alex Ignatov 12:27
Re: Query planner wants to use seq scan Bertrand Paquet 13:16
Re: Scalability to more than 64 cores With PG 9.4 and RHEL 7.1 Kernel 3.10 Alex Ignatov 13:46
Query optimizer plans with very small selectivity estimates Matthew Bellew 16:52
Re: Query optimizer plans with very small selectivity estimates Tom Lane 18:24

Oct. 30, 2015

Thread Author Time
Re: Query optimizer plans with very small selectivity estimates Josh Berkus 00:00

Browse Archives

Prev | Next
Jump to day: 2 3 5 6 7 8 9 10 11 12 13 14 16 17 19 20 21 22 23 24 26 27 28 29 30