On Wed, Mar 26, 2008 at 1:48 PM, p prince <pprince127@xxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance