Disclaimer: No knowledge beyond tweaking ... This is the variable that you want to modify to improve performances if you're using PostGres. You'll have to be root on Linux because you'll have to modify some Linux runtime params too (shared memory).
shared_buffers = (BIG number) 80000 - Benjamin On Fri, Feb 27, 2009 at 3:42 AM, Matej <matej.pun...@gmail.com> wrote: > > I agree with Clifford. > I was able to speed up my postgresql database by 200% just by changing > configurations how much memory database can use. > > On Feb 27, 9:11 am, CLIFFORD ILKAY <clifford_il...@dinamis.com> wrote: > > Sean wrote: > > > Anyone have any suggestion how can I make this process faster, or > > > there is any other superfast database engine than MySql? > > > > We've found bulk loading data into PostgreSQL significantly faster. Come > > to think of it, we've found just about everything about PostgreSQL to be > > faster than MySQL. The beauty of Django is that unless you've written > > custom SQL, you're a syncdb away from seeing for yourself. Either way, > > in case you haven't changed them, the default configurations for both > > databases are for low-resource machines and definitely aren't built for > > speed. > > -- > > Regards, > > > > Clifford Ilkay > > Dinamis > > 1419-3266 Yonge St. > > Toronto, ON > > Canada M4N 3P6 > > > > <http://dinamis.com> > > +1 416-410-3326 > > > > smime.p7s > > 4KViewDownload > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
