---(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
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
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
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
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
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
-> 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
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
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
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
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
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
12 matches
Mail list logo