From: | Jan Urbański <wulczer(at)wulczer(dot)org> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: join ordering via Simulated Annealing |
Date: | 2009-12-28 12:13:18 |
Message-ID: | 4B38A0DE.6040002@wulczer.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Andres Freund wrote:
> On Wednesday 23 December 2009 02:23:55 Jan Urbański wrote:
>> Lastly, I'm lacking good testcases
> If you want to see some queries which are rather hard to plan with random
> search you can look at
> http://archives.postgresql.org/message-
> id/200907091700(dot)43411(dot)andres(at)anarazel(dot)de
> which tom analyzed and improved here http://archives.postgresql.org/message-
> id/17807(dot)1247932094(at)sss(dot)pgh(dot)pa(dot)us
Thanks, these look like good testing candidates, not least because they
trigger assertion errors with my code :( I'll report back when they're
fixed...
> Robert had another example in
> 603c8f070911271205r4d4534edt1cebcb76ff5066a5(at)mail(dot)gmail(dot)com that might be
> interesting.
Yes, I rememberd this one, will try to put them through the mill as soon
as I fix my code.
Cheers,
Jan
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2009-12-28 12:40:56 | Re: updateMinRecoveryPoint bug? |
Previous Message | Simon Riggs | 2009-12-28 10:55:50 | Re: Streaming Rep - 2-phase backups and reducing time to full replication |