Markus Schiltknecht wrote:
Hi,
Heikki Linnakangas wrote:
There's clearly something wrong. The response times are ridiculously
high, they should be < 5 seconds (except for stock level transaction)
to pass a TPC-C test. I wonder if you built any indexes at all?
Hm.. according to the output/5/db/plan0.out, all queries use index
scans, so that doesn't seem to be the problem.
I still suspect there's something wrong with plans, I doubt you can get
that bad performance unless it's doing something really stupid. I'd
suggest setting log_min_duration_statement = 5000, and seeing what you
get. Also check pg_stat_user_table.seq_scan just to be extra sure
there's no seq scans.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
