cant seem to post the explain

От: Joel Fradkin
Тема: cant seem to post the explain
Дата: ,
Msg-id: 006e01c55d76$4adf27f0$797ba8c0@jfradkin
(см: обсуждение, исходный текст)
Список: pgsql-performance

Sorry I tried a few times to break this email up (guess there must be a size limit?).

Any one interested in seeing the explain for the speed of many group by’s question just email me.

 

Basically the sql is built by a dynamic cube product from data dynamics.

I can edit it prior to it running, but it runs very slow even off the flattened file.

I am guessing the product needs the data from the sql I supplied in previous post.

 

I don’t have any ideas to speed it up as I cant store an aggregate flat table without updating it when updates and inserts are made and that would be too time consuming.

Any ideas for how to approach getting the same data set in a faster manner are greatly appreciated.

 

Joel Fradkin

 

 


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Tuning planner cost estimates
От: Alex Stapleton
Дата:
Сообщение: Re: Optimizing for writes. Data integrity not critical