RE: PostgreSQL suitable?

Hi Thank you all for your thoughts and the light shedding on this subject. I am very pleased to have got such engaged feedback and also that PostgreSQL seems to be so capable. I am quite sad that we most probably will not setup our DWH with it as RDBMS. It is, I fear, a quite

Re: Debugging a function - what's the best way to do this quickly?

On Tue, Dec 19, 2017 at 2:24 PM, Kevin Burke wrote: > I'm writing a function that looks a little like this: > > DROP FUNCTION IF EXISTS myfunction; > CREATE OR REPLACE FUNCTION myfunction(arg1 uuid, > _symbol text, > _start timestamp with time zone, > _end timestamp

Debugging a function - what's the best way to do this quickly?

I'm writing a function that looks a little like this: DROP FUNCTION IF EXISTS myfunction; CREATE OR REPLACE FUNCTION myfunction(arg1 uuid, _symbol text, _start timestamp with time zone, _end timestamp with time zone ) RETURNS TABLE (arg5 date, arg6 float) AS $$ WITH cte1 AS ( ... ),

Re: AWS Aurora and PG 10

On Tue, Dec 19, 2017 at 9:59 AM, Tory M Blue wrote: > Actually in us-west-1 9.x is not even available > ​You seem to be confused as to both PostgreSQL versioning and AWS offerings.​ I could deploy a 9.6.5 (one patch release behind the current 9.6 release) to us-west-1 right

Re: PostgreSQL suitable?

Hi. 2017-12-19 17:32 GMT+01:00 Stephen Frost : > Greetings, > > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> 2017-12-19 16:48 GMT+01:00 Stephen Frost : >> > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> >> Sorry, my bad: I confused

Re: AWS Aurora and PG 10

AWS Aurora still do not support PG 10. It would take time. Kind Regards, Rahul Saha +91 8806351116 > On 19-Dec-2017, at 9:45 PM, Rakesh Kumar wrote: > > Has AWS Aurora started supporting PG 10. Their website still talks about 9.6. > > Thanks >

Re: PostgreSQL suitable?

Greetings, * James Keener (j...@jimkeener.com) wrote: > Would a storage block level incremental like zfs work? This really depends on what you want out of your backups and just exactly how the ZFS filesystem is set up. Remember that any backup of PG that doesn't use PG's start/stop backup must

Re: PostgreSQL suitable?

Greetings Rakesh, * Rakesh Kumar (rakeshkumar...@mail.com) wrote: > > > There are multiple solutions to doing incremental backups with > > PostgreSQL, so I'm not sure why you're saying that they don't exist, > > because that's really not accurate. > > PG's incremental backup is essentially WAL

Re: PostgreSQL suitable?

2017-12-19 16:48 GMT+01:00 Stephen Frost : > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> Sorry, my bad: I confused V10 with v11. >> But accordingly to a discussion with Bruce Momjan, table partitionin V10 is >> little more than syntactic sugar around old-fashioned

Re: PostgreSQL suitable?

> There are multiple solutions to doing incremental backups with > PostgreSQL, so I'm not sure why you're saying that they don't exist, > because that's really not accurate. PG's incremental backup is essentially WAL logs applied to a point in time. I am talking about true incremental backup

Re: Re: PostgreSQL needs percentage function

On Tue, Dec 19, 2017 at 4:54 AM, Pavel Stehule wrote: > > > 2017-12-19 10:13 GMT+01:00 Nick Dro : > >> This is exactly why I think there should be some build-in function for >> that... >> Percentage calculation exists in almost any databse and

Re: PostgreSQL suitable?

Am 19.12.2017 um 15:58 schrieb Vincenzo Romano: But accordingly to a discussion with Bruce Momjan, table partitionin V10 is little more than syntactic sugar around old-fashioned table partitioning. there is always room for improvements, but table-partitioning in pg10 is much, much better

Re: PostgreSQL suitable?

PG10 is happily in production - in active use here :) Tim Clarke IT Director Manifest Tel: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 | Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550 Blog: https://blog.manifest.co.uk/ | Web: https://www.manifest.co.uk/ 9

Re: PostgreSQL suitable?

Vincenzo Romano wrote: > I've not tested PG10. But it's not released for production yet! It definitely is, for a couple of months now. 10.1 (the first bugfix release) has been out for over a month. -- Álvaro Herrerahttps://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: PostgreSQL suitable?

I've not tested PG10. But it's not released for production yet! Il 19 dic 2017 15:48, "Andreas Kretschmer" ha scritto: > > > Am 19.12.2017 um 15:07 schrieb Kellner Thiemo: > >> Hi >> >> We are developing a data warehouse of which the integration layer will >> start with

Re: pgstattuple free_percent to high

Hello, anyone can help on this matter, Alessandro highlighted? Thanks a lot, Nicola 2017-12-16 13:40 GMT+01:00 Alessandro Aste : > Stephen, Rene - Thanks! > > Our experience teach us that above 20% of free space performance start to > seriously deteriorate. I'm not

Re: Re: PostgreSQL needs percentage function

2017-12-19 10:13 GMT+01:00 Nick Dro : > This is exactly why I think there should be some build-in function for > that... > Percentage calculation exists in almost any databse and information system > - it requires from use to implement many functions on thier own for >

RE: Re: PostgreSQL needs percentage function

This is exactly why I think there should be some build-in function for that... Percentage calculation exists in almost any databse and information system - it requires from use to implement many functions on thier own for something that is very basic. The general idea of my request is that