Re: [GENERAL] Performance

[Tom Lane]

"Diego Schvartzman" <[EMAIL PROTECTED]> 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