Postgres Pro
Downloads
Home   >   mailing lists

Re: table configuration tweak for performance gain. - Mailing list pgsql-general

From Michael Fuhr
Subject Re: table configuration tweak for performance gain.
Date
Msg-id 20041117024526.GA45526@winnie.fuhr.org
Whole thread Raw
In response to Re: table configuration tweak for performance gain.  ("Harvey, Allan AC" <HarveyA@OneSteel.com>)
List pgsql-general
Tree view 
On Wed, Nov 17, 2004 at 12:41:20PM +1100, Harvey, Allan AC wrote:

> mill2=> explain analyse select count(*) from history where pointname = 'MILL2-SPEED' and dt > (now() - interval '5
minutes')::timestamp\g

How typical is this query?  How many distinct values does pointname
have?  Have you considered adding an index on pointname or a multicolumn
index on pointname and dt?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Harvey, Allan AC"
Date:
Subject: Re: table configuration tweak for performance gain.
Next
From: "Sim Zacks"
Date:
Subject: Re: PostGreSQL to Access Updatable recordset