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 cons
706.179 ms
(4 rows)
> -Original Message-
> From: Michael Fuhr [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 17 November 2004 12:19
> To: Harvey, Allan AC
> Cc: Tom Lane
> Subject: Re: [GENERAL] table configuration tweak for performance gain.
>
>
> On Wed, Nov
On Tue, Nov 16, 2004 at 10:39:10AM +1100, Harvey, Allan AC wrote:
> mill2=> explain select value from history where pointname = 'MILL2-SPEED' and
> dt < now() - interval '5 minutes'\g
We were looking for the output from "explain analyze select "
With EXPLAIN ANALYZE we can see how realistic
85606.9
85606.9
85606.9
85606.9
85606.9
85606.9
etc.
I have obviously used it wrong but cannot see how/why.
Thanks again.
Allan
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 16 November 2004 2:26
> To: Michael Fuhr
> Cc: Harvey, Al
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote:
>> I created an index on the dt column, ran ANALYSE then,
>> EXPLAIN for some queries.
>> The returned plan was always sequential search.
> Could you post a query and the EXPLAIN ANALYZE ou
On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote:
> The table in question has several thousand rows currently,
> planning several million, it has a date time stamp column.
> All selects will be on ranges of the date time column.
>
> I created an index on the dt column, ran ANALYSE
Hi all,
I was hoping someone might be able to set me straight
so that I can get some select performance improvements.
The table in question has several thousand rows currently,
planning several million, it has a date time stamp column.
All selects will be on ranges of the date time column.
I crea
