From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Joe Conway <joe.conway@mail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: remote database queries
Date: Thu, 14 Jun 2001 12:48:47 -0400 (EDT)
Message-ID: <200106141648.f5EGmlF09097@candle.pha.pa.us> (raw)
In-Reply-To: <009101c0e98e$872bdb00$0205a8c0@jecw2k1>
Added to /contrib. Thanks.
> > Until we fix that (maybe for 7.2, maybe not) your existing hack is
> > probably pretty reasonable. You could save some cycles by avoiding
> > conversion to text, though --- instead return an opaque datum that is
> > pointer-to-tuple-slot and let the dblink_tok function extract fields
> > from the tuple. Look at SQL function support and the FieldSelect
> > expression node type for inspiration.
> >
>
> I changed the dblink() function to return a pointer instead of concatenated
> text, and dblink_tok() to use the pointer. FWIW, a query on a small (85
> tuples) remote (a second PC on a 100baseT subnet) table takes about 34
> milliseconds (based on show_query_stats) versus about 4 milliseconds when
> run locally. It actually takes a bit longer (~65 milliseconds) when run
> against a second database on the same PC. The original text parsing version
> was about 25% slower.
>
> Although shifting from text parsing to pointer passing is more efficient, I
> have one more question regarding this -- for now ;) -- is there any way to
> check the pointer passed to dblink_tok() to be sure it came from dblink()?
>
> Thanks,
>
> -- Joe
>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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-interfaces@postgresql.org
Cc: pgman@candle.pha.pa.us, joe.conway@mail.com, pgsql-hackers@postgresql.org
Subject: Re: remote database queries
In-Reply-To: <200106141648.f5EGmlF09097@candle.pha.pa.us>
* 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