Tom Lane írta: > Boszormenyi Zoltan <[email protected]> writes: > >> This means add_child_rel_equivalences() is still takes >> too much time, the previously posted test case calls this >> function 482 times, it's called for almost every 10th entry >> added to eq_classes. The elog() I put into this function says >> that at the last call list_length(eq_classes) == 4754. >> > > That seems like a ridiculously large number of ECs. What is the > test query again? > > regards, tom lane >
The test case is here: http://archives.postgresql.org/message-id/[email protected] create_table.sql for the main table plus childtables.sql.gz, the EXPLAIN query is in the message body. Basically, it's a model for a lot of data for three months, partitioned by 4 hour intervals for every day. Imagine the call list handled by a phone company in a large country. Best regards, Zoltán Böszörményi -- ---------------------------------- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de http://www.postgresql.at/ -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
