Re: Synchronized snapshots versus multiple databases - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Synchronized snapshots versus multiple databases
Date
Msg-id 29284.1319220610@sss.pgh.pa.us
Whole thread Raw
In response to Re: Synchronized snapshots versus multiple databases  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
Florian Pflug <fgp@phlo.org> writes:
> AFAIR, the performance hit we'd take by making the vacuum cutoff point
> (i.e. GetOldestXmin()) global instead of database-local has been repeatedly
> used in the past as an against against cross-database queries. I have to
> admit that I currently cannot seem to find an entry in the archives to
> back that up, though.

To my mind, the main problem with cross-database queries is that none of
the backend is set up to deal with more than one set of system catalogs.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: So, is COUNT(*) fast now?
Next
From: Robert Haas
Date:
Subject: Re: Synchronized snapshots versus multiple databases