to do's?

Поиск
Список
Период
Сортировка
От Clayton Cottingham
Тема to do's?
Дата
Msg-id 37DEC3E1.59071869@smartt.com
обсуждение исходный текст
Ответ на Re: [SQL] reliable way to crash postgres :)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [SQL] to do's?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] reliable way to crash postgres :)
Следующее
От: Nuchanach Klinjun
Дата:
Сообщение: Re: [HACKERS] Permission problem with COPY FROM