Re: timestamped archive data index searches - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamped archive data index searches
Date
Msg-id 14155.1026919928@sss.pgh.pa.us
Whole thread Raw
In response to Re: timestamped archive data index searches  ("Stephen Birch" <sgbirch@hotmail.com>)
List pgsql-general
"Stephen Birch" <sgbirch@hotmail.com> writes:
> The select is something like..
> SELECT AVG(x) FROM arch WHERE tstamp > :t

What *exactly* arrives at the backend when this is done?  (Turn on query
logging to find out.)

I'm suspicious that the problem is a datatype-mismatch issue and you
might need a cast.  But it's hard to tell without seeing the exact
query.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: table size growing out of control
Next
From: Robert Treat
Date:
Subject: Re: table size growing out of control