Re: [GENERAL] PostgreDB stores table name is lower case

"=?gb18030?B?zfWyqA==?=" <853372...@qq.com> writes: > Now, I have a problem, the table name is stored in lower case , but i > want to change it into upper case. Can i have a simple method? Such as > modify a parameter. No. We have looked into making that configurable, and the

Re: [GENERAL] PostgreDB stores table name is lower case

On 11/23/2016 11:52 PM, wrote: > Hello ?? > > I'am a Postgre fan. > Now, I have a problem, the table name is stored in lower case , > but i want to change it into upper case. Can i have a simple method? > Such as modify a parameter.

Re: [GENERAL] Query regarding deadlock

On Thu, Nov 24, 2016 at 5:44 PM, Yogesh Sharma < yogesh1.sha...@nectechnologies.in> wrote: > Dear All, > > Thanks in advance. > I found below deadlock in postgresql logs. > I cannot change calling of REINDEX and insert query sequence because it is > execute automatically through some cron script.

Re: [GENERAL] PostgreDB stores table name is lower case

On 24/11/16 20:52, wrote: Hello ?? I'am a Postgre fan. Now, I have a problem, the table name is stored in lower case , but i want to change it into upper case. Can i have a simple method? Such as modify a parameter. Thank you! Why? I can't see any practical

Re: [GENERAL] performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains

Hey Tom, I appreciate you're busy, but did you ever get a chance to look at this? On 19/09/2016 08:40, Chris Withers wrote: On 16/09/2016 15:29, Tom Lane wrote: Chris Withers writes: On 16/09/2016 14:54, Igor Neyman wrote: So, what is the value for "end ts", when

[GENERAL] PostgreDB stores table name is lower case

Hello ?? I'am a Postgre fan. Now, I have a problem, the table name is stored in lower case , but i want to change it into upper case. Can i have a simple method? Such as modify a parameter. Thank you!

Re: [GENERAL] Backup "Best Practices"

On Wed, Nov 23, 2016 at 10:16 AM, Israel Brewster wrote: > I was wondering if someone could inform me about, or point me to an online > article about best practices for backing up a postgresql database cluster? > At the moment, I have two servers running with streaming

Re: [GENERAL] pg_am access in simple transaction?

pinker writes: > I'm doing simple tests with lsof on data catalog with bash script: > #!/bin/bash > for i in {0..2000} > do > psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'& > done > and i measure number of open files and what files are affected by specific >

Re: [GENERAL] pg_am access in simple transaction?

On 11/25/2016 07:04 AM, pinker wrote: Adrian Klaver-4 wrote I can not replicate using 50 clients instead of 2000. I suspect either has to do with the extreme number of clients or it is an artifact of from some other process. And I have replicated it with 50 clients as well... lsof output: 51

Re: [GENERAL] Replicating hundreds of thousandw of rows

Il 25/11/2016 15:23, Job ha scritto: Hello, Hello, we are using rybyrep with postgresql 9.1 and 9.5 to have (almost-) real time synchronization for 5 years ATM. Unfortunately, it seems a dead project, so we had to find a good JRuby developer to make some customizations. we need to replicate

Re: [GENERAL] pg_am access in simple transaction?

Adrian Klaver-4 wrote > I can not replicate using 50 clients instead of 2000. I suspect either > has to do with the extreme number of clients or it is an artifact of > from some other process. And I have replicated it with 50 clients as well... lsof output: 51 data/base/13328/2601 command:

Re: [GENERAL] query locks up when run concurrently

On 11/24/2016 02:14 PM, azhwkd wrote: Adrian Klaver > schrieb am Do., 24. Nov. 2016 um 22:34 Uhr: On 11/24/2016 01:23 PM, azhwkd wrote: > It should not be possible because a group does not return to the > update pool

Re: [GENERAL] pg_am access in simple transaction?

On 11/25/2016 04:40 AM, pinker wrote: Hi, I'm doing simple tests with lsof on data catalog with bash script: #!/bin/bash for i in {0..2000} do psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'& done and i measure number of open files and what files are affected by specific

Re: [GENERAL] Replicating hundreds of thousandw of rows

On 25 November 2016 at 06:23, Job wrote: > Hello, > > we need to replicate hundreds of thousands of rows (for reporting) between > Postgresql Database nodes that are in different locations. > > Actually, we use Rubyrep with Postgresql 8.4.22. 8.4 is now end-of-life.

[GENERAL] Replicating hundreds of thousandw of rows

Hello, we need to replicate hundreds of thousands of rows (for reporting) between Postgresql Database nodes that are in different locations. Actually, we use Rubyrep with Postgresql 8.4.22. It works fine but it is very slow with a massive numbers of rows. With Postgresql 9.x, are there some

[GENERAL] pg_am access in simple transaction?

Hi, I'm doing simple tests with lsof on data catalog with bash script: #!/bin/bash for i in {0..2000} do psql -U postgres -c '*BEGIN; select pg_sleep(30); COMMIT*'& done and i measure number of open files and what files are affected by specific command. Lsof has shown me that the only

Re: [GENERAL] pg_dump system catalog

On 25/11/2016 13:11, Juliano wrote: Hi everyone, How can I *use pg_dump* to do a backup of *"system catalogs"* only? pg_dump --schema=pg_catalog Regards, Juliano -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

[GENERAL] pg_dump system catalog

Hi everyone, How can I use pg_dump to do a backup of "system catalogs" only? Regards, Juliano

Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

I updated odbc drivers and it worked. Thanks everyone Regards, Juliano Sent with [ProtonMail](https://protonmail.com) Secure Email. Original Message Subject: Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)