Re: join ordering via Simulated Annealing - Mailing list pgsql-hackers

From Jan Urbański
Subject Re: join ordering via Simulated Annealing
Date
Msg-id 4B38A0DE.6040002@wulczer.org
Whole thread Raw
In response to Re: join ordering via Simulated Annealing  (Andres Freund <andres@anarazel.de>)
List 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.43411.andres@anarazel.de
> which tom analyzed and improved here http://archives.postgresql.org/message-
> id/17807.1247932094@sss.pgh.pa.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@mail.gmail.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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Streaming Rep - 2-phase backups and reducing time to full replication
Next
From: Heikki Linnakangas
Date:
Subject: Re: updateMinRecoveryPoint bug?