Home > mailing lists

Pl. help: cost of query plans in geqo - Mailing list pgsql-general

From	Ms swati chande
Subject	Pl. help: cost of query plans in geqo
Date	July 26, 2009 08:03:52
Msg-id	932443.74144.qm@web112607.mail.gq1.yahoo.com Whole thread Raw
List	pgsql-general

Hi,

I have a query with 20 relations, the GEQO is used to solve this query.

When the value of

pool->data[i].worth

was displayed, from random_init_pool() [geqo_pool.c], exactly the same value was obtained for all individuals.

Also when the value of pool->data[i].worth was printed from geqo_main.c, the same value was obtained for all the 250 individuals.

Do all plans have the same fitness?!

Please help me understand this.

Thanks

Regards

Swati

From: Scott Marlowe
Date: 26 July 2009, 02:40:51
Subject: Re: where is pg_resetxlog ?

From: tomrevam
Date: 26 July 2009, 10:07:52
Subject: Re: synchronous_commit=off doesn't always return immediately