From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 9.1 : why is this query slow?
Date: Mon, 28 Nov 2011 11:05:20 -0600
Message-ID: <4ED36AF0020000250004354F@gw.wicourts.gov> (raw)
In-Reply-To: <1322499469.3343.25.camel@panoramix.Askesis.nl>
References: <1322498526.3343.22.camel@panoramix.Askesis.nl>
<1322499469.3343.25.camel@panoramix.Askesis.nl>
Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> wrote:
> This query goes faster (6224 ms, but I am not sure it gives the
> correct answer as the result differs from my Java program):
It seems clear that you want to see words which appear with all
three types of files, but it's not clear what you want the count to
represent. The number of times the word appears in filetype 'n'
references (as specified in your second query)? The number of
permutations of documents which incorporate one 'f' document, one
's' document, and one 'n' document (as specified in your first
query). Something else, like the total number of times the word
appears?
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, J.Kraaijeveld@Askesis.nl
Subject: Re: PostgreSQL 9.1 : why is this query slow?
In-Reply-To: <4ED36AF0020000250004354F@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox