From: Markus Schulz <msc@antzsystem.de>
Organization: AntzSystem GmbH
To: pgsql-performance@postgresql.org
Subject: Re: problem with from_collapse_limit and joined views
Date: Sat, 4 Dec 2010 11:24:02 +0100
User-Agent: KMail/1.13.5 (Linux/2.6.36-trunk-686-bigmem; KDE/4.4.5; i686; ; )
Cc: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
References: <201011241937.08622@Mail-Followup-To>
	<4CF8FF800200002500038262@gw.wicourts.gov>
In-Reply-To: <4CF8FF800200002500038262@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: Multipart/Mixed;
  boundary="Boundary-00=_Dbh+M8dfwvQUFz4"
Message-Id: <201012041124.03154.msc@antzsystem.de>

--Boundary-00=_Dbh+M8dfwvQUFz4
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Am Freitag, 3. Dezember 2010 schrieb Kevin Grittner:
> Markus Schulz <msc@antzsystem.de> wrote:
> > i have a big performance problem
> > 
> > [joining two complex views for reporting]
> 
> What version of PostgreSQL is this?  How is PostgreSQL configured?
> (The postgresql.conf file with all comments removed is good.)

Production System is 8.4 (config attached).
But i've tried 9.0 with same result.

Regards 
msc

--Boundary-00=_Dbh+M8dfwvQUFz4
Content-Type: text/plain;
  charset="UTF-8";
  name="postgresql.conf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="postgresql.conf"

data_directory = '/var/lib/postgresql/8.4/main'		# use data in another directory
hba_file = '/etc/postgresql/8.4/main/pg_hba.conf'	# host-based authentication file
ident_file = '/etc/postgresql/8.4/main/pg_ident.conf'	# ident configuration file
external_pid_file = '/var/run/postgresql/8.4-main.pid'		# write an extra PID file
listen_addresses = '*'		# what IP address(es) to listen on;
port = 5432				# (change requires restart)
max_connections = 3100			# (change requires restart)
unix_socket_directory = '/var/run/postgresql'		# (change requires restart)
ssl = true				# (change requires restart)
shared_buffers = 1500MB			# min 128kB
max_prepared_transactions = 20		# zero disables the feature
work_mem = 16MB				# min 64kB
checkpoint_segments = 8		# in logfile segments, min 1, 16MB each
random_page_cost = 3.0			# same scale as above
effective_cache_size = 20GB
from_collapse_limit = 8
join_collapse_limit = 8		# 1 disables collapsing of explicit 
log_destination = 'stderr'		# Valid values are combinations of
logging_collector = on		# Enable capturing of stderr and csvlog
log_directory = '/var/log/pgsql'		# directory where log files are written,
log_filename = 'postgresql-%Y-%m-%d_%H.log'	# log file name pattern,
log_rotation_age = 120			# Automatic rotation of logfiles will
log_duration = on
log_line_prefix = '%t [%d] [%x][%p]: [%l-1] '			# special values:
log_statement = 'none'			# none, ddl, mod, all
track_functions = all			# none, pl, all
track_activity_query_size = 16384
log_statement_stats = off
autovacuum_max_workers = 10		# max number of autovacuum subprocesses
datestyle = 'iso, dmy'
lc_messages = 'C'			# locale for system error message
lc_monetary = 'de_DE.utf8'			# locale for monetary formatting
lc_numeric = 'de_DE.utf8'			# locale for number formatting
lc_time = 'de_DE.utf8'				# locale for time formatting
default_text_search_config = 'pg_catalog.german'

--Boundary-00=_Dbh+M8dfwvQUFz4--