Re: Methods to quickly spin up copies of an existing databases

2019-03-02 Thread Karsten Hilbert
On Fri, Mar 01, 2019 at 04:51:32PM -0500, Arjun Ranade wrote: > Pre-copying is not really an option since we could potentially need 1-X > instances so it needs to be scalable. Would it work to have a PG instance with a ready-to-use cluster/DB inside a VM, and make a copy of that as needed ? The

Re: cannot execute VACUUM during recovery

2019-03-02 Thread github kran
On Wed, Feb 27, 2019 at 12:39 PM Stephen Eilert wrote: > Are you running Vacuum on the slave node? It has to run on the master. > > Thanks, > > – Stephen > Thanks Stephen for your advice Iam running the VACUUM command from 2 of the linux instances using the below command. We were running some

Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

2019-03-02 Thread Thomas Munro
On Sat, Mar 2, 2019 at 5:02 AM Ray O'Donnell wrote: > On 01/03/2019 15:01, Nicola Contu wrote: > > Hello, > > is there any reason why I am getting worse results using pgsql11.2 in > > writing comparing it with pgsql 10.6? > > > > I have two Instances, both just restored, so no bloats. > > Running

Re: Where **not** to use PostgreSQL?

2019-03-02 Thread Steven Lembark
For small, lightweight, portable SQLite is quite nice for times you don't want to create a full PG installation and still prefer SQL for lookups. -- Steven Lembark 3920 10th Ave South Workhorse Computing Birmingham, AL 35222 lemb

support for JSON Web Token

2019-03-02 Thread Eugen Stan
Hi, I would like to advocate forJSON web token support in PostgreSQL. JWT tokens are used in a lot of web applications and I think there are some very nice use cases for passing the token down to PostgreSQL. Some of the first thing that comes to mind is pairing it with row level security to impl

regex DoS in postgresql?

2019-03-02 Thread Stuart McGraw
I would like to deploy a web application with a Postgresql backend that allows a user to both add a record containing arbitrary text, and to search that text column with an arbitrary regular expression. My question is, is the app subject to a regex denial of service attack? I would have presumed

Re: regex DoS in postgresql?

2019-03-02 Thread Tom Lane
Stuart McGraw writes: > I would like to deploy a web application with a Postgresql backend > that allows a user to both add a record containing arbitrary text, > and to search that text column with an arbitrary regular expression. > My question is, is the app subject to a regex denial of service

Re: Future Non-server Windows support???

2019-03-02 Thread Laurenz Albe
Bill Haught wrote: > My main concern is that Microsoft has Enterprise versions of Windows and > versions for everything else which makes me wonder if at some point > Windows versions for desktop use may not have features needed by some > database applications or differences between the versions