From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: pgsql-performance@postgresql.org
Subject: dblink /synonyms?
Date: Wed, 03 Sep 2008 10:58:55 +0200
Message-ID: <20080903085855.311500@gmx.net> (raw)
Hello,
we had problems with queries via dblink needing more than three times as long as without dblink on the same server. This has been tested with v8.3.3 as well. Is this still an issue?: http://cunha17.cristianoduarte.pro.br/postgresql/snapshots.en_us.php
"But the two suffer from a severe problem: they bring the whole result from the remote query into the local database server. "
Is anybody maintaining dblink (who?)?
Are there other solutions for connecting two dbs in the work (like synonyms)?
There is another "problem". It's difficult to compare the performance of the queries because the server is caching the queries and dblink is using the same cached querie results as well. Can you 'flush' the results or prevent the results from being cached for being reused? Is Explain Analyze really 'stable' for comparing purposes?
Thank you very much,
Peter
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de
Subject: Re: dblink /synonyms?
In-Reply-To: <20080903085855.311500@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox