Received: from dfw-ix12.ix.netcom.com (dfw-ix12.ix.netcom.com [206.214.98.12]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA65453 for ; Tue, 14 Sep 1999 17:47:36 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (from smap@localhost) by dfw-ix12.ix.netcom.com (8.8.4/8.8.4) id QAA12562 for ; Tue, 14 Sep 1999 16:46:57 -0500 (CDT) Received: from unknown(207.230.254.117) by dfw-ix12.ix.netcom.com via smap (V1.3) id rma012136; Tue Sep 14 16:45:04 1999 Sender: clay@ix.netcom.com Message-ID: <37DEC3E1.59071869@smartt.com> Date: Tue, 14 Sep 1999 14:53:37 -0700 From: Clayton Cottingham X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.12 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: to do's? References: <17275.937340960@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hi i was wondering if multi threading will be enabled soon? also a prob im having which might be query related but a todo as well is that i have a 1.3 mil row db when i try to select all i get memory out type errors, either system wide or droping the backend even when i go over 1/4 of the size this happens, can there be some sort of improvements in the memory handling here too? or is this an sql technique i dont realize? basically im selecting rows from the 1.3 mil table and inserting certain columns into another after some processing im basically using select field1,field2 ,field3 from table and the preprocess and insert into othertable values field1 ,filed2 ,field3 even if i reduce the select statement to half the size of the first table it still cans out any help appreciatted !