Re: psql format result as markdown tables

2018-01-13 Thread Tom Lane
Stephen Frost writes: > I suspect that if someone wanted to write the code to have markdown be > available that it would certainly be accepted, as that's definitely a > popular format. Somebody was working on that awhile ago, https://www.postgresql.org/message-id/flat/CAAYBy8YU4pXYKDHeQhsA_%3DFC

Re: psql format result as markdown tables

2018-01-13 Thread Stephen Frost
Greetings Melvin, * Melvin Davidson (melvin6...@gmail.com) wrote: > On Sat, Jan 13, 2018 at 4:50 AM, Nicolas Paris wrote: > > I wonder if someone knows how to configure psql to output results as > > markdown tables. > > Then instead of : > > > > SELECT * FROM (values(1,2),(3,4)) as t; > > column

Re: psql format result as markdown tables

2018-01-13 Thread Stephen Frost
Hi Nicolas! * Nicolas Paris (nipari...@gmail.com) wrote: > I wonder if someone knows how to configure psql to output results as > markdown tables. Unfortunately, I don't believe we support markdown as an output format as yet. To change the output format, you can use '\pset format html'. You ca

Re: psql format result as markdown tables

2018-01-13 Thread Melvin Davidson
On Sat, Jan 13, 2018 at 4:50 AM, Nicolas Paris wrote: > Hello > > I wonder if someone knows how to configure psql to output results as > markdown tables. > Then instead of : > > SELECT * FROM (values(1,2),(3,4)) as t; > column1 | column2 > -+- >1 | 2 >3 |

Re: Postgres 9.4 using primary key index in almost all queries leading to degraded performance

2018-01-13 Thread Tom Lane
Rahul Sharma writes: > We're currently testing out upgrade of our Postgres database from 9.3.14 to > 9.4.9. We are using Amazon RDS. We've encountered an issue in testing > phase where after the upgrade, CPU utilization hovers around 100%. We dug > deep to find that the queries which executed in

Re: pg_basebackup is taking more time than expected

2018-01-13 Thread Stephen Frost
Greetings, * Raghavendra Rao J S V (raghavendra...@gmail.com) wrote: > I am asking in my previous mail as, Does the pg_basebackup depends on any > of the postgres configuration parameters likes shared > buffer/maintanance_work_memory etc? If yes, which are those configuration > parameters, I need

Re: pg_basebackup is taking more time than expected

2018-01-13 Thread Raghavendra Rao J S V
Thank you very much for your prompt response. I am asking in my previous mail as, Does the pg_basebackup depends on any of the postgres configuration parameters likes shared buffer/maintanance_work_memory etc? If yes, which are those configuration parameters, I need to take care/increase the value

Re: pg_basebackup is taking more time than expected

2018-01-13 Thread Raghavendra Rao J S V
Please let me know below details. pg_basebackup utility depends on which are the parameters? Is there any possibility to run the pg_basebackup in multi thread? To improve the speed of the backup of database using pg_basebackup utility we shutdown the database and started alone database services

Re: pg_basebackup is taking more time than expected

2018-01-13 Thread Stephen Frost
Greetings, Please don't top-post on the PG mailing lists. * Raghavendra Rao J S V (raghavendra...@gmail.com) wrote: > pg_basebackup utility depends on which are the parameters? I'm not sure what you're asking here. > Is there any possibility to run the pg_basebackup in multi thread? No, not t

Postgres 9.4 using primary key index in almost all queries leading to degraded performance

2018-01-13 Thread Rahul Sharma
Hi, We're currently testing out upgrade of our Postgres database from 9.3.14 to 9.4.9. We are using Amazon RDS. We've encountered an issue in testing phase where after the upgrade, CPU utilization hovers around 100%. We dug deep to find that the queries which executed in a few milliseconds on Pos

Re: Missing WAL file after running pg_rewind

2018-01-13 Thread Michael Paquier
On Fri, Jan 12, 2018 at 09:44:25PM +, Dylan Luong wrote: > The file exist in the archive directory of the old master but it is > for the previous timeline, ie 5 and not 6, ie > 0005038300BE. Can I just rename the file to 6 timeline? Ie > 0006038300BE What are the conte

psql format result as markdown tables

2018-01-13 Thread Nicolas Paris
Hello I wonder if someone knows how to configure psql to output results as markdown tables. Then instead of : SELECT * FROM (values(1,2),(3,4)) as t; column1 | column2 -+- 1 | 2 3 | 4 Get the result as : SELECT * FROM (values(1,2),(3,4)) as t; | colum