RES: RES: RES: [PERFORM] Improving select peformance

-> Seq Scan on tt_cfg cfg (cost=0.00..1.01 rows=1 width=17) (actual time=0.018..0.019 rows=1 loops=1) -> Index Scan using pk_pla on tt_pla vencodpgt (cost=0.00..0.30 rows=1 width=24) (actual time=0.075..0.076 rows=1 loops=256) Index Cond: ((ven

RES: RES: [PERFORM] Improving select peformance

using the default join_collapse_limit? Thank you in advance! Reimer > -Mensagem original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nome de Carlos H. > Reimer > Enviada em: quarta-feira, 1 de agosto de 2007 21:26 > Para: Alvaro Herrera > Cc: Tom Lane; pgsql-perfo

RES: RES: [PERFORM] Improving select peformance

x27;::bpchar) -> Seq Scan on tt_pla vencodpgt (cost=0.00..2.18 rows=18 width=24) (actual time=0.002..0.017 rows=18 loops=256) Total runtime: 9546.971 ms (46 rows) > -Mensagem original- > De: Alvaro Herrera [mailto:[EMAIL PROTECTED] > Enviada em: quarta-feira, 1 de ag

RES: [PERFORM] Improving select peformance

t = vencodpgt.filpgt) AND (ven.codpgt = vencodpgt.codpgt)) Total runtime: 1747122.219 ms (43 rows) The PG version is the 8.2.3. Apparently the planner is not doing the correct choice by default, correct? I could change the application and insert the set join_collapse_limit to 1 before the select

[PERFORM] Problems with posting

using pk_pla on tt_pla vencodpgt (cost=0.00..0.31 rows=1 width=24) (actual time=0.037..0.040 rows=1 loops=256) Index Cond: ((ven.filpgt = vencodpgt.filpgt) AND (ven.codpgt = vencodpgt.codpgt)) Total runtime: 1747122.219 ms (43 rows) ____ _ Table and view definitions can be accessed at: http://www.opendb.com.br/v1/problem0707.txt Reimer

[PERFORM] Improving select peformance

a on tt_pla vencodpgt (cost=0.00..0.31 rows=1 width=24) (actual time=0.037..0.040 rows=1 loops=256) Index Cond: ((ven.filpgt = vencodpgt.filpgt) AND (ven.codpgt = vencodpgt.codpgt)) Total runtime: 1747122.219 ms (43 rows) ____ _ Table and view definitions can be accessed at: http://www.opendb.com.br/v1/problem0707.txt Reimer

[PERFORM] Disk saturation

y drive(s): fd0 is 1.44M ... ... ... Thank you in advance! Reimer Reimer [EMAIL PROTECTED] OpenDB Serviços e Treinamentos PostgreSQL e DB2 Fone: 47 3327-0878 Cel: 47 9183-0547 www.opendb.com.br

RES: [PERFORM] Improving SQL performance

Yes, casting the result improved the time response a lot. Thank you! Reimer > -Mensagem original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nome de Tom Lane > Enviada em: quinta-feira, 11 de janeiro de 2007 16:31 > Para: [EMAIL PROTECTED] > Cc:

RES: [PERFORM] Improving SQL performance

" btree (tipend) "i_fk_end_dfil" btree (codfil) "i_fk_end_dreg" btree (regiao) "i_fk_end_mun" btree (codcid) tt_log Indexes: "i_fk_log_bai" btree (codbai) "i_lc_log_codcep" btree (codcep) Any clue? Thanks! Reimer > -M

[PERFORM] Improving SQL performance

| not null \d tt_end Table "TOTALL.tt_end" Column | Type |Modifiers +---+----- ... ... ... codlog | character(3) | ... ... ... codcep | character(5) | ... ... Reimer

RES: [PERFORM] Bad iostat numbers

