[PERFORM] poor performance in migrated database

2004-11-06 Thread Carlos Lopez
e time and wants to check the structure, I have a copy of everything at http://www.micredito.com.sv/.carlos/materiales.sql.bz2 it is a pgsqldump made with postgres 7.4 Thanks in advance for your help. Carlos Lopez Linares. = ___ Ing. Carlos López Linares IT Consultant Quieres aprender linux? v

Re: [ADMIN] [PERFORM] poor performance in migrated database

2004-11-08 Thread Carlos Lopez
ows=151607 loops=1) -> Seq Scan on docinvdrollos (cost=0.00..15220.39 rows=151607 width=423) (actual time=7.699..5109.468 rows=151607 loops=1) Total runtime: 38599.868 ms (17 filas) --- Simon Riggs <[EMAIL PROTECTED]> wrote: > On Sat, 2004-11-06 at 19

Re: [ADMIN] [PERFORM] poor performance in migrated database

2004-11-09 Thread Carlos Lopez
Dear Tom, thanks for your information. Where can I learn more about the explain and analyze?? One view that is giving a lot of problems is vkardex_3 which is used most of the time... The explain analyze I sent is one of the views that conform this one. Thanks in advance. Carlos Lopez Linares