[PERFORM] Query Fails with error calloc - Cannot alocate memory

()     :initplan <>     :nprm 0     :scanrelid 1     }  Seq Scan on flash_by_branches  (cost=1.00..100567542.06 rows=26854106 width=68) (actual time=6.59..82501.15 rows=2685 4106 loops=1)  Total runtime: 102089.00 msec (196 rows) Please assist. Thanks, Howard Oblowitz --- Outgoing

[PERFORM] Effective Cache Size

e the effect of setting this too high? And too low? How does it impact on other applications eg Java ? > -Original Message- > From: scott.marlowe [SMTP:[EMAIL PROTECTED] > Sent: 01 July 2003 03:20 > To: Howard Oblowitz > Cc: [EMAIL PROTECTED] > Subject: Re: FW: [PER

FW: [PERFORM] Version 7 question

What would be the best value range for effective_cache_size on Postgres 7.3.2, assuming say 1.5 GB of RAM and shared_buffers set to 8192, and shmmax set to 750mb? And what are the most important factors one should take into account in determining the value? > -Original Message- > From:

Re: [PERFORM] Performance advice

I agree a route map would really help. > -Original Message- > From: Hilary Forbes [SMTP:[EMAIL PROTECTED] > Sent: 25 June 2003 10:12 > To: Rod Taylor > Cc: [EMAIL PROTECTED] > Subject: Re: [PERFORM] Performance advice > > PM4JI but from my point of view this has been a most usefu

[PERFORM] Unsubscribe

Unsubscribe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]