I think we need to build up a library of autogenerated queries, so we
can do things which address multiple use cases. Can you tell us more
about who/what generated it, so we can research?
Sorry, I can't publish a lot of information, that is on of the biggest russian
software company, it trie
2007/9/6, Simon Riggs <[EMAIL PROTECTED]>:
> The query formulation does seem a fairly common one.
>
> > First query:
> > explain analyze
> > select *
> > from
> > a
> > left outer join (
> > select b.id, sum(b.val)
> > from b
> > group by b.id
> > ) bagg
>
On Wed, 2007-09-05 at 20:11 +0400, Teodor Sigaev wrote:
> I found two queries which do the same thing but they is very different in
> time.
> For test suite it's about 10^3 times, but on real data it can be 10^5 times.
> It's observed on 8.1-current, 8.2-current and CVS HEAD versions. Interesti
