From: Shaun Thomas <sthomas@optionshouse.com>
To: AJ Weber <aweber@comcast.net>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: how to improve perf of 131MM row table?
Date: Wed, 25 Jun 2014 15:49:16 -0500
Message-ID: <53AB35CC.10202@optionshouse.com> (raw)
In-Reply-To: <53AB2CB1.8080201@comcast.net>
References: <53AB2CB1.8080201@comcast.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 06/25/2014 03:10 PM, AJ Weber wrote:
> I have a relatively sizable postgresql 9.0.2 DB with a few large tables
> (keep in mind "large" is relative, I'm sure there are plenty larger out
> there).
Regardless of any help we might offer regarding this, you need to
upgrade your installation to 9.0.17. You are behind by several
performance, security, and integrity bugfixes, some of which address
critical corruption bugs related to replication.
> One of my queries that seems to be bogging-down performance is a join
> between two tables on each of their BIGINT PK's (so they have default
> unique constraint/PK indexes on them). One table is a detail table for
> the other.
This isn't enough information. Just knowing the relative sizes of the
tables doesn't tell us which columns are indexed, whether or not the
query is using those indexes, how many rows usually match, which queries
are performing badly, and so on.
Please refer to this page to ask performance related questions:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Without much of this information, we'd only be speculating.
--
Shaun Thomas
OptionsHouse, LLC | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sthomas@optionshouse.com, aweber@comcast.net
Subject: Re: how to improve perf of 131MM row table?
In-Reply-To: <53AB35CC.10202@optionshouse.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox