Postgres Pro
Downloads
Home   >   mailing lists

Re: very very slow ..... - Mailing list pgsql-sql

From Tom Lane
Subject Re: very very slow .....
Date
Msg-id 24899.986260747@sss.pgh.pa.us
Whole thread Raw
In response to very very slow .....  ("J.Fernando Moyano" <txinete@wanadoo.es>)
List pgsql-sql
Tree view 
"J.Fernando Moyano" <txinete@wanadoo.es> writes:
> The execution time of certain queries is 20 or 30 times longer in 7.0.2 that 
> 6.5. (20 or 30 seconds where before it was 1 or 2 seconds !!!)

Have you done a VACUUM ANALYZE?

Other than that, there's no generic advice.  You'll need to provide some
details about the problem queries and the plans you get for them in 6.5
and 7.0.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: using for rec inside a function: behavior very slow
Next
From: "Gerald Gutierrez"
Date:
Subject: Appropriate indices to create for these queries