Skip site navigation (1) Skip section navigation (2)

Re: Query to slow

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info>
Cc: Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Query to slow
Date: 2003-08-25 13:21:52
Message-ID: 1061817712.3390.212.camel@camel (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, 2003-08-25 at 08:17, Rhaoni Chiu Pereira wrote:
> Hi List,
> 
>      As I said before, I'm not a DBA " yet" , but I'm learning ... and I 
> already have a PostgreSQL running, so I have to ask some help...
>       I got a SQL as folows :
>  
<snip>
> 
> I have created the decode, NVL and DIVIDE functions.... the problem is that the 
> where condition makes this query to slow ( about 4 min ) and the same query in 
> my Oracle database 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 
> faster ?
> 

Make sure you have run vacuum analyze on your database, if it is still
slow post "explain analyze <query>" to pgsql-performance mailing list

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2003-08-25 13:35:15
Subject: Re: postgres hab modification without restarting
Previous:From: Hornyak LaszloDate: 2003-08-25 13:15:44
Subject: postgres hab modification without restarting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group