pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: ktm@rice.edu <ktm@rice.edu>
To: Samuel Stearns <sstearns@staff.iinet.net.au>
Cc: Claudio Freire <klaussfreire@gmail.com>
Cc: David Johnston <polobo@yahoo.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: 57 minute SELECT
Date: Thu, 3 Oct 2013 07:59:18 -0500
Message-ID: <20131003125918.GG16128@aart.rice.edu> (raw)
In-Reply-To: <CB03CD8D2C3F9347BAFEC8EA9DD89C9318D37FD2@ISP-OSB-DAG2.win2k.iinet.net.au>
References: <CB03CD8D2C3F9347BAFEC8EA9DD89C9318D3785F@ISP-OSB-DAG2.win2k.iinet.net.au>
	<1380763034169-5773174.post@n5.nabble.com>
	<CB03CD8D2C3F9347BAFEC8EA9DD89C9318D379A1@ISP-OSB-DAG2.win2k.iinet.net.au>
	<CAGTBQpbMrJCTTicpGwfRRaHQ5haitdeqA9hCSpBiTFALYZVoMg@mail.gmail.com>
	<CB03CD8D2C3F9347BAFEC8EA9DD89C9318D37A50@ISP-OSB-DAG2.win2k.iinet.net.au>
	<CAGTBQpYdss9oZykcB46zhBBgN+gVCX=8mj2=iciwFywtsHfNqg@mail.gmail.com>
	<CB03CD8D2C3F9347BAFEC8EA9DD89C9318D37FD2@ISP-OSB-DAG2.win2k.iinet.net.au>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On Thu, Oct 03, 2013 at 04:19:29AM +0000, Samuel Stearns wrote:
> Thanks, Claudio.
> 
> I'll have a look at the clustering.
> 
> We have also noticed that the same query with a datetime range of 3 hours (rather than 4 months) runs in just 30 seconds:
> 
> AND datetime <= '2013-10-03 10:03:49'
> AND datetime >= '2013-10-03 07:03:49'
> 

Hi Samuel,

That is even worse performance relatively. 30s for a 3 hour range equals
28800s for a 4 month (2880 hours) range, or 8 hours. I definitely would
consider clustering.

Regards,
Ken


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (18+ messages)  latest in thread

Message-ID: <20131003125918.GG16128@aart.rice.edu>
Permalink:  ../20131003125918.GG16128@aart.rice.edu/
Also on:    postgresql.org/message-id/20131003125918.GG16128@aart.rice.edu

 · 

reply
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: ktm@rice.edu, sstearns@staff.iinet.net.au, klaussfreire@gmail.com, polobo@yahoo.com
  Subject: Re: 57 minute SELECT
  In-Reply-To: <20131003125918.GG16128@aart.rice.edu>

* 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