On Mon, 2025-03-24 at 16:51 +0100, Dimitrios Apostolou wrote:
> Laurenz informed me that I could avoid writing to the WAL if I "create and
> load the table in a single transaction".
> I haven't tried, but here is what I would do to try --single-transaction:
>
> Transaction 1: manually issuing all
> On Mar 24, 2025, at 17:31, Phillip Diffley wrote:
>
> I am testing out some streaming logical replication commands and am having
> trouble specifying options when calling CREATE_REPLICATION_SLOT.
>
> I connect to the database with
> psql "dbname=replication_test_db replication=database"
>
Hi Team,
I am trying to access the postgresql-15.spec to build the RPM for my
project but it is not accessible from morning.
*https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h=7a8b87ec6db538ca115de4fb962709c7a7cebe11;hb=HEA
On 3/24/25 07:18, Cars Jeeva wrote:
Hi Team,
I am trying to access the postgresql-15.spec to build the RPM for my
project but it is not accessible from morning.
/_*https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h=7a8b8
On Mon, 24 Mar 2025, Adrian Klaver wrote:
On 3/24/25 07:24, Dimitrios Apostolou wrote:
On Sun, 23 Mar 2025, Laurenz Albe wrote:
On Thu, 2025-03-20 at 23:48 +0100, Dimitrios Apostolou wrote:
Performance issues: (important as my db size is >5TB)
* WAL writes: I didn't manage to avoid writ
Why are you regularly having emergencies requiring the restoration of
multi-TB tables to databases with lots of cruft?
Fixing that would go a long way towards eliminating your problems with
pg_restore.
On Mon, Mar 24, 2025 at 11:51 AM Dimitrios Apostolou wrote:
> On Mon, 24 Mar 2025, Adrian Kla
On Sun, 23 Mar 2025, Adrian Klaver wrote:
On 3/20/25 15:48, Dimitrios Apostolou wrote:
* plenty of permission denials for both ALTER OWNER or SET SESSION
AUTHORIZATION (depending on command line switches). Both of these
require superuser privilege, but in my case this is not really n
Hi Ron,
I read your reply in the mailing list archives as I'm not subscribed to
the list, and I'm copy-pasting a response here. Please include me as a
recipient in further replies.
Why are you regularly having emergencies requiring the restoration of
multi-TB tables to databases with lots of cr
On Sun, 23 Mar 2025, Laurenz Albe wrote:
On Thu, 2025-03-20 at 23:48 +0100, Dimitrios Apostolou wrote:
Performance issues: (important as my db size is >5TB)
* WAL writes: I didn't manage to avoid writing to the WAL, despite having
setting wal_level=minimal. I even wrote my own function to A
On Mon, 2025-03-24 at 15:24 +0100, Dimitrios Apostolou wrote:
> By the way do you see potential problems with using --single-transaction
> to restore billion-rows tables?
No.
Yours,
Laurenz Albe
Thank you!
I noticed over 99% free space. Now the challenge is running FULL VACUUM on
a table with size over 500GB. It is going to take a couple of hours I
presume.
Also, I hope aggressive vacuuming will prevent us from this situation.
Regards
Siraj
On Wed, Mar 19, 2025 at 11:27 PM Ron Johns
On 2025-Mar-24, Adrian Klaver wrote:
> On 3/24/25 07:18, Cars Jeeva wrote:
> > Hi Team,
> >
> > I am trying to access the postgresql-15.spec to build the RPM for my
> > project but it is not accessible from morning.
> >
> > /_*https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/m
On Thu, 2025-03-20 at 23:48 +0100, Dimitrios Apostolou wrote:
> Performance issues: (important as my db size is >5TB)
>
> * WAL writes: I didn't manage to avoid writing to the WAL, despite having
> setting wal_level=minimal. I even wrote my own function to ALTER all
> tables to UNLOGGED, but
On 3/20/25 04:39, Paul Allen wrote:
Hello.
Problem.
My backend application attempts unsuccessfully repeatedly to insert the
same ~100 rows with images, and despite table's row count remains 0,
toast table's size is growing up permanently, reaching 100, 200, 300 GB
until it takes all availab
On Sunday, March 23, 2025, Igor Korot wrote:
>
> 2. Is there a way to do CREATE TRIGGER IF NOT EXIST for the earlier
> version?
>
No. You have to drop the trigger if it does exist and then create the new
one.
David J.
15 matches
Mail list logo
