Re: big database performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

	I do large databases in Pg, like 300GB/day of new data.  Need a lot
more data on what you're having issues with.

That is big!

What sort of information do you need from me ?

Is your problem with performance database reads? writes? (insert/copy?) How many indicies do you have?

I think the problem is related to load. Everything is slow because there are way too many connections. So everything is making everything else slow. Not much detail, is it?

We have 345 indicies on the db.

--
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@xxxxxxxxxxxxxxxxxxxx
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux