Re: Can't seem to mix an inner and outer join in a query and get it to work right.

On Monday, June 29, 2020, David Gauthier wrote: > >sqf_id | sqf_sl | as_cl | > wa_id | type > > +--- > --+-+---+--- > > *

Re: libpq pipelineing

Tom, I'm implementing a small abstraction layer for event-driven result streaming on PostgreSQL and MariaDB for Ruby, and I'll endeavor to report back with some numbers once I have enough of it working to benchmark something meaningful. Thanks for your patience and help. Kind regards, Samuel On

Can't seem to mix an inner and outer join in a query and get it to work right.

9.6.7 on linux This query, which has 2 outer joins, gives me the records that I want... dvdb=# select dvdb-# sqf.sqf_runs.sqf_id, dvdb-# sqf.sqf_runs.submitted_shelvelist as sqf_sl, dvdb-# dvm.workarea_env.p4_changelist as as_cl, dvdb-# dvm.workarea_env.wa_id, dvdb-#

Re: PostgreSQL database segsize

Magnus Hagander writes: > On Tue, Jun 30, 2020 at 12:17 AM Bill Glennon wrote: >> If you are building a Postgresql database from source and you use >> option --with-segsize=4, how do you verify that the database segsize is 4GB >> and not the default 1GB? Is there a query that you can run? > You

Re: PostgreSQL database segsize

Awesome! That worked. Thank you Magnus! I should have thought of that earlier. LOL On Mon, Jun 29, 2020 at 6:33 PM Magnus Hagander wrote: > > > On Tue, Jun 30, 2020 at 12:17 AM Bill Glennon wrote: > >> Hi, >> >> If you are building a Postgresql database from source and you use >> option

Re: PostgreSQL database segsize

On Tue, Jun 30, 2020 at 12:17 AM Bill Glennon wrote: > Hi, > > If you are building a Postgresql database from source and you use > option --with-segsize=4, how do you verify that the database segsize is 4GB > and not the default 1GB? Is there a query that you can run? > > Or even if you come

PostgreSQL database segsize

Hi, If you are building a Postgresql database from source and you use option --with-segsize=4, how do you verify that the database segsize is 4GB and not the default 1GB? Is there a query that you can run? Or even if you come into a place to support an existing PostgreSQL database, how do you

Re: EXTERNAL: Re: Netapp SnapCenter

Hi Stephen, > On 29. Jun, 2020, at 17:29, Stephen Frost wrote: > > I typically recommend rather strongly against using anything that won't > allow you to update to keep pace with PG minor versions, considering > they include critical security and corruption fixes (in some cases, but > even if

Re: pgbench and timestamps

Hello Tom, The attached patch fixes some of the underlying problems reported by delaying the :var to $1 substitution to the last possible moments, so that what variables are actually defined is known. PREPARE-ing is also delayed to after these substitutions are done. It requires a mutex

Re: EXTERNAL: Re: Netapp SnapCenter

Greetings, * Paul Förster (paul.foers...@gmail.com) wrote: > > On 29. Jun, 2020, at 16:43, Stephen Frost wrote: > > I certainly don't blame you, particularly given all the changes > > regarding how restore is done which went into v12- obviously anything > > that hasn't been updated since before

Re: EXTERNAL: Re: Netapp SnapCenter

Hi Stephen, > On 29. Jun, 2020, at 16:43, Stephen Frost wrote: > > On some database platforms it basically means "stop writing", in order > to allow a backup to be taken, but that's not what happens on PG and any > documentation about using PG's start/stop definitely shouldn't be > talking

Re: Postgresql HA Cluster

Hi Albe, Here is my one more concern regarding patroni and repmgr tool versions compatibility with centos8 and postgresql 10/11/12 versions, could u plz provide ur valuable output. Thanks Brajendra On Mon, 29 Jun, 2020, 1:03 PM Laurenz Albe, wrote: > On Sun, 2020-06-28 at 09:10 +0530,

Re: EXTERNAL: Re: Netapp SnapCenter

