| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rodrigo Rosenfeld Rosas <rr(dot)rosas(at)gmail(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 |
| Date: | 2012-11-06 19:45:05 |
| Message-ID: | 18371.1352231105@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Rodrigo Rosenfeld Rosas <rr(dot)rosas(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Praus | 2012-11-06 20:08:48 | Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries |
| Previous Message | Gunnar "Nick" Bluth | 2012-11-06 19:38:46 | Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries |