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;
> 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:

Reply via email to