| 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
| 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 |