I want to establish simple jdbc ssl connection using edb as 11 and java 8 u271 with postgresql jdbc driver 42.2.9 (I have also tried these versions: 42.2.18 and 42.2.8).I followed the instructions from the following link.https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-
I want to use slony replication tool offline with edb or postgresql. I have been using Windows 10 operating system. For this, I have downloaded enterprise database 13.1 version. After installation I select slony download from stackbuilder plus. Then I copied these 2 files to offline windows 10 mach
Ben Hoskings writes:
> We have a postgres 11.9 instance serving 7-8k queries/sec. In general
> it's humming along with no issues (p50 patency of ~1ms; p95 ~30ms).
> Lately though, we've seen occasional locking that causes all commits
> to the main database to be briefly blocked and the APIs that i
>
>
>-Oprindelig meddelelse-
>Fra: Laurenz Albe
>Sendt: 29. januar 2021 20:14
>Til: Niels Jespersen ; pgsql-general@lists.postgresql.org
>Emne: Re: Npgsql and the Connection Service File
>
>On Fri, 2021-01-29 at 14:13 +, Niels Jespersen wrote:
>> Is there a way to get Npgsql understan
G'day all,
We have a postgres 11.9 instance serving 7-8k queries/sec. In general
it's humming along with no issues (p50 patency of ~1ms; p95 ~30ms).
Lately though, we've seen occasional locking that causes all commits
to the main database to be briefly blocked and the APIs that it backs
to stall.
>
>
> Could there be some tuning option in PostgreSQL to make queries via
> foreign tables faster (e.g. I heard about option fetch_size)?
>
fetch_size can make a difference, but it won't change a query that takes
hours into a query that takes seconds. The default is likely too low,
though.
Have
On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote:
> Yes, LLVM would work on windows. I'd not even be surprised if one could
> make it work on windows already when using a mingw based build, instead
> of msvc.
In my mingw environment, postgresql build with option "--with-llvm"
failed wi
Hi Ingolf,
> On 29. Jan 2021, at 13:56, Markhof, Ingolf
> wrote:
>
> Hi!
>
> I am struggling with the slow performance when running queries referring to
> foreign tables. – Yes, I know… - Please read the whole story!
Done and it rings a bell or two.
> The set-up basically is a production d
