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