[PERFORM] Query Performance

2004-08-20 Thread Danilo Mota
.   Danilo Mota       SELECT     sn.notafiscalnumero,     sn.notafiscalserie,     CASE sn.notafiscaldata WHEN '' THEN NULL ELSE to_date(sn.notafiscaldata,'MMDD') END,  

[PERFORM] Query performance problem

2004-08-20 Thread Danilo Mota
      POSTGRESQL.CONF -- ### VERSION: Postgresql 7.4.2 ### shared_buffers = 7800 sort_mem = 4096 checkpoint_segments = 5  effective_cache_size = 12000 cpu_operator_cost = 0.0015 stats_start_collector = false     Hope you can help me, I really need to get this running faster, and I am out of ideas.   Since now, thanks a lot for your attention,   Danilo Mota