sysout error log being truncated

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/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  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