Re: 7 hrs for a pg_restore?
От
Douglas J Hunley
Тема
Re: 7 hrs for a pg_restore?
Дата
Msg-id
200802191520.33528.doug@hunley.homeip.net
Ответ на
Re: 7 hrs for a pg_restore? (Dave Cramer)
Список
Дерево обсуждения
7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Jeff Davis <pgsql@j-davis.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Jeff Davis <pgsql@j-davis.com>
Re: 7 hrs for a pg_restore? "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: 7 hrs for a pg_restore? Jeff Davis <pgsql@j-davis.com>
Re: 7 hrs for a pg_restore? Matthew <matthew@flymine.org>
Re: 7 hrs for a pg_restore? Jeff Davis <pgsql@j-davis.com>
Re: 7 hrs for a pg_restore? Tom Lane <tgl@sss.pgh.pa.us>
Re: 7 hrs for a pg_restore? Matthew <matthew@flymine.org>
Re: 7 hrs for a pg_restore? ohp@pyrenet.fr
Re: 7 hrs for a pg_restore? "Joshua D. Drake" <jd@commandprompt.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Dave Cramer <pg@fastcrypt.com>
Re: 7 hrs for a pg_restore? Jeff Davis <pgsql@j-davis.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Dave Cramer <pg@fastcrypt.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Greg Smith <gsmith@gregsmith.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Dave Cramer <pg@fastcrypt.com>
Re: 7 hrs for a pg_restore? Richard Huxton <dev@archonet.com>
Re: 7 hrs for a pg_restore? Tom Lane <tgl@sss.pgh.pa.us>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Jeff <threshar@torgo.978.org>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Erik Jones <erik@myemma.com>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
Re: 7 hrs for a pg_restore? Gregory Stark <stark@enterprisedb.com>
Re: 7 hrs for a pg_restore? Erik Jones <erik@myemma.com>
Re: 7 hrs for a pg_restore? Tom Lane <tgl@sss.pgh.pa.us>
Re: 7 hrs for a pg_restore? Erik Jones <erik@myemma.com>
Re: 7 hrs for a pg_restore? Gregory Stark <stark@enterprisedb.com>
Re: 7 hrs for a pg_restore? Chris <dmagick@gmail.com>
Re: 7 hrs for a pg_restore? Gregory Stark <stark@enterprisedb.com>
Re: 7 hrs for a pg_restore? Chris <dmagick@gmail.com>
Re: 7 hrs for a pg_restore? Matthew <matthew@flymine.org>
Re: 7 hrs for a pg_restore? Guillaume Cottenceau <gc@mnc.ch>
Re: 7 hrs for a pg_restore? Tom Lane <tgl@sss.pgh.pa.us>
Re: 7 hrs for a pg_restore? Guillaume Cottenceau <gc@mnc.ch>
Re: 7 hrs for a pg_restore? Vivek Khera <vivek@khera.org>
Re: 7 hrs for a pg_restore? Douglas J Hunley <doug@hunley.homeip.net>
On Tuesday 19 February 2008 15:16:42 Dave Cramer wrote: > On 19-Feb-08, at 2:35 PM, Douglas J Hunley wrote: > > On Tuesday 19 February 2008 14:28:54 Dave Cramer wrote: > >> shared buffers is *way* too small as is effective cache > >> set them to 2G/6G respectively. > >> > >> Dave > > > > pardon my ignorance, but is this in the context of a restore only? > > or 'in > > general'? > > This is the "generally accepted" starting point for a pg db for > production. fair enough. I have scheduled this change for the next outage -- Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778 http://doug.hunley.homeip.net "The internet has had no impact on my life whatsoever.com" - anon
В списке pgsql-performance по дате отправления
