Date: Tue, 13 Jun 2017 18:51:30 +0000 From: "Caza, Aaron" <Aaron.Caza@ca.weatherford.com> To: "freebsd-hackers@freebsd.org" <freebsd-hackers@freebsd.org> Subject: RE: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Message-ID: <12e95f4e7e814093b1e877d722316ae0@DM2PR58MB013.032d.mgd.msft.net> In-Reply-To: <20170613203615.ae6df0a1c94bffe1dc6745fc@yahoo.es> References: <a8523e8099404bd699525f8ff7763819@DM2PR58MB013.032d.mgd.msft.net> <CADyrUxNeRW_fKJzoc9zoZi3J-6L%2BtXnJuW3q_4cremUy7sP7fA@mail.gmail.com> <4410c303314a4d11832a8d248e0b53e1@DM2PR58MB013.032d.mgd.msft.net> <20170613203615.ae6df0a1c94bffe1dc6745fc@yahoo.es>
next in thread | previous in thread | raw e-mail | index | archive | help
In prior testing I completely removed PostgreSQL from the equation by creat= ing a 16GB random file on the pertinent ZFS filesystem and reading after re= boot and later after the performance degradation hits. Read performance go= es from ~865MB/s with 95-100% busy in gstat down to ~61MB/s with ~10% busy. It's not Postgres. -----Original Message----- From: owner-freebsd-hackers@freebsd.org [mailto:owner-freebsd-hackers@freeb= sd.org] On Behalf Of Eduardo Morras via freebsd-hackers Sent: Tuesday, June 13, 2017 12:36 PM To: freebsd-hackers@freebsd.org Subject: Re: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD perfo= rmance drop < 24 hours On Mon, 12 Jun 2017 04:50:44 +0000 "Caza, Aaron" <Aaron.Caza@ca.weatherford.com> wrote: > Thanks, Jov, for you suggestions. Per your e-mail I added ?explain > analyze? to the script: Can you check that autovacuum is not involved in a lock storm? Autovacuums workers start to work but a higher level lock is acquired by ot= her process/transaction stopping autovacuum workers continuously, making au= tovacuum useless (but trying continually to clean). Also, you're comparing Postgresql 9.1 with 9.5, are you using the same conf= file? Did you upgrade it (conf file) to 9.5? --- --- Eduardo Morras <emorrasg@yahoo.es> _______________________________________________ freebsd-hackers@freebsd.org mailing list https://lists.freebsd.org/mailman/= listinfo/freebsd-hackers To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.org" This message may contain confidential and privileged information. If it has= been sent to you in error, please reply to advise the sender of the error = and then immediately delete it. If you are not the intended recipient, do n= ot read, copy, disclose or otherwise use this message. The sender disclaims= any liability for such unauthorized use. PLEASE NOTE that all incoming e-m= ails sent to Weatherford e-mail accounts will be archived and may be scanne= d by us and/or by external service providers to detect and prevent threats = to our systems, investigate illegal or inappropriate behavior, and/or elimi= nate unsolicited promotional e-mails (spam). This process could result in d= eletion of a legitimate e-mail before it is read by its intended recipient = at our organization. Moreover, based on the scanning results, the full text= of e-mails and attachments may be made available to Weatherford security a= nd other personnel for review and appropriate action. If you have any conce= rns about this process, please contact us at dataprivacy@weatherford.com.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?12e95f4e7e814093b1e877d722316ae0>