From sandhyar@amiindia.co.in Fri Nov 11 08:51:35 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B6AA0DA684 for ; Fri, 11 Nov 2005 04:51:35 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18630-06 for ; Fri, 11 Nov 2005 08:51:33 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5D903DA615 for ; Fri, 11 Nov 2005 04:51:34 -0400 (AST) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr2.postgresql.org (Postfix) with ESMTP id D15F3F1190 for ; Fri, 11 Nov 2005 08:51:32 +0000 (GMT) Received: from amiindiahjwbgh (unknown [10.0.0.205]) by mars.amiindia.co.in (Postfix) with ESMTP id 01A6F74C170; Fri, 11 Nov 2005 14:29:29 +0530 (IST) Message-ID: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "Sivakumar K" , "sandhya" Subject: Reg: Records Size Date: Fri, 11 Nov 2005 14:29:10 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0127_01C5E6CC.47F45940" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.022 required=5 tests=[AWL=0.021, HTML_MESSAGE=0.001] X-Spam-Score: 0.022 X-Spam-Level: X-Archive-Number: 200511/131 X-Sequence-Number: 19504 This is a multi-part message in MIME format. ------=_NextPart_000_0127_01C5E6CC.47F45940 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable please...tell me if there is possibility of finding out the size of a = record in the specified table. Is there any built in function to know the size of each record by = passing a query? I need this Inorder to allocate the memory after retrieving the records. Pls suggest me. Thanks&Regards, Sandhya ------=_NextPart_000_0127_01C5E6CC.47F45940 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
 
please...tell me if there is = possibility of=20 finding  out the size of a record in the specified = table.
Is there any built in function = to know the=20 size of each record by passing a query?
I need this Inorder to allocate the = memory after=20 retrieving the records.
Pls suggest me.
 
Thanks&Regards,
Sandhya
 
