Adrian Klaver-3 wrote
> On 02/07/2014 11:08 AM, Joe Van Dyk wrote:
>> I'd like to have join_collapse_limit=20 for all users that belong to a
>> certain group. Is there a way to do that without having to alter all the
>> roles that are in that group?
>
> From what I see in the docs no:
>
> http:/
> I don't know any tools off-hand, but you might be able to generate
> partial statistics from the log files with a descriptive log_line_prefix
> like "%m [%p] (user=%u) (db=%d) (rhost=%h) [vxid:%v txid:%x] [%i] "
We get 60k queries per second all day long. No way am I turning on query
logging to
On Fri, Feb 7, 2014 at 2:24 PM, bricklen wrote:
>
> On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas wrote:
>
>> s I said in the original message, pg_stat_statements only gives query
>> stats for the whole database. What I want to know, is information about
>> each client. Say there's a specific con
On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas wrote:
>
> > Perhaps this might be of use.
> >
> > http://www.postgresql.org/docs/current/static/pgstatstatements.html
>
> Nope. As I said in the original message, pg_stat_statements only gives
> query stats for the whole database. What I want to know,
On 02/07/2014 11:08 AM, Joe Van Dyk wrote:
I'd like to have join_collapse_limit=20 for all users that belong to a
certain group. Is there a way to do that without having to alter all the
roles that are in that group?
From what I see in the docs no:
http://www.postgresql.org/docs/9.3/interactiv
On Feb 6, 2014, at 12:57 PM, Gavin Flower wrote:
> On 07/02/14 05:43, Michael Sacket wrote:
>> On Feb 6, 2014, at 2:23 AM, Vik Fearing wrote:
>>
>>> On 02/06/2014 04:16 AM, Michael Sacket wrote:
Often times I find it necessary to work with table rows in a specific,
generally user-supp
I'd like to have join_collapse_limit=20 for all users that belong to a
certain group. Is there a way to do that without having to alter all the
roles that are in that group?
$ psql monkey
psql (9.3.1)
Type "help" for help.
monkey=# create user f1 login;
CREATE ROLE
monkey=# create user f2 in role
> Perhaps this might be of use.
>
> http://www.postgresql.org/docs/current/static/pgstatstatements.html
Nope. As I said in the original message, pg_stat_statements only gives query
stats for the whole database. What I want to know, is information about each
client. Say there's a specific conne
O
n Fri, 2014-02-07 at 15:00 +, Shaun Thomas wrote:S
o, I haven't ever heard of this, but I could be missing something. Is
there a module or extension for PostgreSQL keep connection statistics? I
don't mean what's in pg_stat_activity, but cumulative. And not like
what's in pg_stat_statements, b
I was looking for an answer to the same problem posted a while back (sorry,
not sure how to join that thread):
Thanks. pg_trgm looks interesting, but after installing the pg_trgm.sql, I
get error messages when following the documentation.
sggeeorg=> create index test_idx on test using gist(column
On 02/06/2014 06:07 PM, Reece Hart wrote:
I'd like to provide public access, without a password, to a database
hosted on Amazon RDS.
I'm familiar with using pg_hba.conf to enable trust (no)
authentication for a user. pg_hba.conf is not available to DBAs on RDS.
Is there any other way to achi
Hi everyone,
So, I haven't ever heard of this, but I could be missing something. Is there a
module or extension for PostgreSQL keep connection statistics? I don't mean
what's in pg_stat_activity, but cumulative. And not like what's in
pg_stat_statements, but about the connections themselves. No
[CC'ed -hackers]
Tsubasa Sakamoto wrote:
>> Not sure that it makes a difference but the docs say psql looks at
>> LC_CTYPE not LANG for Unix systems. You did not say what OS you are
>> working on though from the examples I am guessing some form of Unix.
> The LC_CTYPE environment variable was set
James Sewell wrote:
> My understanding is that WAL archiving can not be enabled on the slave in a
> streaming replication
> pair.
It can be enabled. Did you try it?
> If this is correct, is there a reason behind it? I can see logs showing up in
> pg_xlog, so could they
> not be archived?
Thes
14 matches
Mail list logo
