[GENERAL] Debugger locks up

We have a PgAdmin PLPgSQL debugger issue. We are running it on the same server with the database and there is not much else besides Postgres running on that server. Windows server 2012 OS. We have tried running it as the admin role and a superuser role - neither one fixes the issue. While it is

Re: [GENERAL] ??: postgres cpu 100% need help

On Tue, Nov 10, 2015 at 8:26 AM, Merlin Moncure wrote: > On Sun, Nov 8, 2015 at 7:22 AM, 莎士比亚说： <657985...@qq.com> wrote: >> Hi moran and others; >> >> yesterday i get the pg problem again, and i use perf top Observation >> follows: >> PerfTop: 11574 irqs/sec kernel:

Re: [GENERAL] Slow response if pulling through pgadmin

Ok . thanks .. this is our first foray into postgresql and we were comparing retrieve times based on the 'normal' Microsoft SQL environment to ensure that we were at least functioning properly. Long term, our goal is to restructure that table into a star-schema/mdm type format to ease the

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

I found this link explaining how to launch multiple instances. I was not able to find detailed steps like these in the postgres docs. Is this accurate from what you perceive? It also says to have separate init.d scripts (startup). Thanks

Re: [GENERAL] Deadlock detected after pg_repack receives SIGINT

On 11/5/15 12:14 AM, Jiří Hlinka wrote: I'm doing simple UPDATES, INSERTs and DELETEs on this table, but frequency of these DMLs is _very_ high (it is a queue table used for a one-way selective [just part of data are replicated] replication of queries between two instances of the database, lets

Re: [GENERAL] Slow response if pulling through pgadmin

On 11/10/2015 07:39 AM, Mammarelli, Joanne T wrote: Hi – same rookie user as before. We have one table 100,000 rows 80 columns When we try to retrieve the data (select * from table) using pgadmin, we get a 193456 ms retrieve time. Where is the client(pgAdmin) relative to the server? Where

Re: [GENERAL] Slow response if pulling through pgadmin

On 11/10/2015 08:20 AM, Mammarelli, Joanne T wrote: Ok . thanks .. this is our first foray into postgresql and we were comparing retrieve times based on the 'normal' Microsoft SQL environment to ensure that we were at least functioning properly. So what are 'normal times' and where and in

Re: [GENERAL] Disk I/O Question

On 11/10/15 8:34 AM, tbro wrote: What I've read about PostgreSQL is that it's a single-thread disk I/O system where only one read/write operation executes at a time. Definitely false. However... Other databases support asynchronous IO, where the database tries to issue IO requests before

Re: [GENERAL] Slow response if pulling through pgadmin

Pgadmin is on the same server 316ms for a 'query analyze select * from table' when run from the command line (same directory psql is in) The biggest concern is that we are hoping to hook up an external BI tool (such as QlikView, for example) and even with QlikView (through an odbc connector)

Re: [GENERAL] Slow response if pulling through pgadmin

I would also like to add that I am very suspicious of a table with 80 columns. Offhand, it sounds like poor database design where someone was trying to put all the eggs in one basket (figuratively). Further, what was the exact query? Queries of the form SELECT * will always be inherently slow

[GENERAL] Disk I/O Question

Hello - I am new to this forum and know nothing about PostgreSQL. I have managed Microsoft SQL for 15 years (I know ) We have a third party application that uses PostgreSQL for the database engine. Performance writing to our Dell Compellent SAN is lacking. What I've read about PostgreSQL is

Re: [GENERAL] Disk I/O Question

On 11/10/2015 06:34 AM, tbro wrote: Hello - I am new to this forum and know nothing about PostgreSQL. I have managed Microsoft SQL for 15 years (I know ) We have a third party application that uses PostgreSQL for the database engine. Performance writing to our Dell Compellent SAN is

Re: [GENERAL] tds_fdw - work on windows

Are there any options for linking a Microsoft sql database to a postgresql database? (I want the postgresql database to be the "puller") -Original Message- From: Jim Nasby [mailto:jim.na...@bluetreble.com] Sent: Tuesday, November 10, 2015 10:21 AM To: Mammarelli, Joanne T;

Re: [GENERAL] Slow response if pulling through pgadmin

On 11/10/15 9:39 AM, Mammarelli, Joanne T wrote: Hi – same rookie user as before. We have one table 100,000 rows 80 columns When we try to retrieve the data (select * from table) using pgadmin, we get a 193456 ms retrieve time. When I ran a query analyze in the command prompt, we get a

Re: [GENERAL] Disk I/O Question

On 10 November 2015 at 14:34, tbro wrote: > We have a third party application that uses PostgreSQL for the database > engine. Performance writing to our Dell Compellent SAN is lacking. > > What I've read about PostgreSQL is that it's a single-thread disk I/O > system > where

Re: [GENERAL] Disk I/O Question

2015-11-10 15:34 GMT+01:00 tbro : > Hello - I am new to this forum and know nothing about PostgreSQL. I have > managed Microsoft SQL for 15 years (I know ) > > We have a third party application that uses PostgreSQL for the database > engine. Performance writing to our Dell

Re: [GENERAL] Debugger locks up

Postgres 9.4 From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bradley, Christie D Sent: Tuesday, November 10, 2015 7:24 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Debugger locks up We have a PgAdmin PLPgSQL debugger issue. We are

Re: [GENERAL] tds_fdw - work on windows

On 11/10/2015 07:37 AM, Mammarelli, Joanne T wrote: Are there any options for linking a Microsoft sql database to a postgresql database? (I want the postgresql database to be the "puller") How did you install Postgres on the Windows machine? If through the graphical installer from EDB, you

Re: [GENERAL] "Web of trust" connections

On 11/6/15 8:01 AM, Mark Morgan Lloyd wrote: Purely out of curiosity, is there any way of using some sort of "web of trust" (comparable with GPG or whatever) when verifying server and client certificates, rather than going back to a centralised CA? My apologies if this is a silly question, or

Re: [GENERAL] tds_fdw - work on windows

On 11/10/15 7:57 AM, Mammarelli, Joanne T wrote: Hi – rookie user here. I’d like to access data on my Microsoft sql database from my postgres database. I stumbled upon the tds_fdw extension and it reads as if it it’s *nix only. Would acquiring tds_fdw.control from one of the repos possibly

Re: [GENERAL] Debugger locks up

On 11/10/15 9:30 AM, Bradley, Christie D wrote: Postgres 9.4 *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] *On Behalf Of *Bradley, Christie D *Sent:* Tuesday, November 10, 2015 7:24 AM *To:* pgsql-general@postgresql.org *Subject:* [GENERAL] Debugger

[GENERAL] Slow response if pulling through pgadmin

Hi - same rookie user as before. We have one table 100,000 rows 80 columns When we try to retrieve the data (select * from table) using pgadmin, we get a 193456 ms retrieve time. When I ran a query analyze in the command prompt, we get a 316ms retrieve time. .. and finally. When we

Re: [GENERAL] Slow response if pulling through pgadmin

On 11/10/2015 08:11 AM, Mammarelli, Joanne T wrote: Pgadmin is on the same server 316ms for a 'query analyze select * from table' when run from the command line (same directory psql is in) I know of no such command 'query analyze..' in Postgres. So are you using some other tool? Or are you

Re: [GENERAL] "Web of trust" connections

Jim Nasby wrote: On 11/6/15 8:01 AM, Mark Morgan Lloyd wrote: Purely out of curiosity, is there any way of using some sort of "web of trust" (comparable with GPG or whatever) when verifying server and client certificates, rather than going back to a centralised CA? My apologies if this is a

Re: [GENERAL] Best tool to pull from mssql

On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: Hi .. we’re on a hunt to locate either pgloader or the tds_fdw extension to assist us with pulling data FROM a Microsoft sql server (we’re a windows-based postgres installation). So are we taking about a one time operation or continuously

Re: [GENERAL] Disk I/O Question

Fair question Let me elaborate. The command was simply to test the speed at which data can be written to disk. Postgre comes into play with the monitoring application itself. Information pertaining to the 5000+ devices being monitored is sent to the monitoring application and written to the

Re: [GENERAL] Best tool to pull from mssql

Thanks - I've been dying trying to find the software (on the windows side) for part 3 .. https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/ -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent:

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

Yes, the instance already running is live in that users are indirectly querying/writing to it. I just need to launch a 2nd instance. On Mon, Nov 9, 2015 at 9:57 PM, Adrian Klaver wrote: > On 11/09/2015 06:03 PM, anj patnaik wrote: > > CCing list > >> I used the

Re: [GENERAL] Disk I/O Question

The third party application is locked down and we do not have root access to the server. We have reached out to them for the version number of PostgreSQL. The application server is a virtual machine (RedHat 6) running on VMware 5.5. This is a stand-alone host server running only the third party

Re: [GENERAL] Disk I/O Question

On 11/10/2015 10:58 AM, tbro wrote: The application is called Nable and is owned by Solarwinds http://www.n-able.com Is it the application that is using Postgres? What would really help is some sort of schematic of how data is flowing through the system and exactly where the hangup is.

Re: [GENERAL] Best tool to pull from mssql

Are there any type of 'pgadmin' like interfaces for the linux side? -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 2:12 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from

Re: [GENERAL] Best tool to pull from mssql

Continuously syncing .. we have database in mssql. Ideally we'd like to connect to the mssql databases and pull out the fields/content we required and populate that in a postgres database. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday,

Re: [GENERAL] Disk I/O Question

On 11/10/2015 10:58 AM, tbro wrote: The application is called Nable and is owned by Solarwinds http://www.n-able.com It is not uncommon for DAS to be much faster than NAS/SAN. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack

[GENERAL] Best tool to pull from mssql

Hi .. we're on a hunt to locate either pgloader or the tds_fdw extension to assist us with pulling data FROM a Microsoft sql server (we're a windows-based postgres installation). Is this the proper way to handle the process?

Re: [GENERAL] Disk I/O Question

On 11/10/2015 08:23 AM, tbro wrote: The third party application is locked down and we do not have root access to the server. We have reached out to them for the version number of PostgreSQL. The application server is a virtual machine (RedHat 6) running on VMware 5.5. This is a

Re: [GENERAL] Disk I/O Question

On 11/10/2015 10:42 AM, tbro wrote: Fair question Let me elaborate. The command was simply to test the speed at which data can be written to disk. Postgre comes into play with the monitoring application itself. Information pertaining to the 5000+ devices being monitored is sent to the

Re: [GENERAL] Best tool to pull from mssql

On 11/10/2015 11:13 AM, Mammarelli, Joanne T wrote: Are there any type of 'pgadmin' like interfaces for the linux side? You can use pgAdmin on Windows to look at/manage Postgres servers on any platform as long as it is reachable. You can also install pgAdmin on Linux if you desire, but that

Re: [GENERAL] Best tool to pull from mssql

On 11/10/2015 10:26 AM, Mammarelli, Joanne T wrote: Continuously syncing .. we have database in mssql. Ideally we'd like to connect to the mssql databases and pull out the fields/content we required and populate that in a postgres database. When all else fails you can go the ODBC route. I

Re: [GENERAL] Best tool to pull from mssql

On 11/10/2015 11:06 AM, Mammarelli, Joanne T wrote: Thanks - I've been dying trying to find the software (on the windows side) for part 3 .. https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/ Another option would be to install

Re: [GENERAL] run 2 instances of postgres 9.4 on same linux VM

On 11/10/2015 07:49 AM, anj patnaik wrote: Yes, the instance already running is live in that users are indirectly querying/writing to it. I just need to launch a 2nd instance. If you are going to stick with the graphical installer I would probably post a question here:

Re: [GENERAL] Disk I/O Question

På tirsdag 10. november 2015 kl. 17:23:15, skrev tbro >: The third party application is locked down and we do not have root access to the server.  We have reached out to them for the version number of PostgreSQL. The application server is a virtual

Re: [GENERAL] Disk I/O Question

The application is called Nable and is owned by Solarwinds http://www.n-able.com -- View this message in context: http://postgresql.nabble.com/Disk-I-O-Question-tp5873364p5873428.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing

Re: [GENERAL] Unexpected Results from regexp_replace

