[Rt-devel] 3.4.0rc1 slow

[Vivek Khera]

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