On Fri, Mar 13, 2015 at 12:18 PM, Jason Dusek wrote:
> Hi All,
>
> The difference in how format handles `regclass` and `name` seems like an
> inconsistency:
>
> WITH conversions(casts, format, result) AS (
> VALUES (ARRAY['name']::regtype[], '%I', format('%I',
> name('select')
I'm trying to follow the BDR monitoring docs:
https://wiki.postgresql.org/wiki/BDR_Monitoring
My postgres version string is (its from the 2nd Quadrant repo):
PostgreSQL 9.4.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
My BDR plugin is version 0.8.0b
Hi All,
The difference in how format handles `regclass` and `name` seems like an
inconsistency:
WITH conversions(casts, format, result) AS (
VALUES (ARRAY['name']::regtype[], '%I', format('%I',
name('select'))),
(ARRAY['name']::regtype[], '%L', format('%
Thank you - it worked beautifully.
Dara
On Thu, Mar 12, 2015 at 4:28 PM, Chander Ganesan wrote:
> Hi Dara,
>
> A few things:
>
> 1. Replication is a binary process - that means that you can never set it
> up with using any of the pg_dump type tools (i.e., pg_dumpall/pg_dump can
> never be used
On 3/13/2015 2:59 AM, Job wrote:
The application i use need lots of static DB connections
if lots is much over a 100 or so, I'd strongly advise using a connection
pooler like pgbouncer or whatever is built into your language framework
(for instance, Java frameworks like Tomcat have built in c
On 3/13/2015 6:51 AM, sameer malve ⎝⏠⏝⏠⎠ wrote:
Just use pgtune utility it will give an o/p of u r postgres.conf
depending on your machine hardware .
I find on newer large hardware, pg_tune makes some over-the-top choices.
--
john r pierce 37N 122W
somewh
On 12 March 2015 at 12:31, Thomas Kellerer wrote:
> 8.4 cannot run queries on the standby, you need to upgrade to a
> supported/maintained version for this
> (this feature was introduced in 9.0)
>
> In 9.x you can start the slave as a "hot standby" to allow read only queries
> which is what pg_
You can set log_min_duration_statement = 0 to log every statement.
On Fri, Mar 13, 2015 at 3:38 AM, Sreerama Manoj wrote:
>
> Hi,
> As we know that "pg_stat_statements" will monitor the queries after
> normalizing the queries(Removes the values present in query). I want to
> know is there
> The thing is you can use desktop class machines for the slave. If you do
> not have spare machines I would suggest a desktop class machine with big
> RAM and whatever disks you need for the DB plus an extra disk to pg_dump to
> ( so pg_dump does not compete with DB for the db disks, this really
On 03/13/2015 02:59 AM, Job wrote:
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number bu
Hello ,
Just use pgtune utility it will give an o/p of u r postgres.conf depending
on your machine hardware .
Regards,
Sameer
On Mar 13, 2015 5:45 PM, "Vick Khera" wrote:
>
> On Fri, Mar 13, 2015 at 5:59 AM, Job wrote:
>
>> The application i use need lots of static DB connections: in the 9
>>
On Fri, Mar 13, 2015 at 5:59 AM, Job wrote:
> The application i use need lots of static DB connections: in the 9
> version, how many connections can be declared in postgresql.conf?
> I searched for a max number but i noticed it is not specified.
>
It depends on how much shared memory you give to
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number but i noticed it is not specified.
Tha
Hello,
i have just installed (on a Centos 6.5 x64 machine) Postgresql 9 latest stable
version.
The application i use need lots of static DB connections: in the 9 version, how
many connections can be declared in postgresql.conf?
I searched for a max number but i noticed it is not specified.
Tha
Hi,
As we know that "pg_stat_statements" will monitor the queries after
normalizing the queries(Removes the values present in query). I want to
know is there a way to store those normalized values because I want to
check the type of data(values) ,range of data that is being hit to the
databas
15 matches
Mail list logo