[PERFORM] Query too slow

ase takes less than 40 seconds. I have tried to isolate the problem taking off some fields and I left 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 fa

[PERFORM] SQL performance problems

ame alication to use both Oracle or PostgreSQL without changing any source. atached follow tha explain analyze for this query and my postgresql.conf. I still searching a way to make it faster. I've tried to change a lot of variables values like sort_mem, effective_cache_size, fsync, ... I cha

Re: [PERFORM] [ADMIN] SQL slower when running for the second time

t;> [mailto:[EMAIL PROTECTED] Behalf Of Rhaoni Chiu <> Pereira <> Sent: Wednesday, September 03, 2003 3:16 PM <> To: PostgreSQL Performance; Lista PostgreSQL <> Subject: [ADMIN] SQL slower when running for the second time <> <> <> Hi List, <> <&g

[PERFORM] 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 5: Have you checked our extensive FAQ? http

[PERFORM] 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

[PERFORM] How to force an Index ?

-> Index Scan using ftnfpr05 on ftnfpr00 (cost=0.00..5.91 rows=1 width=112) (actual time=0.06..0.15 rows=3 loops=6358) Index Cond: (("outer".emp = ftnfpr00.emp) AND ("outer".f

Re: [PERFORM] How to force an Index ?

racle too. I need to know if there is a way to set 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

[PERFORM] 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 9: the planner will ignore

[PERFORM] Low Insert/Update Performance

initdb -- may be changed) LC_MESSAGES = 'en_US.UTF-8' LC_MONETARY = 'en_US.UTF-8' LC_NUMERIC = 'en_US.UTF-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

Re: [PERFORM] Low Insert/Update Performance

ncryption = true #sql_inheritance = true #transform_null_equals = false #statement_timeout = 0 # 0 is disabled, in milliseconds #db_user_namespace = false # # Locale settings # # (initialized by initdb -- may be changed) LC_MESSAGES = 'en_US.UTF-8' LC_MONETARY = 'en

[PERFORM] ODBC Driver generates a too big "windows swap file" and it's too slow

pace u, pg_catalog.pg_class c, pg_catalog.pg_attribute a, pg_catalog.pg_type t where u.oid = c.relnamespace and (not a.attisdropped) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname = 'ftclcr00'and u.nspname = 'vendas' order by u.nspname, c.rel

[PERFORM] Unsubscribe

---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly