Re: [GENERAL] checkpoint write errors ( getting worse )

Understood, thanks. This is a new server fired up for our client by Rackspace Not real impressed so far, for the first several days we had major performance issues even thought new new HW had more memory and more/faster CPU's and faster IO - turned out rackspace had turned on cpu throttling

Re: [GENERAL] checkpoint write errors ( getting worse )

On Sun, Oct 23, 2016 at 12:45 PM, CS DBA wrote: > would a dump/restore correct these issues? Not directly, but it would give a logical representation of your data, or a good start image that you could deploy on a server that has less problems. You seem to be facing

Re: [GENERAL] checkpoint write errors ( getting worse )

also, any thoughts on what could be causing these issues? On 10/22/2016 05:59 PM, Tom Lane wrote: CS DBA writes: So I ran REINDEX on all the db's and the errors went away for a bit. Now I'm seeing this: Log entries like this:FATAL: could not read block 0 of

Re: [GENERAL] checkpoint write errors ( getting worse )

would a dump/restore correct these issues? On 10/22/2016 05:59 PM, Tom Lane wrote: CS DBA writes: So I ran REINDEX on all the db's and the errors went away for a bit. Now I'm seeing this: Log entries like this:FATAL: could not read block 0 of relation

Re: [GENERAL] checkpoint write errors ( getting worse )

CS DBA writes: > So I ran REINDEX on all the db's and the errors went away for a bit. Now > I'm seeing this: > Log entries like this:FATAL: could not read block 0 of relation > base/1311892067/2687: read only 0 of 8192 bytes You have a problem there, because:

Re: [GENERAL] checkpoint write errors ( getting worse )

So I ran REINDEX on all the db's and the errors went away for a bit. Now I'm seeing this: Log entries like this:FATAL: could not read block 0 of relation base/1311892067/2687: read only 0 of 8192 bytes So I checked which db it is: $ psql -h localhost psql (8.4.20) Type "help" for help.