Re: query size

Gerhard Haering <[email protected]> Fri, 18 Feb 2005 11:53:13 +0100
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
On Fri, Feb 18, 2005 at 04:52:26PM +1000, Timothy Smith wrote:
> is there anyway i can calculate how much data is going ot be sent in a 
> query. i know it will depend on the data etc, but there must be certain 
> over head per row etc i need to account for. it'll will help me 
> determine how much traffic and bandwidth i need to account for and how 
> many users i can load per connection.

The PostgreSQL frontend-backend protocol is documented here:
http://www.postgresql.org/docs/current/static/protocol.html

HTH,

-- Gerhard
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQFCFckZdIO4ozGCH14RAptFAJ9MJUKC0gW6R+qRngvRZuRYBgIUaQCfZoXb
XdMavu+ZctJJ7EvcYF7lrdc=
=vkfr
-----END PGP SIGNATURE-----