"Diego Schvartzman" <dschvar@yahoo.com> writes:
> I have an application via PHP. For example, a SELECT query that must return
> one and only one row, with a where clause with and index (I droped it and
> created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
> 15 seconds.
Could be that 7.0 is less willing to use the index than 6.5 was. See
thread "indexes ingnored on simple query in 7.0" over in pgsql-sql for
ways to investigate the problem and one possible solution.
regards, tom lane