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
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|
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
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',
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
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
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
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.
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
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",
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.
13 matches
Mail list logo