[pgadmin-support] Out of memory while reading tuples Error

[Karim R. Lakhani]

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
--


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly