What is a good data import configuration for only one server for WRITE-AHEAD
LOG settings postgresql.conf where no one is connecting to the database accept
me as a superuser.
Confidentiality Notice: This electronic message and any attachments may contain
confidential or privileged information,
On 6/17/24 06:46, Benoit, Eric wrote:
What is a good data import configuration for only one server for
WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to
the database accept me as a superuser.
1) The Confidentiality Notice is longer then the question and is
basically point
On Mon, Jun 17, 2024 at 9:46 AM Benoit, Eric wrote:
> What is a good data import configuration for only one server for
> WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to the
> database accept me as a superuser.
>
How worried are you about data loss / database corruption?
I
In libpq, in the code of the lo_import function, for each piece of a file
of 8KB in size, lo_write is called, which greatly slows down the work of
lo_import because lo_write sends a request and waits for a response. The
size of 8KB is specified in define LO_BUFSIZE which changed from 1KB to 8KB
24
Hello everyone!
Using Postgres v15.5. I'm struggling to attach a partition to a table with a
primary key.
I have a partitioned table `Transactions`:
```
create table "Transactions"
(
id bigserial
not null,
uid uuid
Hi!
As a big history lover, it would be great to have the HISTIGNORE
functionality added to psql.
Have a great day!
Wiwwo