Greetings, * Paul Förster (paul.foers...@gmail.com) wrote: > > On 29. Jun, 2020, at 15:32, Stephen Frost wrote: > > > > Presumably they mean 'quiesce', except that that *isn't* what PG's > > yes, sorry, "quiece" was a typo on my part. I never fully understood what > they mean with "quiesce"

Re: libpq pipelineing

Samuel Williams writes: > Those methods don't seem to have an equivalent in libpq - you can use > PQgetResult but it buffers all the rows. Using single row mode results > in many results for each query (seems like a big overhead). Have you got any actual evidence for that? Sure, the overhead is

Re: EXTERNAL: Re: Netapp SnapCenter

Hi Stephen, > On 29. Jun, 2020, at 15:32, Stephen Frost wrote: > > Presumably they mean 'quiesce', except that that *isn't* what PG's yes, sorry, "quiece" was a typo on my part. I never fully understood what they mean with "quiesce" anyway. But then, I'm not the storage specialist in out

Re: libpq pipelineing

Greetings, * Samuel Williams (space.ship.travel...@gmail.com) wrote: > Here is a short example: > > https://gist.github.com/ioquatix/2f08f78699418f65971035785c80cf18 > > It makes 10 queries in one "PQsendQuery" and sets single row mode. But > all the results come back at once as shown by the

Re: PG13 Trusted Extension usability issue

Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > "Brad Nicholson" writes: > > Tom Lane wrote on 2020/06/26 02:47:25 PM: > >> I'm confused about your point here. postgresql_fdw has intentionally > >> *not* been marked trusted. That's partly because it doesn't seem like > >>

Re: EXTERNAL: Re: Netapp SnapCenter

Greetings, * Paul Förster (paul.foers...@gmail.com) wrote: > > On 26. Jun, 2020, at 12:29, Magnus Hagander wrote: > > I believe NetApp does atomic snapshots across multiple volumes, if you have > > them in the same consistency group. (If you don't then you're definitely in > > for a world of

Re: Help - Need 9.3 for Centos - recovery of legacy system

On 6/29/20 6:02 AM, Adrian Klaver wrote: On 6/29/20 5:04 AM, Brad Thompson wrote: Need to get 9.3 to install to recover a legacy system.  We have a legacy system that experienced a hardware failure requiring a OS reload.  Have installed 9.6 as an interim step but it won't let me get to the

Re: Help - Need 9.3 for Centos - recovery of legacy system

On 6/29/20 5:04 AM, Brad Thompson wrote: Need to get 9.3 to install to recover a legacy system.  We have a legacy system that experienced a hardware failure requiring a OS reload.  Have installed 9.6 as an interim step but it won't let me get to the 9.3 databases. So you have the 9.3 data

Re: libpq pipelineing

I think libmariadb has a nicer interface for this. Essentially what you do is send your query, and then read a result set (one result set per query), and then you stream individual rows using: mysql_fetch_row_start mysql_fetch_row_cont Those methods don't seem to have an equivalent in libpq -

Help - Need 9.3 for Centos - recovery of legacy system

Need to get 9.3 to install to recover a legacy system. We have a legacy system that experienced a hardware failure requiring a OS reload. Have installed 9.6 as an interim step but it won't let me get to the 9.3 databases. Am hoping to use the migration tools to get the 9.3 data dumped then

Re: Postgresql HA Cluster

På mandag 29. juni 2020 kl. 09:40:13, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 29.06.20 um 09:33 schrieb Laurenz Albe: > That would not provode a multi-master solution, though. There are some > commercial solutions for that, but be warned that

Re: Postgresql HA Cluster

Am 29.06.20 um 09:33 schrieb Laurenz Albe: That would not provode a multi-master solution, though. There are some commercial solutions for that, but be warned that it would require non-trivial changes to your application. not really with BDR3 ;-) Andreas -- 2ndQuadrant - The PostgreSQL

Re: Postgresql HA Cluster

On Sun, 2020-06-28 at 09:10 +0530, Brajendra Pratap Singh wrote: > Is there any functionality present in postgresql for High Availability > Cluster where we can setup > multiple nodes/instances in READ-WRITE mode for single database so that > incase of one node/instance > failure it will