From: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | sysout error log being truncated |
Date: | 2019-03-08 22:22:16 |
Message-ID: | CADyzmyyftHOPk_Tc0MpdYqGKCZ2KeVaqv3rRci5NRYH-+7CTWA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Good afternoon/evening
We run postgres 9.4. We are moving to a new datacenter and are doing the
requisite parallel performance testing.
One of our transactions is a queue processor that generates a ton of insert
statements per run of this transaction - as many as 1000 per run.
What has happened in new datacenter is that these transactions - while
running correctly and completely - do not write all the insert statements
to our sysout log - only some. Here are some of the postgres
configurations for your reference:
syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
# This is only relevant when logging to eventlog (win32):
#event_source = 'PostgreSQL'
# - When to Log -
#client_min_messages = notice
log_min_messages = info
log_min_error_statement = info
log_min_duration_statement = 4000
# - What to Log -
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
#log_duration = off
#log_error_verbosity = default
#log_hostname = off
log_line_prefix = '%u(at)%h:%d '
#log_lock_waits = off
log_statement = 'ddl'
#log_temp_files = -1
log_timezone = 'US/Eastern'
The only other difference I can report is the minor version
CURRENT PRODUCTION: 9.4.8
NEW DATACENTER: 9.4.21
Any insights welcome - thank you,
--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-03-08 23:09:37 | Re: sysout error log being truncated |
Previous Message | Peter | 2019-03-08 21:14:37 | Re: Upgrade 10.5->10.6 : db crash BUS ERROR (sig 10), reproducible |