[GENERAL] Looking for a good programming reference

So, I am a decent oracle SQL and PL/SQL programmer looking to expand into PostgreSQL. Can someone point me to a decent programming book on the topic? I have looked Amazon and Apress and not found much, so I am not sure where to turn. Or perhaps I am looking the wrong places. -- Andrew W.

Re: [GENERAL] Largepages in Windows

Oh, I can answer that. The owner of the postgreSQL executable must have the privilege to lock pages in memory. On Tue, Jan 17, 2017 at 9:38 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Andrew Kerber <andrew.ker...@gmail.com> writes: > > Does PostgreSQL 9.4 support l

[GENERAL] Largepages in Windows

Does PostgreSQL 9.4 support large pages in windows? The setting is there in the postgresql.conf, but I cant tell if it is supported in windows? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'

Re: [GENERAL] Largepages in Windows

Thats what I needed, thank you. Windows generally calls them large pages, AIX also calls them large pages, really they are typically only called hugepages on Linux. On Tue, Jan 17, 2017 at 9:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 01/17/2017 07:20 AM, Andrew Ker

Re: [GENERAL] The Contractor Conundrum

All I can say is welcome to the world of contracting. You have successfully described the nature of the business. On Wed, Apr 26, 2017 at 10:33 AM, Geoff Winkless wrote: > On 26 April 2017 at 15:45, Melvin Davidson wrote: > >> In summary, I can only

Re: [GENERAL] PostgreSQL Required Monitoring

a transaction even without any Insert/update/delete command, so I had to explain that to my developers. On Fri, Apr 28, 2017 at 11:04 AM, John R Pierce <pie...@hogranch.com> wrote: > On 4/28/2017 7:39 AM, Andrew Kerber wrote: > >> I am a fairly experienced Oracle DBA, and we ar

Re: [GENERAL] PostgreSQL Required Monitoring

Yes, that was the first item on my list (disk space)... On Fri, Apr 28, 2017 at 11:56 AM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber <andrew.ker...@gmail.com> > wrote: > > I am a fairly experienced Oracle DBA, and

[GENERAL] PostgreSQL Required Monitoring

I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,software running, connection available on the

[GENERAL] PGpool question

This may be the wrong list, but I am not sure where it needs to go. I am trying to set up pgpool, and I keeping on getting this message: NOTICE: add node from hostname:"xxx" port:9000 pgpool_port: rejected. Jul 28 22:11:49 xx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid 10768:

Re: [GENERAL] Error that shouldn't happen?

It appears to me you might be making this a lot more difficult than necessary. Why not just pre-create the required partitions daily or weekly or monthly? Or do you have a requirement that a new partition only be created the first time it is required? On Thu, May 18, 2017 at 3:31 PM, David G.

Re: [GENERAL] Huge Pages - setting the right value

I am sure it does not. Sent from my iPhone > On Jun 11, 2017, at 10:50 AM, pinker <pin...@onet.eu> wrote: > > Andrew Kerber wrote >> I can't give you an absolutely authoritative answer, but because of the >> way hugepages are implemented and allocated, I can't thin

Re: [GENERAL] Huge Pages - setting the right value

Was that transparent hugepages or standard hugepages? databases commonly have problems dealing with transparent hugepages. On Sun, Jun 11, 2017 at 4:39 PM, Lucas Possamai <drum.lu...@gmail.com> wrote: > 2017-06-12 7:52 GMT+12:00 Andrew Kerber <andrew.ker...@gmail.com>: > &g

Re: [GENERAL] Huge Pages - setting the right value

Possamai <drum.lu...@gmail.com> wrote: > > > 2017-06-12 9:52 GMT+12:00 Andrew Kerber <andrew.ker...@gmail.com>: > >> Was that transparent hugepages or standard hugepages? databases commonly >> have problems dealing with transparent hugepages. >> >> &g

Re: [GENERAL] Huge Pages - setting the right value

I can't give you an absolutely authoritative answer, but because of the way hugepages are implemented and allocated, I can't think how they could be used for other processes. Linux hugepages are either 2m or 1g, far too large for any likely processes to require. They cannot be allocated in