Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux