2010/9/3 PostgreSQL - Hans-Jürgen Schönig <postg...@cybertec.at>: > i tried this one with 5000 unindexed tables (just one col): > > test=# \timing > Timing is on. > test=# prepare x(int4) AS select * from t_data order by id desc; > PREPARE > Time: 361.552 ms > > you will see similar or higher runtimes in case of 500 partitions and a > handful of indexes.
I'd like to see (1) a script to reproduce your test environment (as Stephen also requested) and (2) gprof or oprofile results. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
