Re: Best way to load test a postgresql server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Best way to load test a postgresql server
Дата
Msg-id 17341.1244555610@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Best way to load test a postgresql server  (Shaul Dar <shauldar@gmail.com>)
Ответы Re: Best way to load test a postgresql server  (Erik Aronesty <erik@q32.com>)
Список pgsql-performance
Shaul Dar <shauldar@gmail.com> writes:
> Have you actually run pgbench against your own schema? Can you point me to
> an example? I also had the same impression reading the documentation. But
> when I tried it with the proper flags to use my own DB and query file I got
> an error that it couldn't find one of the tables mentioned in the built-in
> test! I concluded that I cannot use any schema,

No, you just need to read the documentation.  There's a switch that
prevents the default action of trying to vacuum the "standard" tables.
I think -N, but too lazy to look ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Shaul Dar
Дата:
Сообщение: Re: Best way to load test a postgresql server
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problems with autovacuum