They PGSQL-PERFORMANCE list is really the appropriate place for
performance issues like yours. Subscribe?
Josh,
Brian and I are trying to put upwards of 80-90,000 rows into a table.
When we run on PostgreSQL 7.4, this takes about five minutes. On
comparable hardware, running PostgreSQL 8.0.1, it
Josh Berkus writes:
> I don't think your experience on this one query is descriptive of PostgreSQL
> in general. What I'm saying is that you most likely have a tuning problem,
> not a bug.
It might be a bug (or at least an unhelpful behavior) but the given case
didn't prove a thing. I'm st
Brian,
> Yes, I will subscribe to the performance list, but strictly speaking the
> behaviour described should be considered a bug. The assumptions made in
> deciding what the query optimisations will be seem all skewed, and the
> end result is that the system
> isn't useful in very common cases.
Brian,
They PGSQL-PERFORMANCE list is really the appropriate place for performance
issues like yours. Subscribe?
http://www.postgresql.org/community/lists
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TI
