| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow query performance on large table |
| Date: | 2003-03-04 15:15:29 |
| Message-ID: | 20030304101529.D32416@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Mar 04, 2003 at 02:45:18PM -0000, Paul McKay wrote:
>
> Select time,value
>
> >From measurement
>
> Where assessment = ?
>
> And time between ? and ?
>
Please run this with EXPLAIN ANALYSE with values that slow the query
down. By bet is that you have an index which needs wider statistics
setting on the column to be useful, but without the output from
EXAPLIN ANALYSE it'll be hard to tell.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul McKay | 2003-03-04 16:11:20 | Re: Slow query performance on large table |
| Previous Message | Tom Lane | 2003-03-04 15:13:01 | Re: Slow query performance on large table |