Re: very very slow .....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: very very slow .....
Date: 2001-04-03 01:19:07
Message-ID: 24899.986260747@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"J.Fernando Moyano" <txinete(at)wanadoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gerald Gutierrez 2001-04-03 01:49:44 Appropriate indices to create for these queries
Previous Message Tom Lane 2001-04-03 01:16:56 Re: using for rec inside a function: behavior very slow