Excellent! I tried the global flag before but I had it in the wrong place. Thanks for the quick service, David! --- Susan E Hurst Principal Consultant Email: susan.hu...@brookhurstdata.com Mobile: 314-486-3261 On 2015-11-10 14:19, David G.

[GENERAL] Unexpected Results from regexp_replace

I would like to extract only letters and numbers [0-9a-z] from an input string. Using regexp_replace in postgres, I get unexpected results. The pattern matching seems to stop before the end of the string value is reached. Some of the values that should have been excluded are still there.

[GENERAL] attempting to install tds_fw-master on redhat

The following postgresql rpm is installed .. rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64 on redhat 7 Red Hat Enterprise Linux Server release 7.1 (Maipo) Currently following the instructions at the following link in attempt to create the extension:

Re: [GENERAL] Unexpected Results from regexp_replace

On Tue, Nov 10, 2015 at 1:12 PM, Susan Hurst wrote: > What is the trick for removing all instances of unwanted characters and > spaces? ​(g)lobal flag. SELECT regexp_replace('hello - world n', '[^0-9a-z]+', '', 'g') ​; David J.​

Re: [GENERAL] attempting to install tds_fw-master on redhat

On 11/10/2015 12:53 PM, Mammarelli, Joanne T wrote: The following postgresql rpm is installed .. rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64 on redhat 7 Red Hat Enterprise Linux Server release 7.1 (Maipo) Currently following the instructions at the following link in attempt to

Re: [GENERAL] can postgres run well on NFS mounted partitions?

anj patnaik wrote: > Can anyone advise if there are problems running postgres over NFS mounted > partitions? > > I do need reliability and high speed. I have got the advice not to use NFS from a number of people who should know, but there are also knowledgable people who use PostgreSQL with

Re: [GENERAL] xa compatibility

Xaver Thum wrote: > is there an option (provided by Postgres) accessing a Postgres DB via the > standard XA interface ? > > I don't mean the usage of JDBC's class PGXADataSource, > but the usual XA methods xa_open, xa_prepare, xa_commit, ... of the XA > standard. I am not sure why there is no

Re: [GENERAL] xa compatibility

On 10/11/2015 09:34, Xaver Thum wrote: Hi all, is there an option (provided by Postgres) accessing a Postgres DB via the standard XA interface ? I don't mean the usage of JDBC's class PGXADataSource, but the usual XA methods xa_open, xa_prepare, xa_commit, ... of the XA standard. You

Re: [GENERAL] can postgres run well on NFS mounted partitions?

Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11) and Postgres 9.4. I ran some insertions today from a client running on Windows. The client does a loop of 30 updates. I am seeing about 10-20% increase in latency in the case where DB is on NFS (over TCP) compared to

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Tue, Nov 10, 2015 at 6:26 PM, anj patnaik wrote: > Thanks for the feedback. I have setup a second Linux VM (running RHEL > 5.11) and Postgres 9.4. I ran some insertions today from a client running > on Windows. The client does a loop of 30 updates. > > I am seeing about

Re: [GENERAL] ??: postgres cpu 100% need help

On Sun, Nov 8, 2015 at 7:22 AM, 莎士比亚说： <657985...@qq.com> wrote: > Hi moran and others; > > yesterday i get the pg problem again, and i use perf top Observation > follows: > PerfTop: 11574 irqs/sec kernel: 2.2% exact: 0.0% [4000Hz cycles], > (all, 32 CPUs) > 81.39% postgres

[GENERAL] tds_fdw - work on windows

Hi - rookie user here. I'd like to access data on my Microsoft sql database from my postgres database. I stumbled upon the tds_fdw extension and it reads as if it it's *nix only. Would acquiring tds_fdw.control from one of the repos possibly work on a windows-based postgres installed database?

Re: [GENERAL] Error when test on DBT2 Postgresql

Hi adrian, Thanks for your help. I think I know why the performance is not good. I misunderstand the document. So in my test, there are thinking time and keying time for each transaction. When I remove the thinking time and keying time, the performance become 1500 new order txns/mins. Your

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Tue, Nov 10, 2015 at 4:26 PM, anj patnaik wrote: > Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11) > and Postgres 9.4. I ran some insertions today from a client running on > Windows. The client does a loop of 30 updates. > > I am seeing about