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
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',
On 12 March 2015 at 12:31, Thomas Kellerer spam_ea...@gmx.net 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
Thank you - it worked beautifully.
Dara
On Thu, Mar 12, 2015 at 4:28 PM, Chander Ganesan chan...@otg-nc.com 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
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
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
On Fri, Mar 13, 2015 at 12:18 PM, Jason Dusek jason.du...@gmail.com 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',
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
On Fri, Mar 13, 2015 at 5:59 AM, Job j...@colliniconsulting.it 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
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
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.
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.
You can set log_min_duration_statement = 0 to log every statement.
On Fri, Mar 13, 2015 at 3:38 AM, Sreerama Manoj manoj.sreerama...@gmail.com
wrote:
Hi,
As we know that pg_stat_statements will monitor the queries after
normalizing the queries(Removes the values present in query). I
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 vi...@khera.org wrote:
On Fri, Mar 13, 2015 at 5:59 AM, Job j...@colliniconsulting.it wrote:
The application i use need lots of
15 matches
Mail list logo