On Wed, Sep 29, 2004 at 11:23:52PM -0600, Ed L. wrote:
> On Wednesday September 29 2004 5:17, Tom Lane wrote:
> > >
> > > 2004-09-29 18:14:53.621 [520] ERROR: Memory exhausted in
> > > AllocSetAlloc(1189)
> > >
> > > Analyze: 132263832 total in 27 blocks; 2984 free (35 chunks); 132260848
> > > used
> >
> > Either increase your per-process memory limit, or reduce the statistics
> > targets for this table ...
>
> Can you explain a little more of how you interpret the numbers above to draw
> your conclusion?
I just means that, from the operating system POV, there are 132263832
bytes in use. The rest is Pg internal bookkeeping that doesn't help you
any.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Uno combate cuando es necesario... ¡no cuando está de humor!
El humor es para el ganado, o para hacer el amor, o para tocar el
baliset. No para combatir." (Gurney Halleck)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
