Re: [GENERAL] High load average every 105 minutes

Thanks for the reply. I found no strange processes or queries while load average was at peak. IO also didn't change. Some more slow queries were logged, but not many. I think sharing the VM with other customers doesn’t have much to do with this. I checked my other servers too, and only those

Re: [GENERAL] Exclude pg_largeobject form pg_dump

On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge wrote: >> >> Agreed. I was afraid of that, but for some reason, didn't find that. I'll >> fix this. > > > Fixed in v4. > This fix is broken. 70 - if (dopt.include_everything && !dopt.schemaOnly) 71 + if

Re: [GENERAL] Dynamic execution returning large result sets

On 11/06/2016 05:12 PM, Emrul wrote: Hi, I have a function that returns an SQL string as follows: CREATE OR REPLACE FUNCTION t1() RETURNS text AS $$ BEGIN RETURN 'SELECT * FROM mytable'; END $$ LANGUAGE plpgsql; and I want to create a second function (t2) that will execute the string returned

[GENERAL] Dynamic execution returning large result sets

Hi, I have a function that returns an SQL string as follows: CREATE OR REPLACE FUNCTION t1() RETURNS text AS $$ BEGIN RETURN 'SELECT * FROM mytable'; END $$ LANGUAGE plpgsql; and I want to create a second function (t2) that will execute the string returned by t1() and return the results. I

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-04 9:35 GMT+01:00 Guillaume Lelarge : > Hi Amul, > > 2016-11-04 7:52 GMT+01:00 amul sul : > >> Hi Guillaume, >> >> I found following issues with this patch, sorry missed in previous post: >> >> > You don't have to be sorry for me doing shitty

Re: [GENERAL] timestamp without timezone to have timezone

On 11/06/2016 09:24 AM, Benjamin Adams wrote: Please Reply to list also. I have Cced list > On Nov 6, 2016 11:07 AM, "Adrian Klaver" > wrote: >> >> On 11/06/2016 06:11 AM, Benjamin Adams wrote: >> > I have a server that has a column

Re: [GENERAL] timestamp without timezone to have timezone

On Sun, Nov 6, 2016 at 7:10 AM, Melvin Davidson wrote: > > > > On Sun, Nov 6, 2016 at 9:11 AM, Benjamin Adams wrote: >> >> I have a server that has a column timestamp without timezone. >> >> Is the time still saved? >> if I select column with

Re: [GENERAL] timestamp without timezone to have timezone

On 11/06/2016 06:11 AM, Benjamin Adams wrote: > I have a server that has a column timestamp without timezone. > > Is the time still saved? Yes the timestamp is always saved. What that timestamp is differs: test[5432]=# create table ts_tsz_test(fld_1 timestamp, fld_2 timestamp with time zone);

Re: [GENERAL] timestamp without timezone to have timezone

On Sun, Nov 6, 2016 at 9:11 AM, Benjamin Adams wrote: > I have a server that has a column timestamp without timezone. > > Is the time still saved? > if I select column with timestamp it will show server timestamp with > timezone. > > But If I move the data from EST to

[GENERAL] timestamp without timezone to have timezone

I have a server that has a column timestamp without timezone. Is the time still saved? if I select column with timestamp it will show server timestamp with timezone. But If I move the data from EST to Central will the timestamp with timezone be correct? Or will it just not make the adjustment?

[GENERAL] Parallel pg_dump/restore and LOs

Hi all.   When dumping large-objects it doesn't appear that it's done in parallel, meaning only one thread for dumping all LOs. Is this the case? When pg_dump comes to dumping large-objects it outputs (when -v is specified): pg_dump: saving large objects Then it seems only 1 CPU is working.