Re: [HACKERS] Monster query

[Jan Urbański]

On 24/10/11 19:16, Omar Bettin wrote:
> Hi,
> 
> Since the data are of third parties, will prepare a database suitable for the 
> purpose.
> In any case, the compressed backup will be around 20 MB.

If you are able to prepare a database dump that doesn't contain private
data, it would be awesome.

If it's 20 MB please just post a link to the archive.

Thank you very much!
Jan

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

[HACKERS] Monster query

[Omar Bettin]

Hi,

Since the data are of third parties, will prepare a database suitable for the 
purpose.
In any case, the compressed backup will be around 20 MB.

Regards,

Omar Bettin


-Messaggio originale-
Da: Jan Urbański [mailto:wulc...@wulczer.org] 
Inviato: lunedì 24 ottobre 2011 18:56
A: Omar Bettin
Cc: pgsql-hackers@postgresql.org
Oggetto: Re: [HACKERS] [9.1] unusable for large views

On 24/10/11 10:57, Omar Bettin wrote:
> 
> [monster query]

I see that your problem is already solved, but incidentially I'm working on a 
join order planning module and I'm looking for real-life examples of humongous 
queries like that to benchmark against them.

Any chance you could share the schema, or at least part of it, that goes with 
this query? Or perhaps you have more of these queries?

Cheers,
Jan


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