Home > mailing lists

Mailing lists [pgsql-performance]

2 January 2019

19:28 select query does not pick up the right index Abadie Lana
19:45 Re: select query does not pick up the right index Justin Pryzby

3 January 2019

03:15 Re: select query does not pick up the right index David Rowley
15:57 RE: select query does not pick up the right index Abadie Lana
15:58 RE: select query does not pick up the right index Abadie Lana
16:01 Re: select query does not pick up the right index David Rowley
16:13 RE: select query does not pick up the right index Abadie Lana
16:17 Re: select query does not pick up the right index David Rowley
16:20 RE: select query does not pick up the right index Abadie Lana
17:34 RE: select query does not pick up the right index Abadie Lana

4 January 2019

00:42 Re: select query does not pick up the right index David Rowley
02:47 Re: select query does not pick up the right index Justin Pryzby
11:10 RE: select query does not pick up the right index Abadie Lana
11:17 RE: select query does not pick up the right index Abadie Lana
11:58 RE: select query does not pick up the right index Abadie Lana

5 January 2019

07:23 Re: select query does not pick up the right index Justin Pryzby

7 January 2019

19:09 RE: select query does not pick up the right index Abadie Lana

8 January 2019

11:15 Re: select query does not pick up the right index Justin Pryzby

9 January 2019

11:35 postgresql unix socket connections Mariel Cherkassky
11:46 Re: postgresql unix socket connections Mariel Cherkassky
15:55 RE: select query does not pick up the right index Abadie Lana
17:55 Re: postgresql unix socket connections Tom Lane
18:08 Re: postgresql unix socket connections Mariel Cherkassky
18:09 Re: postgresql unix socket connections Jeff Janes
18:13 Re: postgresql unix socket connections Jeff Janes
18:17 Re: postgresql unix socket connections Mariel Cherkassky
19:11 Re: postgresql unix socket connections Tom Lane
19:41 Re: select query does not pick up the right index David Rowley
22:14 Re: PostgreSQL Read IOPS limit per connection Merlin Moncure
22:22 Re: select query does not pick up the right index Abadie Lana

10 January 2019

00:52 Re: PostgreSQL Read IOPS limit per connection Haroldo Kerry
01:47 Re: PostgreSQL Read IOPS limit per connection Merlin Moncure
05:49 Re: PostgreSQL Read IOPS limit per connection Mark Hogg
11:06 does dml operations load the blocks to the shared buffers ? Mariel Cherkassky
11:22 Re: postgresql unix socket connections Mariel Cherkassky
11:55 Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge
12:41 Re: postgresql unix socket connections Ken Tanzer
13:36 Re: postgresql unix socket connections Mariel Cherkassky
13:40 Re: does dml operations load the blocks to the shared buffers ? Mariel Cherkassky
15:56 Detect missing combined indexes (automatically) Thomas Güttler
21:42 Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge

12 January 2019

18:47 Re: Detect missing combined indexes (automatically) Jim Finnerty

14 January 2019

10:19 Re: Detect missing combined indexes (automatically) Thomas Kellerer
10:42 Re: Detect missing combined indexes (automatically) Julien Rouhaud

15 January 2019

12:23 Re: Detect missing combined indexes (automatically) Thomas Güttler
13:25 Re: Detect missing combined indexes (automatically) Julien Rouhaud

16 January 2019

10:06 No matching tables have ever been vacuumed Daulat Ram
14:31 Parallel stats in execution plans David Conlin

17 January 2019

12:49 Re: No matching tables have ever been vacuumed Laurenz Albe
20:28 autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky
20:46 Re: autovacuum doesnt run on the pg_toast_id table Justin Pryzby
20:52 Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera
20:58 Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky
22:09 Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera
22:59 Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky
23:16 Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera
23:18 Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky

18 January 2019

17:12 JIT overhead slowdown Luis Carril
19:42 Re: JIT overhead slowdown Andres Freund
21:02 Re: JIT overhead slowdown Luis Carril

22 January 2019

11:11 Re: Memory and hard ware calculation : Fabio Pardi
16:44 Very long query planning times for database with lots of partitions Mickael van der Beek
17:02 Re: Very long query planning times for database with lots ofpartitions Justin Pryzby
17:07 RE: Very long query planning times for database with lots ofpartitions Steven Winfield
18:24 Re: Very long query planning times for database with lots of partitions Mickael van der Beek
23:04 SELECT performance drop Jan Nielsen

23 January 2019

