Re: [Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-19 Thread Geo Carncross
On Sat, 2005-12-17 at 17:59 +0100, Thomas Mueller wrote: > > With a mime message like this: > > > > --b1 > > text > > --b1 > > rfc822 > > --b2 > > text > > --b2-- > > --b1-- > > > > Perhaps a parts layout similar to this: > > > > part,pre_boundary, content, encoding, post_boundary > > '1', 'b1',

[Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-17 Thread Thomas Mueller
Geo Carncross wrote: > On Thu, 2005-12-15 at 17:35 +0100, Thomas Mueller wrote: >>Geo Carncross wrote: >> >>>I completely agree with this. There's just the problem of databases >>>being a moving target. Remember we talked about COUNT(*) not being >>>optimally implemented in Pg, but one day it could

Re: [Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-15 Thread Geo Carncross
On Thu, 2005-12-15 at 09:50 -0800, Kevin Brown wrote: > > I mean, does it apply specifically to COUNT(*)? I checked the release > > notes and I couldn't find mention of it... > > If you're looking to find the total size of a table, no. In > PostgreSQL, that's a Fundamentally Hard Problem because

Re: [Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-15 Thread Kevin Brown
Geo Carncross wrote: > On Thu, 2005-12-15 at 17:35 +0100, Thomas Mueller wrote: > > Geo Carncross wrote: > > > > > I completely agree with this. There's just the problem of databases > > > being a moving target. Remember we talked about COUNT(*) not being > > > optimally implemented in Pg, but one

Re: [Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-15 Thread Geo Carncross
On Thu, 2005-12-15 at 17:35 +0100, Thomas Mueller wrote: > Geo Carncross wrote: > > > I completely agree with this. There's just the problem of databases > > being a moving target. Remember we talked about COUNT(*) not being > > optimally implemented in Pg, but one day it could be, and at that poi

[Dbmail-dev] Re: STORE is SLOOOOOW on folder with many, many messages

2005-12-15 Thread Thomas Mueller
Geo Carncross wrote: > I completely agree with this. There's just the problem of databases > being a moving target. Remember we talked about COUNT(*) not being > optimally implemented in Pg, but one day it could be, and at that point, > we should use COUNT(*) - even if it's slower on older databas