Продукты

О компании

Ресурсы

Мероприятия

Образование

...

Протестировать

Архив рассылок [pgsql-performance]

Декабрь 2018Февраль

2 3 4 5 7 8 9 10 12 14 15 16 17 18 22 23 24 25 26 27 28 29 30 31

2 января 2019 г.

16:28select query does not pick up the right index Abadie Lana

16:45Re: select query does not pick up the right index Justin Pryzby

3 января 2019 г.

00:15Re: select query does not pick up the right index David Rowley

12:57RE: select query does not pick up the right index Abadie Lana

12:58RE: select query does not pick up the right index Abadie Lana

13:01Re: select query does not pick up the right index David Rowley

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

13:17Re: select query does not pick up the right index David Rowley

13:20RE: select query does not pick up the right index Abadie Lana

14:34RE: select query does not pick up the right index Abadie Lana

21:42Re: select query does not pick up the right index David Rowley

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

4 января 2019 г.

08:10RE: select query does not pick up the right index Abadie Lana

08:17RE: select query does not pick up the right index Abadie Lana

08:58RE: select query does not pick up the right index Abadie Lana

5 января 2019 г.

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

7 января 2019 г.

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

8 января 2019 г.

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

9 января 2019 г.

08:35postgresql unix socket connections Mariel Cherkassky

08:46Re: postgresql unix socket connections Mariel Cherkassky

12:55RE: select query does not pick up the right index Abadie Lana

14:55Re: postgresql unix socket connections Tom Lane

15:08Re: postgresql unix socket connections Mariel Cherkassky

15:09Re: postgresql unix socket connections Jeff Janes

15:13Re: postgresql unix socket connections Jeff Janes

15:17Re: postgresql unix socket connections Mariel Cherkassky

16:11Re: postgresql unix socket connections Tom Lane

16:41Re: select query does not pick up the right index David Rowley

19:14Re: PostgreSQL Read IOPS limit per connection Merlin Moncure

19:22Re: select query does not pick up the right index Abadie Lana

21:52Re: PostgreSQL Read IOPS limit per connection Haroldo Kerry

22:47Re: PostgreSQL Read IOPS limit per connection Merlin Moncure

10 января 2019 г.

02:49Re: PostgreSQL Read IOPS limit per connection Mark Hogg

08:06does dml operations load the blocks to the shared buffers ? Mariel Cherkassky

08:22Re: postgresql unix socket connections Mariel Cherkassky

08:55Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge

09:41Re: postgresql unix socket connections Ken Tanzer

10:36Re: postgresql unix socket connections Mariel Cherkassky

10:40Re: does dml operations load the blocks to the shared buffers ? Mariel Cherkassky

12:56Detect missing combined indexes (automatically) Thomas Güttler

18:42Re: does dml operations load the blocks to the shared buffers ? Guillaume Lelarge

12 января 2019 г.

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

14 января 2019 г.

07:19Re: Detect missing combined indexes (automatically) Thomas Kellerer

07:42Re: Detect missing combined indexes (automatically) Julien Rouhaud

15 января 2019 г.

09:23Re: Detect missing combined indexes (automatically) Thomas Güttler

10:25Re: Detect missing combined indexes (automatically) Julien Rouhaud

16 января 2019 г.

07:06No matching tables have ever been vacuumed Daulat Ram

11:31Parallel stats in execution plans David Conlin

17 января 2019 г.

09:49Re: No matching tables have ever been vacuumed Laurenz Albe

17:28autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky

17:46Re: autovacuum doesnt run on the pg_toast_id table Justin Pryzby

17:52Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera

17:58Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky

19:09Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera

19:59Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky

20:16Re: autovacuum doesnt run on the pg_toast_id table Alvaro Herrera

20:18Re: autovacuum doesnt run on the pg_toast_id table Mariel Cherkassky

18 января 2019 г.

14:12JIT overhead slowdown Luis Carril

16:42Re: JIT overhead slowdown Andres Freund

18:02Re: JIT overhead slowdown Luis Carril

22 января 2019 г.

08:11Re: Memory and hard ware calculation : Fabio Pardi

13:44Very long query planning times for database with lots of partitions Mickael van der Beek

14:02Re: Very long query planning times for database with lots ofpartitions Justin Pryzby

14:07RE: Very long query planning times for database with lots ofpartitions Steven Winfield

15:24Re: Very long query planning times for database with lots of partitions Mickael van der Beek

20:04SELECT performance drop Jan Nielsen

21:00Re: SELECT performance drop Jan Nielsen

21:13ANALYZE accuracy problems for n_distinct, and a solution Jim Finnerty

