Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
an explain analyze below and would appreciate any pointers to gaps in
my understanding.
In response to Jake Stride :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
Increase work_mem to force sort in memory.
Andreas
--
Hello,
Le 29/07/09 13:46, Jake Stride a écrit :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've included
an explain analyze below and would
2009/7/29 A. Kretschmer andreas.kretsch...@schollglas.com:
In response to Jake Stride :
Hi,
I'm trying to optimise a query at the moment, I've added some new
indexes to stop seq scans, but I'm now trying to work out if I can
stop a join using external sort to speed up the query. I've
Thanks I'll take a look into it - they query you provide seems to take
longer in the query plan but I can see where you are coming from and
it's good base to work from.
Jake
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription: