Re: Moving delta data faster

On 4/4/24 13:42, yudhi s wrote: On Thu, Apr 4, 2024 at 9:04 PM Adrian Klaver > wrote: On 4/3/24 22:24, yudhi s wrote: > > On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver mailto:adrian.kla...@aklaver.com> >

Re: Moving delta data faster

So you want advice from this open source community about moving things from a proprietary database to another proprietary database, going through a proprietary storage system along the way? :) To answer the original question, use MERGE. That's it's job, and your table size is very tiny, so I

Re: Moving delta data faster

On Thu, Apr 4, 2024 at 9:04 PM Adrian Klaver wrote: > On 4/3/24 22:24, yudhi s wrote: > > > > On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver > > wrote: > > S3 is not a database. You will need to be more specific about '... then > from the S3 it will be picked

Re: What permissions are required for e.g. EXPLAIN UPDATE ...

Thomas Nyberg writes: > Or put another way, does an EXPLAIN UPDATE on a table really require > UPDATE permissions to run? Why can't it be done without UPDATE > permissions? IIRC, the reasoning is this: should you be allowed to run an EXPLAIN on a table that you have no permissions for at all?

Re: Multiple COPY statements for one table vs one for ~half a billion records

On Thu, Apr 4, 2024 at 2:04 PM Carl L wrote: > Hi there, > > I have around half a billion records that are being generated from a back > end that are split into 80 threads (one per core) and I'm performing a copy > from memory ( from stdin binary) into Postgres from each of these threads - >

Multiple COPY statements for one table vs one for ~half a billion records

Hi there, I have around half a billion records that are being generated from a back end that are split into 80 threads (one per core) and I'm performing a copy from memory ( from stdin binary) into Postgres from each of these threads - i.e. there are 80 COPY statements being generated for one

What permissions are required for e.g. EXPLAIN UPDATE ...

Hello, Or put another way, does an EXPLAIN UPDATE on a table really require UPDATE permissions to run? Why can't it be done without UPDATE permissions? I can understand EXPLAIN ANALYZE UPDATE requiring it, since it actually executes the statement, but why would a regular EXPLAIN UPDATE

Re: Moving delta data faster

On 4/3/24 22:24, yudhi s wrote: On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver > wrote: On 4/3/24 20:54, yudhi s wrote: > On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver mailto:adrian.kla...@aklaver.com> >

Re: Failure of postgres_fdw because of TimeZone setting

On 4/3/24 22:23, Adnan Dautovic wrote: Hi everyone, I have some trouble using postgres_fdw in order to display some data from a Postgres database I do not control in a Postgres database that I do control. I filled out the form from the wiki below and would appreciate any tips. * A

Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

Hello, I am attaching the solution we used. Thank you for your answers and help, Roman -- -- ALTER SUBSCRIPTION REFRESH TEST CASE / SOLUTION -- -- 9. install extension dblink + create function/procedure [DESTINATION DATABASE]