[ADMIN] Unsubscribe

---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] [PERFORM] Low Insert/Update Performance

9 , PostgreSQL 7.3.2-3 Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 Citando Josh Berkus [EMAIL PROTECTED]: Rhaoni, The delphi program does just one commit for all queries . I was wandering if ther

[ADMIN] Low Insert/Update Performance

-8' LC_TIME = 'en_US.UTF-8' Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] ODBC Driver

for windows ? Sorry if it looks a stupid question but I have just stating to work with databases ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast

[ADMIN] Plan-Reading

Hi List; Where can I find a plan-readinf tutorial ? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 6: Have you searched our

[ADMIN] ERROR: tuplestore: write failed

Hi list, What does this error mean ? ERROR: tuplestore: write failed I was just running a SQL and it gave me this error ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122

Re: [ADMIN] ERROR: tuplestore: write failed

I already found the error ( out of disk space ) query result too big ! Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 Citando Rhaoni Chiu Pereira [EMAIL PROTECTED]: Hi list, What does this error mean

Re: [ADMIN] [PERFORM] How to force an Index ?

the to_char output to varchar instead of text ! Any Idea ? So, this way I wont have to change my aplication source. Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 Citando Josh Berkus [EMAIL PROTECTED]: Rhaoni

[ADMIN] How can I make PosgreSQL use an Index ?

by a BI software and to change it, I'll have to make a lot of changes in the BI software source. In the Oracle DB it works fine 'cuz Oracle use the index and do it instantly. Any suggestion on how to force PostgreSQL tu use this index ??? Atenciosamente, Rhaoni Chiu Pereira Sistêmica

Re: [ADMIN] How can I make PosgreSQL use an Index ?

Cond: ((ftrepr00.emp = outer.emp) AND (ftrepr00.fil = outer.empfil) AND (ftrepr00.codigo_repr = outer.cod_repres)) Total runtime: 105885.43 msec (75 rows) The Oracle functions like NVL, DECODE, and others had been created in PostgreSQL. Atenciosamente, Rhaoni Chiu Pereira Sistêmica

[ADMIN] Explain Doc

Hi List, Could anyone tell me a documentation that explains the explain result and how to analyze it ? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast

[ADMIN] SQL slower when running for the second time

anyone have a advice ? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[ADMIN] How to force an Index ?

. Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] How to force an Index ?

. Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs

[ADMIN] Query to slow

justa the two first fields in the query ( ftnfco00.estado_cliente , ftcofi00.grupo_faturamento ) and it still taking almost 4 min to return. Does anyone have a hint to give me to make it faster ? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info

[ADMIN] Explicit Cast

' and 'character varying' You will have to retype this query using an explicit castenciosamente, atual_fatura is a varchar field. I read howto create an explicit cast but I didn't understand what I must do in this case. Can anybody help me ? Rhaoni Chiu Pereira Sistêmica Computadores Visite

[ADMIN] Problems creating a function

? Atenciosamente, Rhaoni Chiu Pereira Sistêmica Computadores Visite-nos na Web: http://sistemica.info Fone/Fax : +55 51 3328 1122 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs