Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Tried on two machines. The first (Turion64 laptop) gives 44-45 ms for
> > the SELECT, and 50-51 ms for the EXPLAIN ANALYZE.
>
> > The second machine, desktop Celeron 533, gives 197-200 ms for the SELECT
> > and 788-790 for the EXPLAIN ANALYZE. I guess this is the reproduction
> > you were looking for.
>
> Do you have oprofile installed on these? Comparing oprofile results
> might give some more insight where the time is going.
No, I don't. I'll have a look.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support