On 12-07-2021 23:21, Tom Lane wrote:
Jurrie Overgoor writes:
Is this considered a bug in PostgreSQL, or
am I misusing the database engine by doing DROP DATABASE and CREATE
DATABASE over and over again?
It's not a bug. I suppose in a perfect world the stats would
automatically be up to
7;active' for 8 hours
and on.
incase this is due to bad plan,
@Jurrie Overgoor <mailto:postgresql-mailingl...@jurr.org> is it also
possible for you to run manually
`vacuumdb -a -v` from the terminal, each time before you run your
test suite for some runs, do you still get the
On 10-07-2021 10:26, Vijaykumar Jain wrote:
On Sat, 10 Jul 2021 at 00:29, Jurrie Overgoor
<mailto:postgresql-mailingl...@jurr.org>> wrote:
Hi everyone,
We are in the process of upgrading from PostgreSQL 9.6 to 13. When
our
database gets created in our regression test
Hi everyone,
We are in the process of upgrading from PostgreSQL 9.6 to 13. When our
database gets created in our regression tests, we run some unit tests
first. We see one of those tests hang.
It seems the client is waiting on more data to arrive from the
PostgreSQL server. A thread dump sho
On 06-11-2020 10:08, Magnus Hagander wrote:
On Fri, Nov 6, 2020 at 10:00 AM Java Developer wrote:
Hello,
I am trying to query a column from a table I migrated from my MYSQL
into POSTGRESQL but I seem to be having issues with a few column names.
the column name cast is also an operator, I thin
Hello everyone,
I'm currently in the process of upgrading our PostgreSQL installations
from 9.6 to 13. I am experiencing very slow query performance for empty
tables.
Our test environments get build from scratch every run, and thus contain
a lot of empty tables at first. We hit the issue dis
