Re: create index insist on 2 workers only

On Fri, Apr 24, 2020 at 7:32 AM Radoslav Nedyalkov wrote: > We 're rebuilding a big table which has set parallel_workers = 6 > system has > max_parallel_maintenance_workers | 6 | > /var/lib/pgsql/11/data/postgresql.sumup.conf > max_parallel_workers | 16 | > /var/lib/pgsq

Re: psql \copy

You might want to investigate pg_bulkload for this activity. On 4/24/20 10:55 AM, Steve Clark wrote: Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key field on the time field which I have defined as a bigint since the time I get from I

Re: psql \copy

On 04/24/2020 12:15 PM, Adrian Klaver wrote: On 4/24/20 9:12 AM, Steve Clark wrote: On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark mailto:steve.cl...@netwolves.com> > wrote: Hel

Re: psql \copy

On 4/24/20 10:12 AM, Steve Clark wrote: On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark mailto:steve.cl...@netwolves.com>> wrote: Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a

Re: psql \copy

On 4/24/20 9:12 AM, Steve Clark wrote: On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark > wrote: Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key

Re: psql \copy

On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark mailto:steve.cl...@netwolves.com>> wrote: Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key field on the time field which I have defined as a bigint

Re: psql \copy

On Fri, Apr 24, 2020 at 8:55 AM Steve Clark wrote: > Hello, > > I am using psql to copy data extracted from an InfluxDB in csv format into > postgresql. > I have a key field on the time field which I have defined as a bigint > since the time I get > from InfluxDB is an epoch time. > > My question

Re: psql \copy

On 4/24/20 8:55 AM, Steve Clark wrote: Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key field on the time field which I have defined as a bigint since the time I get from InfluxDB is an epoch time. My question is does psql abort the c

Re: psql \copy

On Fri, Apr 24, 2020 at 8:55 AM Steve Clark wrote: > Hello, > > I am using psql to copy data extracted from an InfluxDB in csv format into > postgresql. > I have a key field on the time field which I have defined as a bigint > since the time I get > from InfluxDB is an epoch time. > > My question

psql \copy

Hello, I am using psql to copy data extracted from an InfluxDB in csv format into postgresql. I have a key field on the time field which I have defined as a bigint since the time I get from InfluxDB is an epoch time. My question is does psql abort the copy if it hits a duplicate key, or does i

create index insist on 2 workers only

Hello everybody, We 're rebuilding a big table which has set parallel_workers = 6 system has max_parallel_maintenance_workers | 6 | /var/lib/pgsql/11/data/postgresql.sumup.conf max_parallel_workers | 16 | /var/lib/pgsql/11/data/postgresql.sumup.conf max_parallel_workers_p

Re: Weird behaviour of C extension function

On Fri, 2020-04-24 at 14:53 +0200, Amaury Bouchard wrote: > I have a really strange behaviour with a C function, wich gets a text as > parameter. > Everything works fine when I call the function directly, giving a text string > as parameter. But a problem occurs when I try to read data from a tab

Weird behaviour of C extension function

Hello everybody, I have a really strange behaviour with a C function, wich gets a text as parameter. Everything works fine when I call the function directly, giving a text string as parameter. But a problem occurs when I try to read data from a table. To illustrate the problem, I stripped the fun

Re: Can I tell libpq to connect to the primary?

On Thu, Apr 23, 2020 at 08:54:35AM +0200, Christian Ramseyer wrote: > Never mind, after RTFM'ing to the very end of > https://www.postgresql.org/docs/current/libpq-connect.html I have > discovered target_session_attrs=read-write|any which seems to do exactly > what I want. Yes, as long as you don'