On Apr 27, 7:37 pm, Jorge Godoy <[EMAIL PROTECTED]> wrote: > 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]> With phpPGadmin the database works fine although a bit slow, but many many times faster that python+postgre I dont believe now that the problem comes directly from the db. The truth is that i use big enough binary items, pdf's and big images are saved within the db, i know this is not a good practice and should better be saved as files and served with apache The thing is that i cant upgrade the database. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
