Re: Advice on tuning slow query - Mailing list pgsql-performance

From Sergey Konoplev
Subject Re: Advice on tuning slow query
Date
Msg-id CAL_0b1s+DDWKg28wDkQovseCRKT302FO8Wz30m4U5AAYT905oQ@mail.gmail.com
Whole thread Raw
In response to Advice on tuning slow query  (Samuel Stearns <SStearns@internode.com.au>)
List pgsql-performance
On Tue, May 21, 2013 at 4:16 PM, Samuel Stearns
<SStearns@internode.com.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.ru@gmail.com


pgsql-performance by date:

Previous
From: Samuel Stearns
Date:
Subject: Advice on tuning slow query
Next
From: Greg Smith
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication