Re: 8.3.3 win32 crashing
От | Klint Gore |
---|---|
Тема | Re: 8.3.3 win32 crashing |
Дата | |
Msg-id | 48AB7EB4.6030005@une.edu.au обсуждение исходный текст |
Ответ на | Re: 8.3.3 win32 crashing (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Tom Lane wrote: > Klint Gore <kgore4@une.edu.au> writes: > >>> [ heavy RAISE NOTICE traffic crashes the server ] > > > > client=warning, log=warning completes > > client=warning, log=notice fails > > client=notice, log=warning completes > > client=notice, log=notice fails > > It fails a heck of a lot quicker with client=warning, log=notice. > > Okay, so the problem is definitely on the postmaster-log side. > Please show us all of your logging-related configuration settings. > I can duplicate it on my notebook with a slightly smaller set of data (pentium M, 2ghz, 1g mem, 5400rpm pata drive 23gig free). Both server and notebook were installed off the same installer. All settings not commented. The log_min_messages is only there from the test runs. It's normally the default. port = 5432 # (change requires restart) max_connections = 100 # (change requires restart) shared_buffers = 32MB # min 128kB or max_connections*16kB max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each log_destination = 'stderr' # Valid values are combinations of logging_collector = on # Enable capturing of stderr and csvlog log_min_messages = warning log_line_prefix = '%t ' # special values: datestyle = 'iso, mdy' lc_messages = 'C' # locale for system error message lc_monetary = 'C' # locale for monetary formatting lc_numeric = 'C' # locale for number formatting lc_time = 'C' # locale for time formatting default_text_search_config = 'pg_catalog.english' The notebook as visual studio 2005 professional if that helps but it's not setup to build postgres. klint. -- Klint Gore Database Manager Sheep CRC A.G.B.U. University of New England Armidale NSW 2350 Ph: 02 6773 3789 Fax: 02 6773 3266 EMail: kgore4@une.edu.au
В списке pgsql-general по дате отправления: