to do's?

From: Clayton Cottingham <drfrog(at)smartt(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: to do's?
Date: 1999-09-14 21:53:37
Message-ID: 37DEC3E1.59071869@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
!

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Lockhart 1999-09-15 01:52:43 Re: [HACKERS] BUG with UNIQUE clause
Previous Message Tom Lane 1999-09-14 20:29:20 Re: [SQL] reliable way to crash postgres :)