Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve Query - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Improve Query
Date
Msg-id 2f4958ff0905270825r6e972ba1w8d7ca991f5294d90@mail.gmail.com
Whole thread Raw
In response to Improve Query  (Zach Calvert <zachcalvert@hemerasoftware.com>)
List pgsql-performance
Tree view 
try creating index on all three columns.
Btw, 38ms is pretty fast. If you run that query very often, do prepare
it, cos I reckon it takes few ms to actually create plan for it.

pgsql-performance by date:

Previous
From: Zach Calvert
Date:
Subject: Improve Query
Next
From: David Wall
Date:
Subject: Re: Hosted servers with good DB disk performance?