Greetings Postgres Developers,
I've recently started taking advantage of the PARTITION BY HASH feature for
my database system. It's a really great fit since my tables can get quite
large (900M+ rows for some) and splitting them up into manageable chunks
should let me upload to them without having
)
On Sun, Apr 17, 2022 at 9:09 AM Tom Lane wrote:
> Benjamin Tingle writes:
> > I've recently started taking advantage of the PARTITION BY HASH feature
> for
> > my database system. It's a really great fit since my tables can get quite
> > large (900M+ rows fo
o far has been working reasonably
well. If you have some insight into why these large update/insert
operations go so slowly, it would be much appreciated.
-Ben
On Sun, Apr 17, 2022 at 11:50 AM Alvaro Herrera
wrote:
> On 2022-Apr-14, Benjamin Tingle wrote:
>
> > It doesn't help
Hell postgres people!
This is not an issue report so much as a gripe. I'm on postgres 12.2, so it
is entirely possible that the issue I describe is fixed in a later version.
If so, it is not described in the docs or any posts I can find archived on
pgsql-performance. (I am not brave enough to delv
Thanks for the helpful response david! I'll have a shot at getting the
patch to work myself & submitting to pgsql-hackers.
Ben
On Wed, Feb 8, 2023 at 2:36 PM David Rowley wrote:
> On Thu, 9 Feb 2023 at 10:45, Benjamin Tingle wrote:
> > Basically- window partition fu
