> Just a question, what are you doing with the 20.000 result rows ?
Those rows represent monthly sales data of one item.
They are used as following:
1. Detailed sales report for month. This report can browsed in screen for
montly sales and ordering analysis.
2. Total reports. In those reports, sum( sales), sum(quantity) is used to
get total sales in day, week, month, time for item and resulting rows are
In response to
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2008-11-20 10:45:53|
|Subject: Re: Hash join on int takes 8..114 seconds|
|Previous:||From: Greg Smith||Date: 2008-11-20 05:04:31|
|Subject: Re: Very Urgent : Sequences Problem|