Re: [GENERAL] Where to find development builds of pg for windows

2017-10-27 Thread Jeff Janes
On Sat, Oct 14, 2017 at 12:18 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Using PG mainly on windows, I would have liked to test new releases / > development versions before they are available in > https://www.postgresql.org/download/windows/ > > Are there some build

Re: [GENERAL] Why does a SELECT query cause "dirtied" buffers?

2017-10-27 Thread Justin Pryzby
On Fri, Oct 27, 2017 at 09:24:40PM +0200, Thomas Kellerer wrote: > Under which situation does a SELECT query change a block? https://wiki.postgresql.org/wiki/Hint_Bits -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Why does a SELECT query cause "dirtied" buffers?

2017-10-27 Thread Thomas Kellerer
When using explain (analyze, buffers) things like this can show up: Buffers: shared hit=137 read=6545 dirtied=46 Given the description in the manual: The number of blocks dirtied indicates the number of previously unmodified blocks that were changed by this query I am a bit

Re: [GENERAL] BDR question on dboid conflicts

2017-10-27 Thread Zhu, Joshua
Thanks, sounds like that's something unique in my environment/setup. Here are the results of bdr.bdr_get_local_nodeid() for four nodes in a group, Node 1: (6480169638493465053,1,16386) Node 2: (6480169638493465053,1,20225) Node 3: (6480169638493465053,1,29164) Node 4:

[GENERAL] controlling users to audit in pgaudit

2017-10-27 Thread rakeshkumar464
Hi I want to find an easy way to control who not to audit. Let us say we have 50 users out of which we don't want to monitor only 5 users. Is there a way to set logging rules to include all except those 5. alter system set pgaudit.log will include all. From here how do I exclude 5 users.

Re: [GENERAL] Announcing PostgreSQL SLES RPM Repository

2017-10-27 Thread Scott Marlowe
On Thu, Oct 26, 2017 at 4:09 PM, Devrim Gündüz wrote: > > Hi, > > I am proud to announce the new and shiny PostgreSQL RPM repository for SLES > 12: > https://zypp.postgresql.org/. SNIP > This is a part of EnterpriseDB's contribution to the community: EDB provided > hardware,

Re: [GENERAL] query not scaling

2017-10-27 Thread Merlin Moncure
On Thu, Oct 26, 2017 at 10:01 AM, Tom Lane wrote: > Laurenz Albe writes: >> Also, to have PostgreSQL inline the function, which would be good >> for performance, it should be declared IMMUTABLE. > > Actually, if you hope to have a SQL function be

Re: [GENERAL] Question regarding logical replication

2017-10-27 Thread Weiping Qu
Thanks, Francisco. From the plots we got the same feeling, cache reads with little lags and high cache hits really don't put extra burden on the original write throughput for OLTP transactions. And log-based is the most efficient and harm-less one as compared to trigger-based and timestamp

Re: [GENERAL] Function

2017-10-27 Thread Raymond O'Donnell
On 26/10/17 15:00, Marcio Farah wrote: Good morning for all I´m beginer in PL/pgSQL functions and I have one difficulty. The function bellow should return many records but return just one. The loop just do the first INSERT INTO and get out. If you run SELECT

[GENERAL] Function

2017-10-27 Thread Marcio Farah
Good morning for all I´m beginer in PL/pgSQL functions and I have one difficulty. The function bellow should return many records but return just one. The loop just do the first INSERT INTO and get out. CREATE OR REPLACE FUNCTION geo_output.funcao30(num integer) RETURNS TABLE (quadro_id integer,

Re: [GENERAL] Question regarding logical replication

2017-10-27 Thread Francisco Olarte
On Fri, Oct 27, 2017 at 12:04 PM, Weiping Qu wrote: > That's a good point and we haven't accounted for disk caching. > Is there any way to confirm this fact in PostgreSQL? I doubt, as it names indicates cache should be hidden from the db server. You could monitor the

Re: [GENERAL] Question regarding logical replication

2017-10-27 Thread Weiping Qu
That's a good point and we haven't accounted for disk caching. Is there any way to confirm this fact in PostgreSQL? Weiping On 27.10.2017 11:53, Francisco Olarte wrote: On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu wrote: However, the plots showed different trend

Re: [GENERAL] Question regarding logical replication

2017-10-27 Thread Francisco Olarte
On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu wrote: > However, the plots showed different trend (currently I don't have plots on > my laptop) which shows that the more frequently are the CDC processes > reading from logical slots, the less overhead is incurred over

Re: [GENERAL] Can't build ODBC -- odbc_config not found

2017-10-27 Thread John R Pierce
On 10/27/2017 12:39 AM, Devrim Gündüz wrote: On Thu, 2017-10-26 at 23:40 -0700, Chris Albertson wrote: I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) I type "./configure" Then get this message: configure: error: odbc_config not found (required for unixODBC build)

Re: [GENERAL] Can't build ODBC -- odbc_config not found

2017-10-27 Thread Devrim Gündüz
Hi, On Thu, 2017-10-26 at 23:40 -0700, Chris Albertson wrote: > I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) > > I type "./configure" > > Then get this message: > configure: error: odbc_config not found (required for unixODBC build) > > So it must be looking

Re: [GENERAL] Can't build ODBC -- odbc_config not found

2017-10-27 Thread Michael Paquier
On Thu, Oct 26, 2017 at 11:40 PM, Chris Albertson wrote: > I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) > > I type "./configure" > > Then get this message: > configure: error: odbc_config not found (required for unixODBC build) > > So it

[GENERAL] Can't build ODBC -- odbc_config not found

2017-10-27 Thread Chris Albertson
I just tried to build Postgres ODBC from source (psqlodbc-10.00..tar.gz) I type "./configure" Then get this message: configure: error: odbc_config not found (required for unixODBC build) So it must be looking for a file called "odic_config"? It's not 100% clear what is needed. -- Chris