On 6/22/06, Rod Taylor <[EMAIL PROTECTED]> wrote:
If you INSERT into multiple partitions (by time -- say one per minute) and TRUNCATE periodically (30 minute old partitions for 30 minute expiry) it works much better. Expiring the session is quite fast as well since they'll go away with the truncate.
Forgive me if this sounds rude because I'm not meaning it as such, but this suggestion sounds like a MySQL-ish hack. No doubt it would work, but should an application-writer have to incur the cost of writing something different because the database can't handle it? I remember having to write subselect code in PHP because MySQL couldn't do it... not what I would call a *solution* by any mean. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
