Re: Advice on tuning slow query

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Samuel Stearns <SStearns(at)internode(dot)com(dot)au>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Advice on tuning slow query
Date: 2013-05-21 23:33:16
Message-ID: CAL_0b1s+DDWKg28wDkQovseCRKT302FO8Wz30m4U5AAYT905oQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 21, 2013 at 4:16 PM, Samuel Stearns
<SStearns(at)internode(dot)com(dot)au> wrote:
> Is there anything I can do to get the SELECT to run a little quicker.

Please carefully follow the instruction first
http://wiki.postgresql.org/wiki/Slow_Query_Questions.

I would also suggest to upgrade postgres to the latest version, as it
has a lot of performance improvements.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2013-05-22 00:19:09 Re: Reliability with RAID 10 SSD and Streaming Replication
Previous Message Samuel Stearns 2013-05-21 23:16:58 Advice on tuning slow query