Re: pg_basebackup failed to read a file

On Tue, Aug 14, 2018 at 12:14:59PM -0400, Tom Lane wrote: > That seems like a pretty expensive thing to do, if there are lots of > files ... and you'd still end up failing, so it's not moving the ball > very far. Yeah, I would think that with many small relations it is going to have a measurable p

Re: upgrading from pg 9.3 to 10

On Tue, Aug 14, 2018 at 04:15:12PM -0300, Martín Marqués wrote: > I'd recommend testing with a clone of the server to verify that it works > properly (not only pg_upgrade, but your application with the new version > of postgres). Also to time the window you'll need and see if there are > things to

Re: During promotion, new master tries to archive same segment twice

On 08/15/2018 01:25 PM, Phil Endecott wrote: Dear Experts, Here is my latest issue with replication: I have 3 systems, X, Y and Z. Initially X is replicated to Y and Y is replicated to Z; in each case the replication involves log-shipping using archive_command and restore_command (via a 4th sy

Re: During promotion, new master tries to archive same segment twice

Hi Phil, On 8/15/18 4:25 PM, Phil Endecott wrote: > > Questions: > > - Can all of this be blamed on the failure of the first attempt > to promote due to the wrong permissions on recovery.conf? Yes, it looks that way. > - Should my archive_command detect the case where it is asked to > write

Re: Odd Row Estimates in Query Plan (rows=75)

On Wed, Aug 15, 2018 at 3:31 PM, Adrian Klaver wrote: > > lts.date_added > '2017-07-14 11:13:05' > > and > > lts.date_gifted >= '2017-08-13 11:13:05' > ? > > In other words one '>' and the other '>=' ? > The date_added filters were added just to use that index and with a broad r

Re: Odd Row Estimates in Query Plan (rows=75)

On 08/15/2018 01:03 PM, Don Seiler wrote: Here's the query, obfuscated manually by me: SELECT         'Foo' as system_function, stores.name as store,         lt.owner,         lt.minute_of_day,         lt.records         FROM         foo.stores         LEFT OUTER JOIN

During promotion, new master tries to archive same segment twice

Dear Experts, Here is my latest issue with replication: I have 3 systems, X, Y and Z. Initially X is replicated to Y and Y is replicated to Z; in each case the replication involves log-shipping using archive_command and restore_command (via a 4th system called "backup") and then streaming. T

Re: Odd Row Estimates in Query Plan (rows=75)

Here's the query, obfuscated manually by me: SELECT 'Foo' as system_function, stores.name as store, lt.owner, lt.minute_of_day, lt.records FROM foo.stores LEFT OUTER JOIN (SELECT lts.store_pkey,

Re: Odd Row Estimates in Query Plan (rows=75)

On 08/15/2018 12:31 PM, Don Seiler wrote: PostgreSQL 9.6.6 on CentOS. We have a report query that has gone from maybe a few seconds to run to a few minutes to run since mid-July. Looking at the output of EXPLAIN ANALYZE, the row count estimates are way off, even though this table was just ana

Re: Code of Conduct plan

Stephen Frost writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> Unless there are substantial objections, or nontrivial changes as a result >> of this round of comments, we anticipate making the CoC official as of >> July 1 2018. > We seem to be a bit past that timeline... Do we have any update

Odd Row Estimates in Query Plan (rows=75)

PostgreSQL 9.6.6 on CentOS. We have a report query that has gone from maybe a few seconds to run to a few minutes to run since mid-July. Looking at the output of EXPLAIN ANALYZE, the row count estimates are way off, even though this table was just analyzed a day or so ago. What's more bizarre to m

Re: Code of Conduct plan

On Wed, Aug 15, 2018 at 03:22:10PM -0400, Stephen Frost wrote: > Greetings, > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > Unless there are substantial objections, or nontrivial changes as a result > > of this round of comments, we anticipate making the CoC official as of > > July 1 2018. > > We

Re: Code of Conduct plan

Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Unless there are substantial objections, or nontrivial changes as a result > of this round of comments, we anticipate making the CoC official as of > July 1 2018. We seem to be a bit past that timeline... Do we have any update on when this will

Re: moving data to from ms sql server via SSIS

On 08/15/2018 11:03 AM, cosmin ioan wrote: hi folks, we're trying to phase out MS SQL Server and we're trying to understand the easiest way to move data from MS SQL Server to postgres, via SSIS, say via ODBC, OleDB or .Net drivers, and basically create new tables & move data, into the target p

moving data to from ms sql server via SSIS

hi folks, we're trying to phase out MS SQL Server and we're trying to understand the easiest way to move data from MS SQL Server to postgres, via SSIS, say via ODBC, OleDB or .Net drivers, and basically create new tables & move data, into the target postgres db. What drivers would be the best/most

Re: using graph model with PostgreSQL

On 08/15/2018 07:09 AM, 김세훈 wrote: Hi there, currently I'm using PostgreSQL with PostGIS extension to handle geospatial data. In my project I need to apply some graph algorithms like MST for some network of GPS coordinates. I know there is some way of using Neo4j with PostgreSQL but is the

Re: How to revoke privileged from PostgreSQL's superuser

On Tue, Aug 14, 2018 at 03:59:19PM -0400, Bruce Momjian wrote: > On Fri, Aug 10, 2018 at 04:06:40PM -0400, Benedict Holland wrote: > > I also would take Bruce's comment with a massive grain of salt. Everything > > that > > everyone does on a database is logged somewhere assuming proper logging. >

using graph model with PostgreSQL

Hi there, currently I'm using PostgreSQL with PostGIS extension to handle geospatial data. In my project I need to apply some graph algorithms like MST for some network of GPS coordinates. I know there is some way of using Neo4j with PostgreSQL but is there any other way to construct graph mode