Hello,
Thanks Jim, i change stats_command_string=false and i wait but it's
works now :-)
Jérôme.
Le jeudi 22 juin 2006 à 21:00 -0500, Jim Nasby a écrit :
> On Jun 22, 2006, at 2:24 AM, Jérôme BENOIS wrote:
> > We use 7.4.6 version and now we have a bad performance on our
>
> You shou
Hello,
I am running the following query:
SELECT
indiv_fkey,
MAX(emp_ind),
MAX(prizm_cd_indiv),
MAX(CASE
WHEN div IS NULL THEN NULL
WHEN store_loyal_loc_cd IS NULL THEN NULL
ELSE div || '-' ||
"Abu Mushayeed" <[EMAIL PROTECTED]> writes:
> AFTER A WHILE THE SYSTEM COMES BACK AND SAYS IN THE LOG FILE:
Please turn off your caps lock key :-(
> AggContext: -1501569024 total in 351 blocks; 69904 free (507 chunks);
> -1501638928 used
> DynaHashTable: 302047256 total in 46 blocks; 275720 free
Hi for all,Please, Normaly when some SGBD exec the algoritm Nest-Loop Join, there are diferences about the space(buffer) for outer table and inner table. So, I want know where Postgres define the number for this spaces (buffers)? And can I change it?This is very important to me.
On Thu, 22 Jun 2006, Jeff Frost wrote:
On Thu, 22 Jun 2006, Jim Nasby wrote:
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: free space map contains 3339998 pages in 125 relations
DETAIL: A total of 3341600 page slots are in use (including overhead).
3341600 page slots are required to track all