by day. Reimer > -Mensagem original- > De: Mark Kirkwood [mailto:[EMAIL PROTECTED] > Enviada em: quinta-feira, 30 de novembro de 2006 23:47 > Para: [EMAIL PROTECTED] > Cc: pgsql-performance@postgresql.org > Assunto: Re: [PERFORM] Bad iostat numbers > > > Carlos

RES: [PERFORM] Bad iostat numbers

Hi, I´ve taken a look in the /var/log/messages and found some temperature messages about the disk drives: Nov 30 11:08:07 totall smartd[1620]: Device: /dev/sda, Temperature changed 2 Celsius to 51 Celsius since last report Can this temperature influence in the performance? Reimer

[PERFORM] Bad iostat numbers

de Channel B, SCSI Id=7, PCI 33 or 66Mhz, 512 SCBs ... Reimer

RES: [PERFORM] Priority to a mission critical transaction

ystem call affect i/o queue too? Reimer > -Mensagem original- > De: Jim C. Nasby [mailto:[EMAIL PROTECTED] > Enviada em: domingo, 26 de novembro de 2006 22:52 > Para: Brad Nicholson > Cc: [EMAIL PROTECTED]; pgsql-performance@postgresql.org > Assunto: Re: [PERFORM] Pr

[PERFORM] Priority to a mission critical transaction

Hi, We have an application that is mission critical, normally very fast, but when an I/O or CPU bound transaction appears, the mission critical application suffers. Is there a way go give some kind of priority to this kind of application? Reimer

RES: [PERFORM] Context switching

shows is 1 but when the problem occurs it goes to 25.   CPU and memory usage are ok.   What can produce this context switching storms?   It is a box with 12GB RAM and 4 processors running RedHat Enterprise Linux AS.   Thank you in advance! Reimer[EMAIL PROT

[PERFORM] Context switching

es to 25.   CPU and memory usage are ok.   What can produce this context switching storms?   It is a box with 12GB RAM and 4 processors running RedHat Enterprise Linux AS.   Thank you in advance! Reimer[EMAIL PROTECTED]OpenDB Serviços e Treinamentos PostgreSQL e DB2Fone: 47 3327-0878 Ce

Re: [PERFORM] Sequence Scan vs. Index scan

Fernando, If you need to read all the table for example it would be better to read only the data pages instead of read data and index pages. Reimer - Original Message - From: "Fernando Lujan" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 21, 2006 3:08 PM Subject: [P

Re: [PERFORM] Query Feromance

Marco, Could you give us the query you would like to improve performance? - Original Message - From: "Marco Furetto" <[EMAIL PROTECTED]> To: Sent: Monday, March 20, 2006 11:59 AM Subject: [PERFORM] Query Feromance Hello! Can I Increment the perfomance of execution query? Where i

Re: [PERFORM] firebird X postgresql 8.1.2 windows, performance comparison

Andre,   Could not Postgresql file cache being killed by firebird activity?Haven´t you tried decrease ramdom_page_cost to 3 or 2?It would be better if only one person will make configuration changes, otherwise it will be difficult to measure each configuration change impact.ReimerAndre Felipe Mac

Re: [PERFORM] firebird X postgresql 8.1.2 windows, performance comparison

Andre,   I noticed that enable_bitmapscan and enable_seqscan are off, is there a reason for it? Have you tried with enable_bitmapscan on?   How much RAM do you have? What kind of disks are being used?   Beste regards,   Reimer 55-47-33270878 Blumenau - SC - Brazil andremachado <[EM

[PERFORM] log_duration times

seconds than making changes in database structure or SQL syntax.   How could I discover who is using the 7 remaining seconds? Network? ODBC? Application?   Thanks in advance!   Reimer    __Converse com seus amigos em tempo real com o Yahoo! Messenger

[PERFORM] Swapping

Hi,   I´m trying to tune a linux box with a 12 GB database and 4 GB RAM. First of all I would like to stop the swapping, so the shared_buffers and sort_mem were decreased but even so it started swapping two hours after DBMS started up.   I would like to know some suggestions how to discover why is

Re: [PERFORM] shared buffers

I forgot to say that it´s a 12GB database...   Ok, I´ll set shared buffers to 30.000 pages but even so "meminfo" and "top" shouldn´t show some shared pages?   I heard something about that Redhat 9 can´t handle very well RAM higher than 2GB. Is it right? Thanks in advance!

[PERFORM] shared buffers

Hi,   I´ve configured postgresql to use 1GB of shared buffers but meminfo and "top" are indicanting 0 shared buffers page. Why?   It´s a Linux Redhat 9 box with 4GB RAM and postgresql 7.3.   Thanks in advance!   Reimer Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!