Postgres Pro
Downloads
Home   >   mailing lists

Re: how to avoid that a postgres session eats up all the memory - Mailing list pgsql-general

From Clemens Schwaighofer
Subject Re: how to avoid that a postgres session eats up all the memory
Date
Msg-id 4979080B.30408@tequila.jp
Whole thread Raw
In response to Re: how to avoid that a postgres session eats up all the memory  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: how to avoid that a postgres session eats up all the memory
List pgsql-general
Tree view 
On 01/22/2009 07:19 PM, Grzegorz Jaśkiewicz wrote:
> try making it in two steps,using temp table maybe.
> how many rows does the subselect generate ?

the subselect returns 57.000 rows.

--
[ Clemens Schwaighofer                      -----=====:::::~ ]
[ IT Engineer/Web Producer/Planning/Manager                  ]
[ E-Graphics Communications SP Digital                       ]
[                6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7706            Fax: +81-(0)3-3545-7343 ]
[ http://www.e-gra.co.jp                                     ]
Attachment

pgsql-general by date:

Previous
From: Clemens Schwaighofer
Date:
Subject: Re: how to avoid that a postgres session eats up all the memory
Next
From: Scott Marlowe
Date:
Subject: Re: Slow update