On 14 Jun 2012, at 20:25, Merlin Moncure wrote:
>> CREATE OR REPLACE VIEW missing_archiveset_in_mds_ops
>> (filename, esdt, archiveset) AS
>> select * from dblink('host=ops_host port=4001 user=omiops dbname=omiops',
>> 'select filename, esdt, archiveset from
>> filemeta_archiveset join filemeta_
On Thu, Jun 14, 2012 at 11:15 AM, Alex Lai wrote:
> My host was freeze up after submitted the following query that prevented me
> to ssh to the host.
> I was unable to psql and submit pg_cancel_backend. The tables have over 20
> millions rows.
> Does dblink uses too much resource from the host wh
