Re: [PERFORM] slow database

2004-02-11 Thread alemon
the version is 7.3.2 in a connective 9. the hen foot is without nails at the moment: =) | /|\ this is a principal table of system: CREATE TABLE public.compra_prod_forn ( nu_seq_prod_forn numeric(12) NOT NULL, cd_fabricante numeric(6), cd_moeda numeric(4) NOT NULL, cd_compra numeric(12) N

Re: [PERFORM] slow database

2004-02-11 Thread alemon
I already came back the old conditions and I continue slow in the same way! Quoting Tom Lane <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] writes: > > the normal queries do not present problems, but all the ones > > that join has are very slow. > > No surprise, as you've disabled all but the stupides

Re: [PERFORM] slow database

2004-02-11 Thread alemon
the normal queries do not present problems, but all the ones that join has are very slow. OBS: I am using way ODBC. He will be that they exist some configuration specifies inside of the same bank or in the ODBC? Quoting Rod Taylor <[EMAIL PROTECTED]>: > On Wed, 2004-02-11 at 09:23, [EMAIL PROT

[PERFORM] slow database

2004-02-11 Thread alemon
my data base is very slow. The machine is a processor Xeon 2GB with 256 MB of RAM DDR. My archive of configuration is this: # # PostgreSQL configuration file # - # # This file consists of lines of the f