Re: [PERFORM] Problems with + 1 million record table

2007-10-05 Thread Scott Marlowe
On 10/5/07, Cláudia Macedo Amorim [EMAIL PROTECTED] wrote: I'm new in PostGreSQL and I need some help. I have a table with ~2 million records. Queries in this table are too slow and some are not completed. I think it must be a simple question to solve but, I'm trying without success. I'm

Re: [PERFORM] Problems with + 1 million record table

2007-10-05 Thread Arjen van der Meijden
On 5-10-2007 16:34 Cláudia Macedo Amorim wrote: [13236.470] statement_type=0, statement='select a_teste_nestle.CODCLI, a_teste_nestle.CODFAB, a_teste_nestle.CODFAMILIANESTLE, a_teste_nestle.CODFILIAL, a_teste_nestle.CODGRUPONESTLE, a_teste_nestle.CODSUBGRUPONESTLE,

Re: [PERFORM] Problems with + 1 million record table

2007-10-05 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cláudia Macedo Amorim wrote: I'm new in PostGreSQL and I need some help. I have a table with ~2 million records. Queries in this table are too slow and some are not completed.I think it must be a simple question to solve but, I'm trying without

Re: [PERFORM] Problems with + 1 million record table

2007-10-05 Thread Shane Ambler
Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cláudia Macedo Amorim wrote: I'm new in PostGreSQL and I need some help. I have a table with ~2 million records. Queries in this table are too slow and some are not completed.I think it must be a simple question to solve