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
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:
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
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:
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.
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,
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
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
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
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,
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
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
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
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)
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
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
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
17 matches
Mail list logo