From: David Johnston <polobo@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: 57 minute SELECT
Date: Wed, 2 Oct 2013 18:17:14 -0700 (PDT)
Message-ID: <1380763034169-5773174.post@n5.nabble.com> (raw)
In-Reply-To: <CB03CD8D2C3F9347BAFEC8EA9DD89C9318D3785F@ISP-OSB-DAG2.win2k.iinet.net.au>
References: <CB03CD8D2C3F9347BAFEC8EA9DD89C9318D3785F@ISP-OSB-DAG2.win2k.iinet.net.au>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Samuel Stearns-2 wrote
> Total RAM - 1G
>
>
> 1. Explain on SELECT.
So either this is a typo (1 GB of RAM) or your query is likely ending up I/O
bound.
You should probably provide EXPLAIN and EXPLAIN (ANALYZE) output since even
with the schema it is impossible for someone to see what the planner is
proposing for a multiple-million record source table that is going to be
empty if all someone does is create the schema.
For my money it is also helpful to actual write some prose describing what
you are providing and seeing and not just toss some settings and schema out
there.
http://wiki.postgresql.org/wiki/SlowQueryQuestions
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/57-minute-SELECT-tp5773169p5773174.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
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: polobo@yahoo.com
Subject: Re: 57 minute SELECT
In-Reply-To: <1380763034169-5773174.post@n5.nabble.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