Re: [PERFORM] Very poor read performance, query independent

От

Igor Neyman

Тема

Дата

12 июля 2017 г. в 16:57:06

Msg-id

DM5PR07MB281020250424625EAAFDD77ADAAF0@DM5PR07MB2810.namprd07.prod.outlook.com

обсуждение

Ответ на

Re: [PERFORM] Very poor read performance, query independent (Charles Nadeau)

Список

pgsql-performance

Дерево обсуждения

[PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 10 июля 2017 г. в 17:03:36

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 25 июля 2017 г. в 12:36:25

Re: [PERFORM] Very poor read performance, query independent Merlin Moncure <mmoncure@gmail.com> 12 июля 2017 г. в 02:15:28

Re: [PERFORM] Very poor read performance, query independent "Joshua D. Drake" <jd@commandprompt.com> 12 июля 2017 г. в 02:42:08

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 12 июля 2017 г. в 10:30:16

Re: [PERFORM] Very poor read performance, query independent bricklen <bricklen@gmail.com> 12 июля 2017 г. в 17:11:54

Re: [PERFORM] Very poor read performance, query independent Jeff Janes <jeff.janes@gmail.com> 12 июля 2017 г. в 04:03:12

Re: [PERFORM] Very poor read performance, query independent Rick Otten <rottenwindfish@gmail.com> 10 июля 2017 г. в 18:25:45

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 12 июля 2017 г. в 16:38:23

Re: [PERFORM] Very poor read performance, query independent Rick Otten <rottenwindfish@gmail.com> 12 июля 2017 г. в 17:10:27

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 11 июля 2017 г. в 13:39:19

Re: [PERFORM] Very poor read performance, query independent Jeff Janes <jeff.janes@gmail.com> 10 июля 2017 г. в 22:24:04

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 11 июля 2017 г. в 14:02:05

Re: [PERFORM] Very poor read performance, query independent Jeff Janes <jeff.janes@gmail.com> 12 июля 2017 г. в 03:39:54

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 12 июля 2017 г. в 13:04:49

Re: [PERFORM] Very poor read performance, query independent Jeff Janes <jeff.janes@gmail.com> 13 июля 2017 г. в 01:27:27

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 12 июля 2017 г. в 17:31:57

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 12 июля 2017 г. в 19:39:08

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 14 июля 2017 г. в 18:34:43

Re: [PERFORM] Very poor read performance, query independent Claudio Freire <klaussfreire@gmail.com> 17 июля 2017 г. в 23:56:23

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 18 июля 2017 г. в 12:20:35

Re: [PERFORM] Very poor read performance, query independent Claudio Freire <klaussfreire@gmail.com> 18 июля 2017 г. в 19:01:29

Re: [PERFORM] Very poor read performance, query independent Claudio Freire <klaussfreire@gmail.com> 18 июля 2017 г. в 20:13:58

Re: [PERFORM] Very poor read performance, query independent Justin Pryzby <pryzby@telsasoft.com> 18 июля 2017 г. в 21:01:52

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 19 июля 2017 г. в 14:48:54

Re: [PERFORM] Very poor read performance, query independent Scott Marlowe <scott.marlowe@gmail.com> 19 июля 2017 г. в 04:08:14

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 14 июля 2017 г. в 22:13:28

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 16 июля 2017 г. в 12:20:57

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 14 июля 2017 г. в 23:18:37

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 17 июля 2017 г. в 14:22:47

Re: [PERFORM] Very poor read performance, query independent Andreas Kretschmer <andreas@a-kretschmer.de> 10 июля 2017 г. в 18:35:56

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 10 июля 2017 г. в 18:48:25

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 10 июля 2017 г. в 21:35:16

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 11 июля 2017 г. в 13:42:35

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 11 июля 2017 г. в 17:34:05

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 11 июля 2017 г. в 18:25:14

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 11 июля 2017 г. в 18:46:30

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 11 июля 2017 г. в 18:16:52

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 12 июля 2017 г. в 10:21:09

Re: [PERFORM] Very poor read performance, query independent Igor Neyman <ineyman@perceptron.com> 12 июля 2017 г. в 16:57:06

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 11 июля 2017 г. в 15:46:03

Re: [PERFORM] Very poor read performance, query independent Mark Kirkwood <mark.kirkwood@catalyst.net.nz> 12 июля 2017 г. в 05:11:53

Re: [PERFORM] Very poor read performance, query independent Charles Nadeau <charles.nadeau@gmail.com> 14 июля 2017 г. в 17:34:24

From: Charles Nadeau [mailto:charles.nadeau@gmail.com]
Sent: Wednesday, July 12, 2017 3:21 AM
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Very poor read performance, query independent

Igor,

I set shared_buffers to 24 GB and effective_cache_size to 64GB and I can see that the queries are faster due to the fact that the index are used more often. Knowing I have 72GB of RAM and the server is exclusively dedicated to Postgresql, what could be the maximum value for effective_cache?

Thanks!

Charles

64GB for effective_cache_size should be good enough, adding couple more GB wouldn’t change much.

Igor

В списке pgsql-performance по дате отправления

Предыдущее

От: Charles Nadeau

Дата: 12 июля 2017 г. в 16:38:23

Сообщение: Re: [PERFORM] Very poor read performance, query independent

Следующее

От: Rick Otten

Дата: 12 июля 2017 г. в 17:10:27

Сообщение: Re: [PERFORM] Very poor read performance, query independent