Re: [GENERAL] pg_stat_tmp and pg_upgrade

2017-10-02 Thread Bruce Momjian
On Thu, Sep 28, 2017 at 08:02:44AM -0700, kbran...@pwhome.com wrote: > With Pg10.0 coming, I have a question about pg_stat_tmp and upgrades that I'm > hoping I can get some advice on. > > Historically, we've created a tmpfs "disk" and mounted it on > $PGDATA/pg_stat_tmp and then started Pg. For

Re: [GENERAL] time series data

2017-10-02 Thread Nico Williams
You have these choices: - turn events into INSERTs and UPDATES on a table that represents a single call You might have an events VIEW with INSTED OF insert/update triggers so you can insert events as the interface for updating calls. - store the events and have a VIEW on the events

Re: [GENERAL] time series data

2017-10-02 Thread Khalil Khamlichi
Hi Melvin, Thanks a lot for your help, let me explain to you my problem. we have records like this ccdb1=# select user_name, agent_status, event_time from cc_events ; user_name | agent_status | event_time ---+--+- user1 | ready|

Re: [GENERAL] time series data

2017-10-02 Thread Khalil Khamlichi
interesting proposition, I am reading the docs. On Mon, Oct 2, 2017 at 6:08 PM, Scott Marlowe wrote: > On Sun, Oct 1, 2017 at 2:17 AM, Khalil Khamlichi > wrote: > > Hi everyone, > > > > I have a data stream of a call center application

Re: [GENERAL] time series data

2017-10-02 Thread Scott Marlowe
On Sun, Oct 1, 2017 at 2:17 AM, Khalil Khamlichi wrote: > Hi everyone, > > I have a data stream of a call center application coming in to postgres in > this format : > > user_name, user_status, event_time > > 'user1', 'ready', '2017-01-01 10:00:00' > 'user1',

[GENERAL] Checkpoint write time - anything unusual?

2017-10-02 Thread pinker
I've just run pgBadger on my pg logs and wonder if those checkpoint statistics is something I should worry about or not? The highest write time is about 47 minutes but I'm not sure if that's checkpoint_completion_target*checkpoint_target value or real time between sending the command to write and

Re: [GENERAL] Setting search_path ignored

2017-10-02 Thread Charles Clavadetscher
Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guyren Howe Sent: Montag, 2. Oktober 2017 16:10 To: David G. Johnston Cc: PostgreSQL General Subject: Re: [GENERAL] Setting

Re: [GENERAL] Setting search_path ignored

2017-10-02 Thread David G. Johnston
On Mon, Oct 2, 2017 at 7:09 AM, Guyren Howe wrote: > I logged out and back and did SET ROLE and got the same resullt. > ​ Are you logging in as "thing_accessor" or some role that is a member of "thing_accessor"? David J. ​

Re: [GENERAL] Setting search_path ignored

2017-10-02 Thread Guyren Howe
I logged out and back and did SET ROLE and got the same resullt. On Oct 2, 2017, 10:06 -0400, David G. Johnston , wrote: > On Mon, Oct 2, 2017 at 7:00 AM, Guyren Howe wrote: > > > CREATE ROLE thing_accessor; > > > CREATE ROLE > > > CREATE SCHEMA

Re: [GENERAL] time series data

2017-10-02 Thread Melvin Davidson
On Sun, Oct 1, 2017 at 6:20 PM, Clifford Snow wrote: > I have a stream that updates every minute with a trigger that updates > another table with information from the stream. That way I'm constantly > updated with no need to run a script to update before I want a report.

Re: [GENERAL] Setting search_path ignored

2017-10-02 Thread David G. Johnston
On Mon, Oct 2, 2017 at 7:00 AM, Guyren Howe wrote: > CREATE ROLE thing_accessor; > > CREATE ROLE > > CREATE SCHEMA thing_accessor; > > CREATE SCHEMA > > covermything=> ALTER ROLE thing_accessor SET search_path=thing_accessor; > > ALTER ROLE > > covermything=# SET ROLE

[GENERAL] Setting search_path ignored

2017-10-02 Thread Guyren Howe
CREATE ROLE thing_accessor; CREATE ROLE CREATE SCHEMA thing_accessor; CREATE SCHEMA covermything=> ALTER ROLE thing_accessor SET search_path=thing_accessor; ALTER ROLE covermything=# SET ROLE thing_accessor; SET covermything=> SHOW search_path; search_path - "$user",

Re: [GENERAL] a JOIN to a VIEW seems slow

2017-10-02 Thread Frank Millman
From: Frank Millman Sent: Friday, September 22, 2017 7:34 AM To: pgsql-general@postgresql.org Subject: Re: a JOIN to a VIEW seems slow On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote: > > On Thu, Sep 21, 2017 at 3:54 PM, Merlin Moncure wrote: > > Something is not adding up here.