supposedly
the server rack can't.
On Fri, Jul 28, 2023 at 4:50 PM Ron wrote:
> On 7/28/23 07:20, Gert Cuykens wrote:
>
> Hi, I would like to pgbench the production postgres that is being physical
> replicated to a slave. Will I shoot myself in the foot because of the
> physical
On 7/28/23 07:20, Gert Cuykens wrote:
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Replication or not, why are you running pgbench
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Thanks
Dear Tom!
Tom Lane ezt írta (időpont: 2020. júl. 20., H, 15:38):
>
> There are -j threads in the pgbench process, and -c connections to
> the server (hence -c backend processes on the server side). Each
> of the pgbench threads is responsible for sending queries to a sub
round.
There are -j threads in the pgbench process, and -c connections to
the server (hence -c backend processes on the server side). Each
of the pgbench threads is responsible for sending queries to a subset
of the connections. Setting -j more than -c is useless (I forget
if it's actually an
allel performance tests.
Durumdara ezt írta (időpont: 2020. júl. 20., H,
15:20):
> Dear Members!
>
>
> I have a question about PGBench for Windows (9,6).
>
> I want to understand the working method of this tool for use well
> in the test series.
>
> This has more options, like
Dear Members!
I have a question about PGBench for Windows (9,6).
I want to understand the working method of this tool for use well
in the test series.
This has more options, like connections (c).
As I tried the c controls how much concurrent connections must be used in
the test. For example c
Hi,
We're wondering why pgbench behaves this way by default:
"With neither -n nor -v,
pgbench will vacuum the pgbench_tellers and pgbench_branches tables, and
will truncate pgbench_history."
Why pgbench_accounts not vacuumed by default?
I've dug the history of pgbench until
by spending efforts to do that.
The patches change the name of "parseQuery" to "makeVariablesParameters",
because it was not actually parsing any query. Maybe the new name could be
improved.
In passing, there was a bug in how NULL was passed, which I tried to fix
as
Thanks for your analysis.
Regards
El mié., 24 jun. 2020 a las 17:17, Tom Lane () escribió:
> I wrote:
> > David Rowley writes:
> >> I don't often do much with pgbench and variables, but there are a few
> >> things that surprise me here.
> >> 1) That
I'll look into it. Thanks for the analysis and CC-ing.
--
Fabien.
I wrote:
> David Rowley writes:
>> I don't often do much with pgbench and variables, but there are a few
>> things that surprise me here.
>> 1) That pgbench replaces variables within single quotes, and;
>> 2) that we still think it's a variable name when
David Rowley writes:
> On Wed, 24 Jun 2020 at 20:41, Jaime Soler wrote:
>> I don't know why pgbench use timestamp: «2006-03-01 00$1$2» instead of
>> timestamp '2006-03-01 00:00:00'
> I've not debugged it, but it looks like pgbench thinks that :00 is a
&g
Hi,
Thanks for your comments, I worked around that problem because I was able
to truncate the timestamp and use only the date part , alsoit might
works the use of to_timestamp. But I would like to understand what is
happening , I realized that pgbench is identified erroneously the minutes
and
On Wed, 24 Jun 2020 at 20:41, Jaime Soler wrote:
>
> Hi, does anybody know what is wrong with pgbench in this case ?. Here is a
> simple query to generate a random date in a interval time.sql:
>
> (select timestamp '2005-09-01' + random() * ( timestamp '2006-0
Hi, does anybody know what is wrong with pgbench in this case ?. Here is a
simple query to generate a random date in a interval time.sql:
(select timestamp '2005-09-01' + random() * ( timestamp '2006-03-01
00:00:00' - timestamp '2005-09-01 00:00:00' ));
query ex
e database:
% pgbench -i -s 300 -F 100 --foreign-keys --unlogged-tables -h
127.0.0.1 -U luca pgbench
Then the test I ran, six time after a restart between a batch and the other:
% pgbench -T 720 -j 4 -c 4 -h 127.0.0.1 -U luca pgbench
The average tps results always around 795, so I believe in th
gt;> (which started before your pgbench test was launched). That is less likely
>> to happen with a value of 0.1
>
> Uhm...but in the logged table tests a value of 0.9 increases the tps,
> that as far as I understand is in contrast with what you are stating.
What I stated is va
such environment.
> Assuming that the 'background activity' writes data, a value of
> (checkpoint_completion_target) 0.9 means that when your test starts, the
> system might be still busy in writing data from the previous checkpoint
> (which started before your pgben
Hi Luca
(I tried to reproduce your tests, but I got similar results over different
checkpoint_completion_target)
The rest is in line here below:
On 12/07/2019 12:04, Luca Ferrari wrote:
>
> shared_buffers = 1 GB
> checkpoint_timeout = 5 min
>
> I've created a pgbench
On Fri, Jul 12, 2019 at 12:04 PM Luca Ferrari wrote:
> Since tables are unlogged, I was expecting no much difference in
> setting checkpoint_completion_target, but I got (average results):
> - checkpoint_completion_target = 0.1 ==> 755 tps
> - checkpoint_completation_target = 0.5 ==> 767 tps
> -
linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-28), 64-bit
shared_buffers = 1 GB
checkpoint_timeout = 5 min
I've created a pgbench database as follows (around 4.5 GB):
% pgbench -i -s 300 -F 100 --foreign-keys --unlogged-tables -h
127.0.0.1 -U luca pgbench
and I've tes
r and one hot standby, running on the same
VM and on the same Postgres.
I performed 2 different kind of tests. One using pgbench and another manually
generating data. But there is something I do not understand when it comes to
draw conclusions.Therefore I would appreciate yourhelp.
=Test 1=
I c
On 15/12/2017 23:18, John R Pierce wrote:
On 12/15/2017 7:37 AM, Olga Lytvynova-Bogdanova wrote:
Is there a way to integrate pgbench with TeamCity? If yes, could you share very
briefly how to do this?
I would suspect this is a question for TeamCity, not for postgresql. I don't even
On 12/15/2017 7:37 AM, Olga Lytvynova-Bogdanova wrote:
Is there a way to integrate pgbench with TeamCity? If yes, could you
share very briefly how to do this?
I would suspect this is a question for TeamCity, not for postgresql. I
don't even know what TeamCity actually is (google
Hello,
Is there a way to integrate pgbench with TeamCity? If yes, could you share
very briefly how to do this?
Which volumes of data does pgbench support?
Much appreciated for the attention.
26 matches
Mail list logo
