Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc:	Bruce Momjian <bruce(at)momjian(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Claudio Freire <klaussfreire(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date:	2014-05-06 14:18:39
Message-ID:	17469.1399385919@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2013-01-08 14:39:09 from Merlin Moncure <mmoncure(at)gmail(dot)com>  2013-01-08 14:53:29 from Claudio Freire <klaussfreire(at)gmail(dot)com>   2013-01-08 22:23:36 from Robert Haas <robertmhaas(at)gmail(dot)com>    2013-01-08 22:48:55 from Bruce Momjian <bruce(at)momjian(dot)us>    2013-01-09 00:17:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2013-01-09 00:54:38 from Robert Haas <robertmhaas(at)gmail(dot)com>      2013-01-09 01:08:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2013-01-09 01:40:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>        2013-01-09 02:01:55 from Josh Berkus <josh(at)agliodbs(dot)com>         2013-01-09 08:38:25 from Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>          2013-01-10 18:44:59 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>        2013-09-05 01:01:54 from Bruce Momjian <bruce(at)momjian(dot)us> 📎         2013-09-05 16:14:33 from Magnus Hagander <magnus(at)hagander(dot)net>          2013-09-05 16:48:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2013-09-05 21:16:22 from Bruce Momjian <bruce(at)momjian(dot)us>            2013-09-05 22:11:53 from Josh Berkus <josh(at)agliodbs(dot)com>             2013-09-05 22:30:21 from Merlin Moncure <mmoncure(at)gmail(dot)com>              2013-09-06 04:02:27 from Josh Berkus <josh(at)agliodbs(dot)com>               2013-09-10 01:29:07 from Bruce Momjian <bruce(at)momjian(dot)us>                2013-09-10 16:39:21 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                 2013-09-10 16:53:37 from Merlin Moncure <mmoncure(at)gmail(dot)com>                  2013-09-10 22:08:24 from Josh Berkus <josh(at)agliodbs(dot)com>                   2013-09-10 22:21:48 from Merlin Moncure <mmoncure(at)gmail(dot)com>                   2013-09-11 13:18:30 from Bruce Momjian <bruce(at)momjian(dot)us>                    2013-09-11 15:27:42 from Bruce Momjian <bruce(at)momjian(dot)us>                     2013-09-11 15:43:07 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2013-09-11 16:53:29 from Bruce Momjian <bruce(at)momjian(dot)us>                       2013-09-11 17:55:21 from Andres Freund <andres(at)2ndquadrant(dot)com>                        2013-09-11 19:40:45 from Josh Berkus <josh(at)agliodbs(dot)com>                         2013-09-13 15:08:08 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2013-09-13 15:50:06 from Merlin Moncure <mmoncure(at)gmail(dot)com>                           2013-09-13 16:07:56 from Andres Freund <andres(at)2ndquadrant(dot)com>                            2013-09-13 16:27:03 from Merlin Moncure <mmoncure(at)gmail(dot)com>                             2013-09-13 16:34:54 from Andres Freund <andres(at)2ndquadrant(dot)com>                              2013-09-13 21:04:55 from Kevin Grittner <kgrittn(at)ymail(dot)com>                               2013-09-13 21:10:04 from Merlin Moncure <mmoncure(at)gmail(dot)com>                               2013-09-13 21:57:30 from Andres Freund <andres(at)2ndquadrant(dot)com>                             2013-09-13 19:36:58 from Josh Berkus <josh(at)agliodbs(dot)com>                              2013-09-13 19:55:16 from Merlin Moncure <mmoncure(at)gmail(dot)com>                               2013-09-13 20:20:52 from Josh Berkus <josh(at)agliodbs(dot)com>                                2013-09-13 20:25:39 from Andres Freund <andres(at)2ndquadrant(dot)com>                                 2013-09-13 20:26:47 from Josh Berkus <josh(at)agliodbs(dot)com>                                2013-09-13 20:58:54 from Merlin Moncure <mmoncure(at)gmail(dot)com>                                 2013-09-13 21:15:53 from Josh Berkus <josh(at)agliodbs(dot)com>                                  2013-09-13 21:20:54 from Merlin Moncure <mmoncure(at)gmail(dot)com>                     2013-09-11 17:41:48 from Josh Berkus <josh(at)agliodbs(dot)com>                     2013-09-11 18:08:25 from Claudio Freire <klaussfreire(at)gmail(dot)com>             2013-09-05 22:36:08 from Bruce Momjian <bruce(at)momjian(dot)us>          2013-09-05 21:14:37 from Bruce Momjian <bruce(at)momjian(dot)us>           2013-09-06 07:45:06 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>           2013-10-08 16:13:54 from Bruce Momjian <bruce(at)momjian(dot)us>            2013-10-08 19:04:18 from Kevin Hale Boyes <kcboyes(at)gmail(dot)com>             2013-10-08 23:02:45 from Bruce Momjian <bruce(at)momjian(dot)us>            2014-05-06 14:09:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>             2014-05-06 14:17:06 from Andres Freund <andres(at)2ndquadrant(dot)com>              2014-05-06 16:43:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>               2014-05-06 16:55:05 from Andres Freund <andres(at)2ndquadrant(dot)com>                2014-05-07 07:18:12 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2014-05-07 12:31:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2014-05-07 13:50:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                  2014-05-07 14:24:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2014-05-07 14:07:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2014-05-07 14:10:29 from Merlin Moncure <mmoncure(at)gmail(dot)com>                   2014-05-07 14:49:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                  2014-05-07 14:12:26 from Andres Freund <andres(at)2ndQuadrant(dot)com>                   2014-05-07 14:18:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2014-05-07 14:20:08 from Magnus Hagander <magnus(at)hagander(dot)net>                   2014-05-07 14:31:07 from Andrew Dunstan <andrew(at)dunslane(dot)net>                    2014-05-07 17:31:17 from Josh Berkus <josh(at)agliodbs(dot)com>                  2014-05-07 14:40:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                2014-05-07 18:20:34 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>             2014-05-06 14:18:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2014-05-06 15:41:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>               2014-05-06 16:50:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2014-05-06 17:08:01 from Josh Berkus <josh(at)agliodbs(dot)com>                2014-05-06 20:38:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2014-05-06 21:54:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2014-05-06 22:07:57 from Andrew Dunstan <andrew(at)dunslane(dot)net>                  2014-05-06 22:15:17 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                   2014-05-15 12:06:04 from Bruce Momjian <bruce(at)momjian(dot)us>                    2014-05-15 13:23:19 from Amit Langote <amitlangote09(at)gmail(dot)com>                     2014-05-15 14:24:25 from Bruce Momjian <bruce(at)momjian(dot)us>                      2014-05-15 14:36:51 from Amit Langote <amitlangote09(at)gmail(dot)com>                       2014-05-15 16:35:59 from Bruce Momjian <bruce(at)momjian(dot)us>                    2014-05-15 18:58:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2014-05-06 22:28:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2014-05-06 23:01:00 from Josh Berkus <josh(at)agliodbs(dot)com>                   2014-05-07 05:23:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                 2014-05-06 22:47:41 from Josh Berkus <josh(at)agliodbs(dot)com>                  2014-05-07 05:20:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                   2014-05-07 05:35:50 from Peter Geoghegan <pg(at)heroku(dot)com>                    2014-05-07 05:55:40 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>                    2014-05-07 18:04:48 from Josh Berkus <josh(at)agliodbs(dot)com>                     2014-05-07 18:13:14 from Peter Geoghegan <pg(at)heroku(dot)com>                      2014-05-07 18:32:41 from Merlin Moncure <mmoncure(at)gmail(dot)com>                       2014-05-07 18:38:32 from Andres Freund <andres(at)2ndquadrant(dot)com>                        2014-05-07 18:45:04 from Peter Geoghegan <pg(at)heroku(dot)com>                         2014-05-07 18:49:58 from Andres Freund <andres(at)2ndquadrant(dot)com>                          2014-05-07 18:50:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2014-05-07 19:18:55 from Peter Geoghegan <pg(at)heroku(dot)com>                        2014-05-07 20:51:57 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                         2014-05-07 21:15:19 from Andres Freund <andres(at)2ndquadrant(dot)com>                          2014-05-07 21:24:53 from Merlin Moncure <mmoncure(at)gmail(dot)com>                           2014-05-07 21:30:45 from Peter Geoghegan <pg(at)heroku(dot)com>                           2014-05-07 21:51:24 from Andres Freund <andres(at)2ndquadrant(dot)com>                      2014-05-07 18:40:59 from Josh Berkus <josh(at)agliodbs(dot)com>                       2014-05-07 18:50:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2014-05-07 18:58:02 from Peter Geoghegan <pg(at)heroku(dot)com>                         2014-05-07 19:35:56 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2014-05-07 18:52:30 from Peter Geoghegan <pg(at)heroku(dot)com>                        2014-05-07 19:06:24 from Josh Berkus <josh(at)agliodbs(dot)com>                         2014-05-08 00:25:23 from Peter Geoghegan <pg(at)heroku(dot)com>                     2014-05-07 20:36:43 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                      2014-05-07 20:48:18 from Josh Berkus <josh(at)agliodbs(dot)com>              2014-05-06 19:41:29 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>               2014-05-06 20:47:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com>       2013-01-09 17:51:12 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>        2013-01-09 18:39:11 from Josh Berkus <josh(at)agliodbs(dot)com>         2013-01-09 18:47:46 from Claudio Freire <klaussfreire(at)gmail(dot)com>          2013-01-09 18:58:21 from Josh Berkus <josh(at)agliodbs(dot)com>
Lists:	pgsql-hackers

In response to

• Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers at 2014-05-06 14:09:15 from Simon Riggs

Responses

• Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers at 2014-05-06 15:41:31 from Simon Riggs
• Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers at 2014-05-06 19:41:29 from Jeff Janes

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Simon Riggs	2014-05-06 14:40:18	Re: sb_alloc: a new memory allocator for PostgreSQL
Previous Message	Tom Lane	2014-05-06 14:17:39	Re: New pg_lsn type doesn't have hash/btree opclasses