Re: Getting a better performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Dec 8, 2015 at 10:29 PM, Emily de Souza <emilysouzabg@xxxxxxxxx> wrote:

> I've got 3 DB servers, running PostgreSQL 9.2.14 with PHP APIs:
>
> 1 - Master DB (16 cores, 128 GB RAM, RAID 10)
> 2 - Slave (warm standby DB - full sized)
> 3 - Slave (warm standby DB - full sized)
> 4 - Slave (warm standby DB)
>
> I would like to improve the performance, by slowing the response
> time (ms) of the DB server.
> But I don't know where to start.
> Do you have some tips/how to about how can I get the information
> that I need?

Without more detail about your problem and what you're trying to
achieve, it is hard to make a suggestion.  If you can pick out a
query that is taking longer than you expect, you might want to
present that to the performance list, following the advice here:

https://wiki.postgresql.org/wiki/SlowQueryQuestions

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux