Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Felipe Gasper
On 11 Aug 2015 6:30 PM, Martín Marqués wrote: local samerole allmd5 host samerole all 127.0.0.200 255.255.255.255 pam pamservice=postgresql_cpses host samerole all 127.0.0.1 255.255.255.255 md5 local all postgresmd5 host all postgres 127.0.0.1 255.255.255.255 md5

Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Martín Marqués
I think there might be some misunderstanding here: El 11/08/15 a las 17:19, Felipe Gasper escribió: > Hello all, > > We are noticing what appears to be a significant difference between > PostgreSQL 9.x and 8.4. Not having found documentation that would point > us in the direction of a good so

Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Adrian Klaver
On 08/11/2015 03:06 PM, Felipe Gasper wrote: On 11 Aug 2015 5:56 PM, Adrian Klaver wrote: On 08/11/2015 01:19 PM, Felipe Gasper wrote: Hello all, We are noticing what appears to be a significant difference between PostgreSQL 9.x and 8.4. Not having found documentation that would point us

Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Felipe Gasper
On 11 Aug 2015 5:56 PM, Adrian Klaver wrote: On 08/11/2015 01:19 PM, Felipe Gasper wrote: Hello all, We are noticing what appears to be a significant difference between PostgreSQL 9.x and 8.4. Not having found documentation that would point us in the direction of a good solution, I thought

Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Adrian Klaver
On 08/11/2015 01:19 PM, Felipe Gasper wrote: Hello all, We are noticing what appears to be a significant difference between PostgreSQL 9.x and 8.4. Not having found documentation that would point us in the direction of a good solution, I thought I’d post our issue here. On CentOS 6 we have

[GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-11 Thread Felipe Gasper
Hello all, We are noticing what appears to be a significant difference between PostgreSQL 9.x and 8.4. Not having found documentation that would point us in the direction of a good solution, I thought I’d post our issue here. On CentOS 6 we have postgresql 8.4.20 and the following pg_hba.con

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread John McKown
My thanks. I didn't think to look at OpenCOBOL, just GNU and just couldn't seem to find anything. ​I'm downloading the FireBird code now to see how they did it. I didn't do very well in the "Compiler Theory" class in college. I'm a tad better now, but not even a novice really. ​ -- Schrodinger

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread Reid Thompson
On Tue, 2015-08-11 at 14:32 -0400, an unknown sender wrote: > On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote: > > > PostgreSQL comes with ecpg which is a "pre-processor" to handle embedded > > EXEC > > SQL startements in C (OK, you already know that). I am wondering if anyone > > knows of

Re: [GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread Reid Thompson
On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote: > PostgreSQL comes with ecpg which is a "pre-processor" to handle embedded EXEC > SQL startements in C (OK, you already know that). I am wondering if anyone > knows of any such program for other compiled languages, in particular GNU > COBOL or

[GENERAL] SQL pre-processor, like ecpg, for other languages?

2015-08-11 Thread John McKown
PostgreSQL comes with ecpg which is a "pre-processor" to handle embedded EXEC SQL startements in C (OK, you already know that). I am wondering if anyone knows of any such program for other compiled languages, in particular GNU COBOL or ADA? (please don't shudder, I have my reasons as strange as the

Re: [GENERAL] Postgresql-9.1 CentOS7 effective_cache_size issue

2015-08-11 Thread Jony Cohen
Hi, effective_cache_size is used only for query planing - you will not see it in vmstat etc. the default is 128mb, meaning you'd expect to see major differences when running with 128mb vs 80GB of effective cache. I'd take a look at your execution plans - I think you would find them very different

[GENERAL] Postgresql-9.1 CentOS7 effective_cache_size issue

2015-08-11 Thread Michael H
Hi All, I've been performance tuning a new database server for the past couple of weeks with very mixed results, I've read every guide to tuning I can locate on Google aswell as Gregory Smiths - Postgresql 9.0 High Performance book. The server is a HP DL385P gen8, dual processor AMD Opteron

Re: [GENERAL] Prepared Statements and Pooling

2015-08-11 Thread Alban Hertroys
On 11 August 2015 at 06:44, Mister Junk wrote: > I'm using prepared statements to prevent SQL injection, but I have done some > reading and it seems like using Prepared statements COULD improve > performance. I understand the concept, but I do not know how to implement > this. They could, they c

Re: [GENERAL] Prepared Statements and Pooling

2015-08-11 Thread Andomar
> I have considered opening a single connection to the server and letting all > threads execute statements through it, and use prepared statements (serviced > by postgresql, not JDBC or DBCP). Or simply opening 50 connections and > establishing prepared statements and then handing them off to t