X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 70694D1ECDC for ; Thu, 25 Mar 2004 18:20:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14630-02 for ; Thu, 25 Mar 2004 14:20:32 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 651FFD1ECC6 for ; Thu, 25 Mar 2004 14:20:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2PIKXoR013125; Thu, 25 Mar 2004 13:20:33 -0500 (EST) To: Qing Zhao Cc: pgsql-performance@postgresql.org Subject: Re: column size too large, is this a bug? In-reply-to: <082D0538-7E86-11D8-8B9C-000A95AB8896@quotefx.net> References: <082D0538-7E86-11D8-8B9C-000A95AB8896@quotefx.net> Comments: In-reply-to Qing Zhao message dated "Thu, 25 Mar 2004 09:58:33 -0800" Date: Thu, 25 Mar 2004 13:20:32 -0500 Message-ID: <13124.1080238832@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/360 X-Sequence-Number: 6216 Qing Zhao writes: > I have a query which get's data from a single table. > When I try to get data from for an RFQ which has around 5000 rows, it > is breaking off at 18th row. > If i reduce some columns , then it returns all the rows and not so slow. What client-side software are you using? This is surely a limitation on the client side, because there is no such problem in the server. regards, tom lane