Out of memory while reading tuples Error

Поиск
Список
Период
Сортировка
От Karim R. Lakhani
Тема Out of memory while reading tuples Error
Дата
Msg-id 3F31393F.3050508@mit.edu
обсуждение исходный текст
Список pgadmin-support
Hi All,

I have a fairly *large* database and I am running a pretty simple SQL 
query exporting it to an ASCII file (running PgAdmin on an IBM T30 Win2K 
and PostGres is on P4 1GB RAM):

SELECT  public.stats_project_months.group_id,  public.stats_project_months.developers,
public.stats_project_months.downloads,

FROM  public.meta_project,  public.stats_project_months
WHERE  public.meta_project.cell_id = '205'  AND public.stats_project_months.month = '200202'
ORDER BY  public.stats_project_months.group_id ASC


After about 5 mins of running I get the following error:
"Out of memory while reading tuples"

Is this a problem on the client machine or the machine hosting the database?

Is there a fix for this?

Thanks

Karim
-- 




В списке pgadmin-support по дате отправления:

Предыдущее
От: "Snehal Kasodekar"
Дата:
Сообщение: BLOB data
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Testing gateway