21:55Re: SELECT performance drop legrand legrand

22:28Re: SELECT performance drop Jan Nielsen

23 января 2019 г.

13:50Re: SELECT performance drop Jim Finnerty

15:25ERROR: found xmin from before relfrozenxid Mariel Cherkassky

17:28Re: SELECT performance drop Jan Nielsen

19:16Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

19:37RE:SELECT performance drop legrand legrand

19:42Re: ERROR: found xmin from before relfrozenxid Jerry Sievers

22:41Re: SELECT performance drop Laurenz Albe

24 января 2019 г.

06:32Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

08:18Re: Parallel stats in execution plans David Conlin

11:55Re: Parallel stats in execution plans David Rowley

14:14Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

14:44RE: dsa_allocate() faliure Arne Roland

16:52Re: SELECT performance drop Jan Nielsen

18:04Re: SELECT performance drop Jan Nielsen

25 января 2019 г.

05:20Zero throughput on a query on a very large table. ldh@laurent-hasson.com

05:54Re: Zero throughput on a query on a very large table. Andreas Kretschmer

06:24Re: Zero throughput on a query on a very large table. Tom Lane

06:55Re: Zero throughput on a query on a very large table. David Rowley

07:17Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

08:18Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT

17:20Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

17:47RE: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

18:00Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

18:10Re: Zero throughput on a query on a very large table. Tom Lane

18:20Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

18:29Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

18:34Re: Zero throughput on a query on a very large table. Tom Lane

18:36Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

19:06Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

19:24Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

20:04Re: Zero throughput on a query on a very large table. Tom Lane

20:31Re: Zero throughput on a query on a very large table. ldh@laurent-hasson.com

26 января 2019 г.

10:48Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT

10:56Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

10:59Re: ERROR: found xmin from before relfrozenxid Adrien NAYRAT

11:10Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

27 января 2019 г.

07:39Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

08:43Q on SQL Performance tuning Bhupathi, Kaushik (CORP)

11:28Re: Q on SQL Performance tuning legrand legrand

14:31Re: Q on SQL Performance tuning Justin Pryzby

16:04Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Justin Pryzby

16:38Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

17:48Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes

19:41Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes

28 января 2019 г.

04:52Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

04:59Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

05:03Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

10:04upgrade from 9.6 to 10/11 Mariel Cherkassky

10:20Re: upgrade from 9.6 to 10/11 Laurenz Albe

13:50RE: dsa_allocate() faliure Arne Roland

14:03Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

14:22Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles

15:43Re: upgrade from 9.6 to 10/11 Justin Pryzby

15:55Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

16:06Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles

16:35Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

16:56Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

18:56Re: dsa_allocate() faliure Thomas Munro

29 января 2019 г.

01:44Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

04:48Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

06:15Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Saurabh Nanda

09:14Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Nicolas Charles

11:32Re: dsa_allocate() faliure Fabio Isabettini

11:39Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda

12:12Re: Will higher shared_buffers improve tpcb-like benchmarks? Joe Mirabal

12:32Interpreting shared_buffers setting Bob Jolliffe

12:35Re: Interpreting shared_buffers setting Thomas Markus

13:07Re: Interpreting shared_buffers setting Andrew Gierth

15:42Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? Jeff Janes

15:42Re: Interpreting shared_buffers setting Bob Jolliffe

18:00Re: Will higher shared_buffers improve tpcb-like benchmarks? Jeff Janes

18:10Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda

18:29How can sort performance be so different Bob Jolliffe

18:31Re: Interpreting shared_buffers setting Jerry Sievers

18:33Re: How can sort performance be so different Pavel Stehule

18:36Re: How can sort performance be so different Saurabh Nanda

18:40Re: Interpreting shared_buffers setting Jerry Sievers

18:47Re: How can sort performance be so different Tom Lane

30 января 2019 г.

03:13Re: dsa_allocate() faliure Thomas Munro

03:50Re: Will higher shared_buffers improve tpcb-like benchmarks? Saurabh Nanda

07:51Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

09:13Re: ERROR: found xmin from before relfrozenxid Alvaro Herrera

09:53Re: dsa_allocate() faliure Fabio Isabettini

10:35Re: ERROR: found xmin from before relfrozenxid Mariel Cherkassky

11:57Re: How can sort performance be so different Bob Jolliffe

23:54Re: How can sort performance be so different Peter Geoghegan

31 января 2019 г.

07:30Setting effective_cache size Nandakumar M

07:34Re: Setting effective_cache size Nandakumar M

11:57Re: Setting effective_cache size Laurenz Albe

13:29Re: How can sort performance be so different Bob Jolliffe

18:19RE: dsa_allocate() faliure Arne Roland

Ответы на вопросы