[Rt-devel] 3.4.0rc1 slow

Vivek Khera vivek at khera.org
Sun Jan 9 21:26:48 EST 2005

On Jan 7, 2005, at 5:59 PM, Jesse Vincent wrote:

>>    postgres[18131]: [6610-1] LOG:  duration: 881.154 ms  statement: 
>> SELECT id FROM Attachments WHERE oid = '3609306'
>>    From doing a bit of reading in the postgres docs, the oid should 
>> not
>>    be used for this type of thing - they can/will roll, which can lead
>>    to duplicates too.
> But not instantly. And the only time we're doing that is immediately
> after the insert.

also, there's no index on the oid's so it could result in a long table 
scan for a large attachments table.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2476 bytes
Desc: not available
Url : http://bestpractical.com/pipermail/rt-devel/attachments/20050109/1b4fcd0e/smime.bin

More information about the Rt-devel mailing list