Re: index on two tables or Howto speedup max/aggregate-function

[Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>]

On Tue, Oct 13, 2009 at 9:59 AM, Michael Schwipps <msc.listen@xxxxxxxxx> wrote:

Hi,

I want to select the last contact of person via mail.
My sample database is build with the following shell-commands

| createdb -U postgres test2
| psql -U postgres test2 < mail_db.sql
| mailtest.sh | psql -U postgres

I call to get the answer

| SELECT address, max(sent) from mail inner join
| tomail on (mail.id=tomail.mail) group by address;

you are missing vacuumdb -z test2
after mailtest.sh ..
 

-- 
GJ