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
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 t
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| 2017-01
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 coming in to postgres
> in
> > this format :
> >
> > user_
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', 'talking', '2017-01-01 10:02:00'
> 'u
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 g
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 search_path ignored
I logged out and back and did SET ROLE a
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.
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 thing_accessor;
> > > CREATE SCHEMA
> > > covermyt
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.
>
> Clifford
>
> On Sun,
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 thing_accessor;
>
> SET
>
>
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",
12 matches
Mail list logo