X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 440E2476366 for ; Thu, 3 Apr 2003 13:15:46 -0500 (EST) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 3539647634B for ; Thu, 3 Apr 2003 13:15:41 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa04050; 3 Apr 2003 13:15 EST Received: from virginia.edu (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.7/8.11.6) with ESMTP id h33IFcl05510 for ; Thu, 3 Apr 2003 13:15:38 -0500 Message-ID: <3E8C7BD0.3020006@virginia.edu> Date: Thu, 03 Apr 2003 13:22:08 -0500 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 X-Accept-Language: en-us MIME-Version: 1.0 To: Postgres Admin List Subject: Re: Speed & Memory Management Content-Type: multipart/alternative; boundary="------------010203090408030701020200" X-Spam-Status: No, hits=-8.3 required=5.0 tests=ASCII_FORM_ENTRY,BAYES_20,HTML_70_80,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/42 X-Sequence-Number: 8197 --------------010203090408030701020200 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit In response to the speed and memory management messages posted. Can someone tell me if the varchar(N) data type also impedes performance by padding with spaces? Thank you, Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu --------------010203090408030701020200 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit In response to the speed and memory management messages posted. Can someone tell me if the varchar(N) data type also impedes performance by padding with spaces?
Thank you,
Jodi
--
________________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

--------------010203090408030701020200--