public inbox for [email protected]  

help / color / mirror / Atom feed

From: Scott Ribe <[email protected]>
To: Sabyasachi Mukherjee <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Loading data from one table to another
Date: Sun, 13 Oct 2024 08:34:51 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <DB7PR03MB378887A0840FDAECF62410CD8C7B2@DB7PR03MB3788.eurprd03.prod.outlook.com>
References: <DB7PR03MB378887A0840FDAECF62410CD8C7B2@DB7PR03MB3788.eurprd03.prod.outlook.com>

Failing to allocate a memory segment of only 1MB seems suspicious. What are your hardware specs?

You might want to look at your memory & parallel query settings in postgresql.conf--perhaps some of those are set too high relative to your server's memory.

I wouldn't really expect queries to be slow on 99GB, by the way. That is not a large database. Partitioning is reasonable if you want to prune old data periodically, as then you can just drop old partitions. But unless your queries are regularly have to perform table scans, I wouldn't expect them to be slow. And if they are performing table scans, you'd need to investigate how to fix that--what indexes to add. Partitioning will get you incremental performance gains in such a case, while the right index will get you exponential gains.

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Loading data from one table to another
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox