From owner-freebsd-questions Thu Apr 9 07:53:36 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA06656 for freebsd-questions-outgoing; Thu, 9 Apr 1998 07:53:36 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from pili.adn.edu.ph (art@pili.adn.edu.ph [165.220.57.4]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA06648 for ; Thu, 9 Apr 1998 07:53:31 -0700 (PDT) (envelope-from art@pili.adn.edu.ph) Received: from localhost (art@localhost) by pili.adn.edu.ph (8.8.7/8.8.7) with SMTP id XAA00549 for ; Thu, 9 Apr 1998 23:02:22 +0800 (PHT) (envelope-from art@pili.adn.edu.ph) Date: Thu, 9 Apr 1998 23:02:21 +0800 (PHT) From: Arthur Alacar cc: freebsd-questions@FreeBSD.ORG Subject: PostgreSQL 6.3.1 In-Reply-To: <3.0.3.32.19980409103054.009062a0@popmail.p3.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG GOOD DAY!! anyone here using Postgresql? am having trouble querying large records... it always returns a segmentation fault... i tried inquiring at postgres mailing-list and they told me that their postgres can manage > Millions of records and heard so far about > 2GB size of a table... is this then a platform problem? a problem with my OS? am running 2.2.5 .. i tried monitoring my system resources using 'top' and everytime a query on postgres (with large resulting records) is issued.. huge amount of memory is being allocated... > 16MB and suddenly ... returns a segmentation fault.. AM ALSO NOTICING THAT MY SWAP SPACE IS UNTOUCHED... any HELP for this problem? thank you :) .a.r.t. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message