Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group