Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: how can a couple of expensive queries drag my system down?
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "p prince" <pprince127(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: how can a couple of expensive queries drag my system down?
- Date: Wed, 26 Mar 2008 14:31:32 -0600
On Wed, Mar 26, 2008 at 1:48 PM, p prince <pprince127(at)gmail(dot)com> wrote: > is this 'normal'? (loaded question I know) > Should I be looking to offload expensive reporting queries to read-only > replicants of my database? Yes, definitely look into setting up something like a slony slave that's used for reporting queries. The nice thing about this setup is you only need to replicate the tables you run reports against.
- Follow-Ups:
- Re: how can a couple of expensive queries drag my system down?
- From: Erik Jones
- Re: how can a couple of expensive queries drag my system down?
- From: Shane Ambler
- Re: how can a couple of expensive queries drag my system down?
- References:
- how can a couple of expensive queries drag my system down?
- From: p prince
- how can a couple of expensive queries drag my system down?
- Prev by Date: Re: how can a couple of expensive queries drag my system down?
- Next by Date: Re: how can a couple of expensive queries drag my system down?
- Previous by thread: Re: how can a couple of expensive queries drag my system down?
- Next by thread: Re: how can a couple of expensive queries drag my system down?
- Indexes: