Re: [PERFORM] queries on huge tables

2005-03-19 Thread Mike Rylander
The most recent version of this thread starts here: http://archives.postgresql.org/pgsql-general/2005-03/msg00321.php . Search the archives for "table partition", "union view" and "partition inherits" and you should find most relevant discussions. Hope that helps! On Thu, 17 Mar 2005 15:01:43 +

[PERFORM] queries on huge tables

2005-03-17 Thread Lending, Rune
Title: Melding Hello all.   I am having a couple of tables with couple of hundre millions records in them. The tables contains a timestamp column. I am almost always interested in getting datas from a specific day or month. Each day contains aprox. 400.000 entries.   When I do such querie