------=_NextPart_000_0127_01C5E6CC.47F45940-- From jbarham@gmail.com Fri Nov 11 09:10:39 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57962D6D46 for ; Fri, 11 Nov 2005 05:10:39 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25691-06 for ; Fri, 11 Nov 2005 09:10:37 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by svr1.postgresql.org (Postfix) with ESMTP id D4DF9D6D4F for ; Fri, 11 Nov 2005 05:10:37 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 71so494472wra for ; Fri, 11 Nov 2005 01:10:39 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jRwL7xw/BPJSYiuYgV/Il3wmP8YCBHXb4IKJduzgoCCYnYCMzpQ4IcTSdEH/hRoizTXSWVyMN23khA7SFL/NnbBnyRNUscFyb7JVs/Vpbq/UBA3jguB6g13ETtruaD0CljcVZxuFH++wWXKgxy8PA4LREyQMWfxTxvK+w5v0BD4= Received: by 10.65.156.11 with SMTP id i11mr1638061qbo; Fri, 11 Nov 2005 01:10:38 -0800 (PST) Received: by 10.65.83.10 with HTTP; Fri, 11 Nov 2005 01:10:38 -0800 (PST) Message-ID: <4f34febc0511110110h1a1453f0tb3997a88b61dfd1e@mail.gmail.com> Date: Fri, 11 Nov 2005 18:10:38 +0900 From: John Barham To: sandhya Subject: Re: Reg: Records Size Cc: postgre , Sivakumar K In-Reply-To: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.1 required=5 tests=[AWL=0.100] X-Spam-Score: 0.1 X-Spam-Level: X-Archive-Number: 200511/132 X-Sequence-Number: 19505 On 11/11/05, sandhya wrote: > please...tell me if there is possibility of finding out the size of a > record in the specified table. > Is there any built in function to know the size of each record by passing= a > query? > I need this Inorder to allocate the memory after retrieving the records. > Pls suggest me. You are not giving enough information. What programming language are you using? What do you mean by a "record"? Do you want to know much memory to allocate to store each tuple resulting from a query? If so, that will obviously depend on the type of each column and the size of each field. John Barham From sandhyar@amiindia.co.in Fri Nov 11 10:12:29 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 90BD6D7226 for ; Fri, 11 Nov 2005 06:12:29 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43295-06 for ; Fri, 11 Nov 2005 10:12:25 +0000 (GMT) X-Greylist: delayed 01:20:59.978628 by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 32EE7D6D17 for ; Fri, 11 Nov 2005 06:12:22 -0400 (AST) Received: from amiindiahjwbgh (unknown [10.0.0.205]) by mars.amiindia.co.in (Postfix) with ESMTP id E7DAB74C179; Fri, 11 Nov 2005 15:50:33 +0530 (IST) Message-ID: <017301c5e6a9$81f4e920$cd00000a@amiindiahjwbgh> From: "sandhya" To: "John Barham" Cc: "postgre" References: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> <4f34febc0511110110h1a1453f0tb3997a88b61dfd1e@mail.gmail.com> Subject: Re: Reg: Records Size Date: Fri, 11 Nov 2005 15:50:15 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.02 required=5 tests=[AWL=0.020] X-Spam-Score: 0.02 X-Spam-Level: X-Archive-Number: 200511/133 X-Sequence-Number: 19506 Hi John , Thank you. I am using C. Yes i mean to allocate memory of each tuple resulting from a query. Is there any function which gives the size of a tuple? If so...Please tell me/Tell me how to proceed to do that? Thanks&Regards, Sandhya R ----- Original Message ----- From: "John Barham" To: "sandhya" Cc: "postgre" ; "Sivakumar K" Sent: Friday, November 11, 2005 2:40 PM Subject: Re: [ADMIN] Reg: Records Size On 11/11/05, sandhya wrote: > please...tell me if there is possibility of finding out the size of a > record in the specified table. > Is there any built in function to know the size of each record by passing a > query? > I need this Inorder to allocate the memory after retrieving the records. > Pls suggest me. You are not giving enough information. What programming language are you using? What do you mean by a "record"? Do you want to know much memory to allocate to store each tuple resulting from a query? If so, that will obviously depend on the type of each column and the size of each field. John Barham From jbarham@gmail.com Fri Nov 11 13:34:23 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2EE97DB1FF for ; Fri, 11 Nov 2005 09:34:23 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47304-06 for ; Fri, 11 Nov 2005 13:34:19 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by svr1.postgresql.org (Postfix) with ESMTP id BE329DAABA for ; Fri, 11 Nov 2005 09:34:21 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 71so569400wri for ; Fri, 11 Nov 2005 05:34:25 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=O8euyRawcSmL7Vnf28S9TyMOK19xqpbEYAVpKDTO22CZDmOZojBV3MCUgO3NSBzycriepaFp4sl9W4r07JMTtERq3t6dUDmI9YbHpy62dpv5nHvUaB6WhKh8UpC8yGLzFSIm57TCmCmA/ZOtcFykjsk1qErG7+rFeHP+QFG1RD4= Received: by 10.65.123.6 with SMTP id a6mr2346079qbn; Fri, 11 Nov 2005 05:34:25 -0800 (PST) Received: by 10.65.83.10 with HTTP; Fri, 11 Nov 2005 05:34:25 -0800 (PST) Message-ID: <4f34febc0511110534i20d84cc6la1d67918e86b7aeb@mail.gmail.com> Date: Fri, 11 Nov 2005 22:34:25 +0900 From: John Barham To: sandhya Subject: Re: Reg: Records Size Cc: postgre In-Reply-To: <017301c5e6a9$81f4e920$cd00000a@amiindiahjwbgh> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <012a01c5e69e$2e454500$cd00000a@amiindiahjwbgh> <4f34febc0511110110h1a1453f0tb3997a88b61dfd1e@mail.gmail.com> <017301c5e6a9$81f4e920$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200511/134 X-Sequence-Number: 19507 > I am using C. Lucky you. I use Python. ;) > Yes i mean to allocate memory of each tuple resulting from a query. > Is there any function which gives the size of a tuple? > If so...Please tell me/Tell me how to proceed to do that?