| From: | Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | INSERT - UPDATE throughput oscillating and SSD activity after stopping the client |
| Date: | 2016-12-02 17:40:14 |
| Message-ID: | CAK77FCTVTyCNn=8CZbZUMDiWnZKyioFCJFzTY_ZiywSLCxEk-w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I've two tables, t1 and t2, both with one bigint id indexed field and one
256 char data field; t1 has always got 10000 row, while t2 is increasing as
explained in the following.
My pqlib client countinously updates one row in t1 (every time targeting a
different row) and inserts a new row in t2. All this in blocks of 1000
update-insert per commit, in order to get better performance.
Wal_method is fsync, fsync is on, attached my conf file.
I've a 3.8ghz laptop with evo SSD.
Performance is measured every two executed blocks and related to these
blocks.
Over the first few minutes performance is around 10Krow/s then it slowly
drops, over next few minutes to 4Krow/s, then it slowly returns high and so
on, like a wave.
I don't understand this behaviour. Is it normal? What does it depend on?
Also, when I stop the client I see the SSD light still heavily working. It
would last quite a while unless I stop the postgresql server, in this case
it suddenly stops. If I restart the server it remains off.
I'm wondering if it's normal. I'd like to be sure that my data are safe
once commited.
Regards
Pupillo
P.S.: I put this question in general questions as my concern is not if the
performance is high or not.
| Attachment | Content-Type | Size |
|---|---|---|
| postgresql.conf | application/octet-stream | 21.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabricio Pedroso Jorge | 2016-12-02 17:58:45 | Create DB ends with error "FATAL: Ident authentication failed for user "postgres"" |
| Previous Message | Alexis Woo | 2016-12-02 17:25:07 | Avoid sorting when doing an array_agg |