lokki <[EMAIL PROTECTED]> writes: > Correcting. > > the high cpu usage and latency relates to Postgres7.3.9 'bytea' or as > declared in sqlobject BLOBCol. Whenever i try to fetch a record that > contain's binary data the proccess hits 50% and dosent drop. > > the problem is that am not familiar with psycopg so that i would > test... > > Is it Postgres7.3.9 i havent found any problems with it at mailing > list or google. > Or maybe psycopg2. > > Pls if someone gets same problems help me
PostgreSQL 7.3.9 is *old*. There were huge improvements in several areas and I strongly recommend that you update to, at least, 7.4.9... If you can go to 8.2.4 it is even better. With regards to problems with binary objects inside PostgreSQL, I don't have them. But my objects aren't too big for the one app I'm monitoring here. What happens when you work directly with the database, without using Python or psycopg? -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
