you find a better solution please let me know.
Neil Peter Braggio
[EMAIL PROTECTED]
On Tue, May 13, 2008 at 11:48 AM, Nikolas Everett <[EMAIL PROTECTED]> wrote:
> I figure this subject belongs on the performance mailing list because it is
> about partitioning, which is a perfo
Just cast the value in the WHERE clause:
select ts from mwdb.t_mv where zr=3622 and ts > '2006-01-01 00:00:00'
::TIMESTAMP order by ts asc limit 1;
This search only into the right partitioned tables if you build the rules
based in the ts field.
----
Neil Peter Braggio
[EMAIL PROT