00:00 Re: SELECT performance drop Jan Nielsen
00:13 ANALYZE accuracy problems for n_distinct, and a solution Jim Finnerty
00:55 Re: SELECT performance drop legrand legrand
01:28 Re: SELECT performance drop Jan Nielsen
16:50 Re: SELECT performance drop Jim Finnerty
18:25 ERROR: found xmin from before relfrozenxid Mariel Cherkassky
20:28 Re: SELECT performance drop Jan Nielsen
22:16 Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
22:37 RE:SELECT performance drop legrand legrand
22:42 Re: ERROR: found xmin from before relfrozenxid Jerry Sievers

24 January 2019

01:41 Re: SELECT performance drop Laurenz Albe
09:32 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
11:18 Re: Parallel stats in execution plans David Conlin
14:55 Re: Parallel stats in execution plans David Rowley
17:14 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
17:44 RE: dsa_allocate() faliure Arne Roland
19:52 Re: SELECT performance drop Jan Nielsen
21:04 Re: SELECT performance drop Jan Nielsen

25 January 2019

08:20 Zero throughput on a query on a very large table. ldh@laurent-hasson.com
08:54 Re: Zero throughput on a query on a very large table. Andreas Kretschmer
09:24 Re: Zero throughput on a query on a very large table. Tom Lane
09:55 Re: Zero throughput on a query on a very large table. David Rowley
10:17 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
11:18 Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT
20:20 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
20:47 RE: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
21:00 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
21:10 Re: Zero throughput on a query on a very large table. Tom Lane
21:20 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
21:29 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
21:34 Re: Zero throughput on a query on a very large table. Tom Lane
21:36 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
22:06 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
22:24 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com
23:04 Re: Zero throughput on a query on a very large table. Tom Lane
23:31 Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

26 January 2019

13:48 Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT
13:56 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
13:59 Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT
14:10 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

27 January 2019

10:39 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
11:43 Q on SQL Performance tuning Bhupathi, Kaushik (CORP)
14:28 Re: Q on SQL Performance tuning legrand legrand
17:31 Re: Q on SQL Performance tuning Justin Pryzby
19:04 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Justin Pryzby
19:38 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
20:48 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes
22:41 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes

28 January 2019

07:52 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
07:59 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
08:03 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
13:04 upgrade from 9.6 to 10/11 Mariel Cherkassky
13:20 Re: upgrade from 9.6 to 10/11 Laurenz Albe
16:50 RE: dsa_allocate() faliure Arne Roland
17:03 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
17:22 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles
18:43 Re: upgrade from 9.6 to 10/11 Justin Pryzby
18:55 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
19:06 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles
19:35 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
19:56 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
21:56 Re: dsa_allocate() faliure Thomas Munro

29 January 2019

04:44 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
07:48 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
09:15 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda
12:14 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles
14:32 Re: dsa_allocate() faliure Fabio Isabettini
14:39 Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda
15:12 Re: Will higher shared_buffers improve tpcb-like benchmarks? Joe Mirabal
15:32 Interpreting shared_buffers setting Bob Jolliffe
15:35 Re: Interpreting shared_buffers setting Thomas Markus
16:07 Re: Interpreting shared_buffers setting Andrew Gierth
18:42 Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes
18:42 Re: Interpreting shared_buffers setting Bob Jolliffe
21:00 Re: Will higher shared_buffers improve tpcb-like benchmarks? Jeff Janes
21:10 Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda
21:29 How can sort performance be so different Bob Jolliffe
21:31 Re: Interpreting shared_buffers setting Jerry Sievers
21:33 Re: How can sort performance be so different Pavel Stehule
21:36 Re: How can sort performance be so different Saurabh Nanda
21:40 Re: Interpreting shared_buffers setting Jerry Sievers
21:47 Re: How can sort performance be so different Tom Lane

30 January 2019

06:13 Re: dsa_allocate() faliure Thomas Munro
06:50 Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda
10:51 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
12:13 Re: ERROR: found xmin from before relfrozenxid Alvaro Herrera
12:53 Re: dsa_allocate() faliure Fabio Isabettini
13:35 Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky
14:57 Re: How can sort performance be so different Bob Jolliffe

31 January 2019

02:54 Re: How can sort performance be so different Peter Geoghegan
10:30 Setting effective_cache size Nandakumar M
10:34 Re: Setting effective_cache size Nandakumar M
14:57 Re: Setting effective_cache size Laurenz Albe
16:29 Re: How can sort performance be so different Bob Jolliffe
21:19 RE: dsa_allocate() faliure Arne Roland