Re: Hash join on int takes 8..114 seconds

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-performance(at)postgresql(dot)org>, "PFC" <lists(at)peufeu(dot)com>
Subject: Re: Hash join on int takes 8..114 seconds
Date: 2008-11-20 09:12:17
Message-ID: A0AC546AB1044B089C47970B6AB4A828@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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
summed.

Andrus.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2008-11-20 10:45:53 Re: Hash join on int takes 8..114 seconds
Previous Message Greg Smith 2008-11-20 05:04:31 Re: Very Urgent : Sequences Problem