to do's? - Mailing list pgsql-sql

From Clayton Cottingham
Subject to do's?
Date
Msg-id 37DEC3E1.59071869@smartt.com
Whole thread Raw
In response to Re: [SQL] reliable way to crash postgres :)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] to do's?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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
!






pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] reliable way to crash postgres :)
Next
From: Nuchanach Klinjun
Date:
Subject: Re: [HACKERS] Permission problem with COPY FROM