On Tue, Nov 6, 2012 at 1:45 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Rodrigo Rosenfeld Rosas <rr.rosas@xxxxxxxxx> writes: >> Em 06-11-2012 17:24, Tom Lane escreveu: >>> Can you put together a self-contained test case to duplicate these >>> results? I'm prepared to believe there's some sort of planner >>> regression involved here, but we'll never find it without a test case. > >> I'd love to, but I'm afraid I won't have time to do this any time soon. >> Maybe on Sunday. I'll see if I can get a script to generate the database >> on Sunday and hope for it to replicate the issue. > >> Would you mind if I coded it using Ruby? (can you run Ruby code in your >> computer?) I mean, for filling with some sample data. > > No objection. hm, wouldn't timing the time to generate a raw EXPLAIN (that is, without ANALYZE) give a rough estimate of planning time? better to rule it out before OP goes to the trouble... merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
