On Fri, 2008-11-21 at 15:45 +1100, Philip Warner wrote: > Sounds somewhat evil, I know, but I was wondering if it was even > remotely possible with the current design? > > The reason: we are contemplating using pg_standy to create a > warm-standby. It would be a bonus if we would run read-only queries > against this DB to take some of the load off or production servers. > > We currently use slony to provide warm-standby *and* read-only access, > but pg_standby is a great deal more appealing...especially if there was > some way to do read-only access at the same time.
Yes, exactly what I'm working on now, currently patch in review. > FWIW, the data would not even need to be completely consistent ... the > kinds of things we are looking at offloading are large summary-type > sequential scans of big tables. Access to inconsistent data has not been agreed. We will only allow access to consistent data with this approach. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
