Home > mailing lists

Mailing lists [pgsql-performance]

3 October 2015

11:39 Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs
12:03 Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Gavin Flower
12:15 Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Wei Shan
12:27 Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Andres Freund
12:34 Re: Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs

5 October 2015

17:51 shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq
19:29 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure
21:24 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Igor Neyman
21:29 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Igor Neyman

6 October 2015

06:10 One long transaction or multiple short transactions? Carlo
12:33 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq
16:10 Re: One long transaction or multiple short transactions? Igor Neyman
18:10 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Scott Marlowe
23:35 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure

7 October 2015

08:08 Re: Multi processor server overloads occationally with system process while running postgresql-9.4 ajaykbs
08:35 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Josh Berkus
11:31 Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Scott Marlowe
13:29 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average FattahRozzaq
16:01 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Scott Marlowe
16:59 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average Merlin Moncure

8 October 2015

02:40 Re: One long transaction or multiple short transactions? Carlo
11:55 Re: One long transaction or multiple short transactions? Graeme B. Bell
12:17 large object write performance Bram Van Steenlandt
12:45 Re: large object write performance Graeme B. Bell
13:25 Re: large object write performance Graeme B. Bell
14:21 Re: large object write performance Graeme B. Bell
14:33 Re: large object write performance Bram Van Steenlandt
14:37 Re: large object write performance Graeme B. Bell
14:50 Re: large object write performance Bram Van Steenlandt
15:10 Re: large object write performance Bram Van Steenlandt
15:10 Re: large object write performance Graeme B. Bell
15:29 Re: large object write performance Bram Van Steenlandt
16:10 Re: large object write performance Graeme B. Bell
17:14 Re: large object write performance Bram Van Steenlandt
18:09 Re: One long transaction or multiple short transactions? Carlo
20:00 Re: One long transaction or multiple short transactions? ktm@rice.edu

9 October 2015

00:43 Re: One long transaction or multiple short transactions? Carlo
00:59 Re: One long transaction or multiple short transactions? ktm@rice.edu
09:45 Re: One long transaction or multiple short transactions? Laurent Martelli
11:33 Re: One long transaction or multiple short transactions? Graeme B. Bell
16:02 Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4 Kevin Grittner

10 October 2015

11:53 LIMIT 1 poor query plan Marcio Ribeiro
18:45 Re: LIMIT 1 poor query plan Tom Lane
20:45 Re: LIMIT 1 poor query plan Marcio Ribeiro

11 October 2015

11:05 3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab
12:43 Re: 3000x Slower query when using Foreign Data Wrapper vs. local desmodemone
13:10 Re: 3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab
13:49 Re: 3000x Slower query when using Foreign Data Wrapper vs. local desmodemone
13:58 Re: 3000x Slower query when using Foreign Data Wrapper vs. local Mohammad Habbab

12 October 2015

21:17 Having some problems with concurrent COPY commands Shaun Thomas
21:28 Re: Having some problems with concurrent COPY commands Andres Freund
21:56 Re: Having some problems with concurrent COPY commands Jeff Janes
23:14 Re: Having some problems with concurrent COPY commands Shaun Thomas

13 October 2015

11:47 V8 optimisation (if you're using javascript in postgres) Graeme B. Bell
12:32 Re: Having some problems with concurrent COPY commands Heikki Linnakangas
17:14 Re: Having some problems with concurrent COPY commands Shaun Thomas
17:23 Re: Having some problems with concurrent COPY commands Andres Freund
22:33 Re: Having some problems with concurrent COPY commands Shaun Thomas

14 October 2015

00:44 Re: Having some problems with concurrent COPY commands David Rowley
10:39 SELECT slows down on sixth execution Jonathan Rogers
12:00 Re: SELECT slows down on sixth execution Albe Laurenz
12:02 Re: SELECT slows down on sixth execution Pavel Stehule
18:28 Re: SELECT slows down on sixth execution Jonathan Rogers

16 October 2015

15:38 Re: SELECT slows down on sixth execution Albe Laurenz

17 October 2015

01:03 query partitioned table is very slow Vladimir Yavoskiy
02:04 Re: query partitioned table is very slow Tom Lane
05:14 Re: SELECT slows down on sixth execution Jonathan Rogers
05:32 Re: SELECT slows down on sixth execution Jonathan Rogers
06:52 Re: SELECT slows down on sixth execution Pavel Stehule
16:32 Re: SELECT slows down on sixth execution Yves Dorfsman
17:36 Re: SELECT slows down on sixth execution Pavel Stehule
18:28 Re: One long transaction or multiple short transactions? Jim Nasby
20:15 Re: One long transaction or multiple short transactions? Andres Freund
23:43 Re: One long transaction or multiple short transactions? Jim Nasby

19 October 2015

19:47 Re: SELECT slows down on sixth execution Merlin Moncure

20 October 2015

09:55 Re: SELECT slows down on sixth execution Thomas Kellerer
10:46 Re: SELECT slows down on sixth execution Pavel Stehule
17:48 Re: SELECT slows down on sixth execution Jonathan Rogers
18:02 Re: SELECT slows down on sixth execution Pavel Stehule

21 October 2015

08:10 Recursive query performance issue Jamie Koceniak
10:04 Re: Recursive query performance issue Pavel Stehule
16:23 Re: Recursive query performance issue Merlin Moncure
21:24 Re: Recursive query performance issue Pavel Stehule
22:26 Re: Recursive query performance issue Pavel Stehule
22:46 Re: Recursive query performance issue Pavel Stehule
22:49 Re: Recursive query performance issue Merlin Moncure

22 October 2015

17:48 Re: Recursive query performance issue vincent elschot

23 October 2015

17:29 GroupAggregate and Integer Arrays David Osborne
19:15 Re: GroupAggregate and Integer Arrays Jeff Janes
19:26 Re: GroupAggregate and Integer Arrays David Osborne
20:35 Re: GroupAggregate and Integer Arrays Merlin Moncure
21:01 Re: Recursive query performance issue Pavel Stehule

24 October 2015

22:27 Re: GroupAggregate and Integer Arrays Jeff Janes
23:23 Re: GroupAggregate and Integer Arrays Marc Mamin

26 October 2015

00:14 Re: Recursive query performance issue Jamie Koceniak
00:14 Re: Recursive query performance issue Jamie Koceniak
00:14 Re: Recursive query performance issue Jamie Koceniak
00:14 Re: Recursive query performance issue Jamie Koceniak
00:14 Re: Recursive query performance issue Jamie Koceniak
18:03 Re: Recursive query performance issue Merlin Moncure
20:45 Re: GroupAggregate and Integer Arrays David Osborne
21:21 Re: GroupAggregate and Integer Arrays Merlin Moncure

27 October 2015

12:35 Query planner wants to use seq scan Bertrand Paquet
14:08 Re: Query planner wants to use seq scan Alex Ignatov
14:10 Re: Query planner wants to use seq scan Bertrand Paquet
14:18 Re: Query planner wants to use seq scan Alex Ignatov
14:20 Re: Query planner wants to use seq scan Bertrand Paquet
14:30 Re: Query planner wants to use seq scan Alex Ignatov
15:03 Re: Query planner wants to use seq scan Tom Lane
16:06 Re: Query planner wants to use seq scan Bertrand Paquet
16:06 Re: Query planner wants to use seq scan Bertrand Paquet
20:33 Re: Query planner wants to use seq scan Bertrand Paquet
21:29 Partition Constraint Exclusion Limits GMail
22:03 Re: Partition Constraint Exclusion Limits David G. Johnston
23:33 Re: Partition Constraint Exclusion Limits Vitalii Tymchyshyn
23:56 Re: Query planner wants to use seq scan Bertrand Paquet

28 October 2015

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

29 October 2015

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

30 October 2015

03:00 Re: Query optimizer plans with very small selectivity estimates Josh Berkus