Re: load testing
От | Steve Wolfe |
---|---|
Тема | Re: load testing |
Дата | |
Msg-id | 012a01c406d4$c487bd00$88693fd1@WEASEL обсуждение исходный текст |
Ответ на | load testing ("Sally Sally" <dedeb17@hotmail.com>) |
Список | pgsql-general |
> I wanted to do some quick load testing on a postgres database. Does anyone > have any tips on how to go about doing this? > Thanks much. Sure. Test after the manner in which the database is normally used, and with "real-world" data. I've seen far too many people "benchmark" a database system by opening a single connection, and issuing a number of queries. However, it's more common for a database server to be handling multiple queries at the same time. Also, I've seen far too many people use contrived test data and contrived queries. However, the nature of queries may be very different from the actual queries you run. Test with what you use! For my own benchmarking, I usually log ~10,000 queries from our production server, and start a Perl script that I whipped up quickly. It will split the queries into chunks, and test with 1 through 10 simultaneous connections, and that's been a very good indicator of how the machine in question will behave once it's put into production. steve
В списке pgsql-general по дате отправления: