On Apr 18, 2005, at 01:20, Mikaël Cluseau wrote:
> Here is the method I use to get the same behaviour. I use two queries
> but it is still faster (in fact, .3 seconds for the request on primary
> keys and 1.4 to get the full rows from the PKs, I don't really
> understand why it is that slow
Have you tried with PostgreSQL explain analyze? It should display what
PostgreSQL are using its cpu time on.
http://www.postgresql.org/docs/current/static/sql-explain.html
- Tore.
This archive was generated by hypermail 2.0.0 : Mon Apr 18 2005 - 01:59:15 EDT