| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com>, "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Postgresql-Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [RFC] GSoC Work on readonly queries done so far |
| Date: | 2007-06-06 21:14:42 |
| Message-ID: | 20070606211442.GO11800@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> On Wed, 2007-06-06 at 12:17 -0400, Matthew T. O'Connor wrote:
> > Florian G. Pflug wrote:
> > > Work done so far:
> > > -----------------
> > > .) Don't start autovacuum and bgwriter.
> >
> > Do table stats used by the planner get replicated on a PITR slave? I
> > assume so, but if not, you would need autovac to do analyzes.
>
> The replication is an exact block-level replication of the master. We
> can't write very much at all on the slave.
Hmm, something to keep in mind is forcing cache invals when the master
causes them (for example relation cache, catalog caches and plan
caches).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-06-06 21:36:22 | Re: [RFC] GSoC Work on readonly queries done so far |
| Previous Message | Tom Lane | 2007-06-06 21:03:52 | Re: Implicit casts with generic arrays |