Re: terrible performance in 6.1beta4

Miguel

attached is my config file, shared_buffers are 25% of total RAM
im guessing that this is a disk controlled bug or something, when i
execute any query involving many rows, the server response is very low,
ssh, su, even copy or rename a file, cpu usage remains ~87% idle though

you are not inserting into an indexed table, are you?

regards,

usleep

---
Miguel
miguel


_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: terrible performance in 6.1beta4
    ... im guessing that this is a disk controlled bug or something, ... execute any query involving many rows, the server response is very low, ...
    (freebsd-questions)
  • Re: terrible performance in 6.1beta4
    ... execute any query involving many rows, the server response is very low, ... much faster than inserting 3G of data into an indexed ...
    (freebsd-questions)
  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)