On Thu, 22 Jun 2006, Jonah H. Harris wrote:
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.
AFAICS, you could hide it from the application with update rules and
views.
- Heikki
---------------------------(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
