Re: [GENERAL] EXPLAIN command just hangs...

That helps, thanks Peter. Regards, Ruan From: pgsql-general-ow...@postgresql.org on behalf of Peter J. Holzer Sent: 03 November 2017 08:49 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] EXPLAIN

Re: [GENERAL]

Thanks for the explanation Kevin! Regards, Ruan From: pgsql-general-ow...@postgresql.org on behalf of K. Brannen Sent: 03 November 2017 14:35 To: pgsql-general@postgresql.org Subject: [GENERAL] Rhhh

Re: [GENERAL] EXPLAIN command just hangs...

Thanks Justin, Yeah, I'd agree it would be much easier to show you direct command output but I'm prohibited due to the security and sensitive nature of my work environment. A few observations I had earlier this evening. I created a CTAS copy of the table in order to mirror it from its

Re: [GENERAL] gin index trouble

On 10/30/2017 10:56 AM, Peter Geoghegan wrote: On Mon, Oct 30, 2017 at 9:45 AM, Rob Sargent wrote: Peter, you beat me to the punch. I was just about to say "Having read the referenced message I thought I would add that we never delete from this table." In this

Re: [GENERAL] EXPLAIN command just hangs...

On Fri, Nov 03, 2017 at 09:12:02PM +, Rhhh Lin wrote: > I checked for dead tuples against that particular table initially as I have > seen performance problems before in a related 'busy' environment which needed > its frequency of vacuuming to be increased. So I have a query to check for >

Re: [GENERAL] EXPLAIN command just hangs...

Hi Justin, I checked for dead tuples against that particular table initially as I have seen performance problems before in a related 'busy' environment which needed its frequency of vacuuming to be increased. So I have a query to check for table with dead tuples and this table is not showing

Re: [GENERAL] Adding 'serial' to existing column

On Fri, 2017-11-03 at 16:47 -0400, Tom Lane wrote: > Robert Lakes writes: > > I am new to Postgres and I am trying to build this SQL statement in > > my SQL > > script: > > ALTER TABLE listings_cdc ALTER COLUMN table_id SET DEFAULT > > nextval('tab_id_seq'); > > That looks

Re: [GENERAL] EXPLAIN command just hangs...

Thanks for replying Tom. Ah, I misunderstood the purpose of what you were looking for from the "ps" command. Most definitely, the postgres process for this session is eating up CPU cycles. That fact is what drew us to investigate the session activity in the first place. The CPU (8 cores) on

Re: [GENERAL] Adding 'serial' to existing column

Robert Lakes writes: > I am new to Postgres and I am trying to build this SQL statement in my SQL > script: > ALTER TABLE listings_cdc ALTER COLUMN table_id SET DEFAULT > nextval('tab_id_seq'); That looks correct, but this not so much: > I am trying to build the

[GENERAL] Adding 'serial' to existing column

I am new to Postgres and I am trying to build this SQL statement in my SQL script: ALTER TABLE listings_cdc ALTER COLUMN table_id SET DEFAULT nextval('tab_id_seq'); I am trying to build the above-stated command as a dynamic SQL statement: EXECUTE 'ALTER TABLE listings_cdc ALTER COLUMN table_id

Re: [GENERAL] [HACKERS] SSL and Encryption

On Fri, Nov 3, 2017 at 4:12 PM, Jeff Janes wrote: > On Thu, Nov 2, 2017 at 10:22 PM, John R Pierce wrote: >> >> On 11/2/2017 10:12 PM, Jeff Janes wrote: >>> >>> https://wiki.postgresql.org/wiki/List_of_drivers >>> >>> What is 'python native'? psycopg

Re: [GENERAL] Postgres 10 manual breaks links with anchors

On 10/16/17 03:19, Thomas Kellerer wrote: > I don't know if this is intentional, but the Postgres 10 manual started to > use lowercase IDs as anchors in the manual. > > So, if I have e.g.: the following URL open in my browser: > > >

Re: [GENERAL] [HACKERS] SSL and Encryption

On Thu, Nov 2, 2017 at 10:22 PM, John R Pierce wrote: > On 11/2/2017 10:12 PM, Jeff Janes wrote: > >> https://wiki.postgresql.org/wiki/List_of_drivers >> >> What is 'python native'? psycopg works as long you update your libpq. >> > > > I thought pythonistas preferred using

[GENERAL]

Rhhh Lin wrote: > *Also, as a sidenote - can someone please expand on why one (I was not > involved in the creation of this DB/schema definition) would choose to have > the definition of the timestamp column as a bigint in this case? Because the time value you need to

[GENERAL] Hot Standby syntax error

Is the below syntax correct in the recovery.conf file: restore_command = 'copy "D:\\apps\postgres\pg_archivelog\\%f" "%p"' archive_cleanup_command = 'pg_archivecleanup "D:\\apps\\postgres\\pg_archivelog\\" %r' And the lines is corrent in portgresql.conf file: archive_command = 'copy "%p"

Re: [GENERAL] Postgresql.conf not found

Hi, Am 03.11.2017 um 12:51 schrieb Neto pr: But I'm not finding where the postgresql.conf file is. you can ask the database, inside psql: test=# show config_file; config_file - /etc/postgresql/10/main/postgresql.conf (1 Zeile)

Re: [GENERAL] Postgresql.conf not found

Hi, You can find the file locations on https://wiki.debian.org/PostgreSql#File_locations You should find the configuration in /etc/postgresql/9.6/main. Kind regards, On 11/03/2017 12:51 PM, Neto pr wrote: > > Hello All > > I was trying to install postgresql by this tutorial >

[GENERAL] Postgresql.conf not found

Hello All I was trying to install postgresql by this tutorial http://powa.readthedocs.io/en/latest/quickstart.html to use the tool for bd Powa. I am use S.O. debian 8 Jessie. I ran: apt-get install postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6 apt-get install postgresql-9.6-powa

Re: [GENERAL] [HACKERS] SSL and Encryption

On Fri, Nov 3, 2017 at 5:22 AM, John R Pierce wrote: > On 11/2/2017 10:12 PM, Jeff Janes wrote: >> >> https://wiki.postgresql.org/wiki/List_of_drivers >> >> What is 'python native'? psycopg works as long you update your libpq. > > I thought pythonistas preferred using a

Re: [GENERAL] EXPLAIN command just hangs...

On 2017-11-02 20:51:23 +, Rhhh Lin wrote: [...] > where timestamp BETWEEN 150667656 AND 150875022 [...] > *Also, as a sidenote - can someone please expand on why one (I was not > involved > in the creation of this DB/schema definition) would choose to have the > definition of the