Sean Woolcock wrote:
> I have a large (3 million row) table called "tape" that represents
files,
> which I join to a small (100 row) table called "filesystem" that
represents
> filesystems. I have a web interface that allows you to sort by a
number of
> fields in the tape table and
Woolcock, Sean wrote:
> A description of what you are trying to achieve and what results
> you expect:
> I have a large (3 million row) table called "tape" that represents
> files, which I join to a small (100 row) table called "filesystem"
> that represents filesystems. I have a web interface
mance@postgresql.org
Subject: Re: [PERFORM] Request for help with slow query
As shaun has indicated, there is no need for join, also as Joshua suggested, it
is good to upgrade your server. also add indexes for your predicates and
foreign keys and you will get a desired result.
Re
quot;
Cc: "pgsql-performance@postgresql.org"
Sent: Monday, October 29, 2012 8:36 PM
Subject: Re: [PERFORM] Request for help with slow query
On 10/29/2012 12:41 PM, Woolcock, Sean wrote:
> An example query that's running slowly for me is:
>
On 10/29/2012 12:41 PM, Woolcock, Sean wrote:
An example query that's running slowly for me is:
select tape.volser,
tape.path,
tape.scratched,
tape.size,
extract(epoch from tape.last_write_date) as last_write_date,
On 10/29/2012 12:25 PM, Woolcock, Sean wrote:
I thought that an index was implicitly created for foreign keys, but I see that
that's not true. I've just created one now and re-ran the query but it did not
change the query plan or run time.
1. Explain analyze, not explain please
Check to se
.com]
Sent: Monday, October 29, 2012 3:18 PM
To: Woolcock, Sean; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Request for help with slow query
Did you try to add an index on filesystem_id
From: "Woolcock, Sean"
To: "pgsql-performance@post
Did you try to add an index on filesystem_id
From: "Woolcock, Sean"
To: "pgsql-performance@postgresql.org"
Sent: Monday, October 29, 2012 6:41 PM
Subject: [PERFORM] Request for help with slow query
Hi, thanks for any help. I've
Hi, thanks for any help. I've tried to be thorough, but let me know if I should
provide more information.
A description of what you are trying to achieve and what results you expect:
I have a large (3 million row) table called "tape" that represents files,
which I join to a small (100 row)