Re: [GENERAL] About the tps explanation of pgbench, please help

2014-11-19 Thread Francisco Olarte
Hi Yanrui: On Wed, Nov 19, 2014 at 2:48 AM, Yanrui Hu y...@appannie.com wrote: I am partly understanding your explain. Enough for me, it isn't a simple thing to write :) the including connection establish case means the db connection not only socket connection, the excluding connection

[GENERAL] [general] Error while decrypting using pgp

2014-11-19 Thread VENKTESH GUTTEDAR
Hello, I am running postgresql 9.3.5 on Ubuntu14.04. i have the table two fields of varchar type. while inserting the data in the following way. INSERT INTO testusers(username, phone_no) SELECT pgp_sym_encrypt(test.username, keys.pubkey), pgp_sym_encrypt(test.phone_no,

[GENERAL] postgresql for small business

2014-11-19 Thread Ernesto Quiñones
Hi friends I am looking for a postgresql solution in an appliance for small business know somebody who is selling this kind of solutions? thanks -- -- Visita : http://www.eqsoft.net

Re: [GENERAL] postgresql for small business

2014-11-19 Thread Alberto Cabello Sánchez
On Wed, 19 Nov 2014 06:54:46 -0500 Ernesto Quiñones ernes...@gmail.com wrote: Hi friends I am looking for a postgresql solution in an appliance for small business I guess something like Fujitsu SX2 HA DB is beyond the budget of a small business, but usually this is the case with an appliance

Re: [GENERAL] postgresql for small business

2014-11-19 Thread Eric Pierce
On 11/19/14, 6:54 AM, Ernesto Quiñones ernes...@gmail.com wrote: Hi friends I am looking for a postgresql solution in an appliance for small business know somebody who is selling this kind of solutions? thanks -- If you are OK with a cloud based solution, Amazon RDS might be a decent fit

Re: [HACKERS] [GENERAL] Performance issue with libpq prepared queries on 9.3 and 9.4

2014-11-19 Thread Robert Haas
On Mon, Nov 17, 2014 at 4:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Nov 13, 2014 at 7:34 PM, Tom Lane t...@sss.pgh.pa.us wrote: One thing that occurs to me is that if the generic plan estimate comes out much cheaper than the custom one, maybe

Re: [GENERAL] postgresql for small business

2014-11-19 Thread Adrian Klaver
On 11/19/2014 03:54 AM, Ernesto Quiñones wrote: Hi friends I am looking for a postgresql solution in an appliance for small business Appliance has multiple meanings these days. Are you looking for a software 'appliance' or a complete hardware solution? What do you want this appliance to

Re: [GENERAL] issue with double ordering in a wrapped distinct

2014-11-19 Thread Jonathan Vanasco
I re-ran the query in multiple forms, and included it below (I regexed it to become 'foo2bar' so it's more generic to others). I also uploaded it as a public spreadsheet to google, because I think that is a bit easier to look at:

Re: [GENERAL] [general] Error while decrypting using pgp

2014-11-19 Thread Jeff Janes
On Wed, Nov 19, 2014 at 2:49 AM, VENKTESH GUTTEDAR venkteshgutte...@gmail.com wrote: i am getting this error ERROR: function pgp_sym_decrypt(character varying, text) does not exist LINE 1: SELECT pgp_sym_decrypt(phone_no, keys.privkey), pgp_sym_decrypt(us... The encrypted

[GENERAL] Building debug version with MSVC 2013 for 64bit: No _d postfix on dll and lib files...

2014-11-19 Thread Zuiderhoek, Jeroen
Hello, I am trying to build postgresql (and to be more specific, the libraries libpq, libpgtypes and libecpg) with MSVC 2013 for using them in a 64bit application. I downloaded the source code (v9.3.5), unzipped the file and run 'build DEBUG libpq', as nicely described here:

[GENERAL] Performance question

2014-11-19 Thread Anil Menon
Hello, I would like to ask from your experience which would be the best generic method for checking if row sets of a certain condition exists in a PLPGSQL function. I know of 4 methods so far (please feel free to add if I missed out any others) 1) get a count (my previous experience with ORCL

Re: [GENERAL] Performance question

2014-11-19 Thread Francisco Olarte
Hi Anil: On Wed, Nov 19, 2014 at 5:26 PM, Anil Menon gakme...@gmail.com wrote: Cons : It seems doing a count(*) is not the best option for PG For this and some of the following options, if you are going to just test for existence, I would consider adding a limit 1 somewehere on the query, to

Re: [GENERAL] Performance question

2014-11-19 Thread Adrian Klaver
On 11/19/2014 08:26 AM, Anil Menon wrote: Hello, I would like to ask from your experience which would be the best generic method for checking if row sets of a certain condition exists in a PLPGSQL function. I know of 4 methods so far (please feel free to add if I missed out any others) 1) get

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Josh Berkus
On 11/18/2014 04:23 PM, Joshua D. Drake wrote: Forwarding this because they are having a dedicated PostgreSQL track put on by PgUS. I hope all will submit papers. This is a great conference of about 1500. It is 100% non-profit and is a great opportunity to reach out! Wow, LA in February, SF in

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Adrian Klaver
On 11/19/2014 11:47 AM, Josh Berkus wrote: On 11/18/2014 04:23 PM, Joshua D. Drake wrote: Forwarding this because they are having a dedicated PostgreSQL track put on by PgUS. I hope all will submit papers. This is a great conference of about 1500. It is 100% non-profit and is a great

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Josh Berkus
On 11/19/2014 11:57 AM, Adrian Klaver wrote: So as not to have lost souls wandering around Seattle in April, LFNW is actually in Bellingham(about 90 miles N):) I'm now imagining geeks wandering around Pike Place Market with posters of the Postgres elephant that say Have You Seen Me? ;-) --

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Rob Sargent
On 11/19/2014 12:57 PM, Adrian Klaver wrote: On 11/19/2014 11:47 AM, Josh Berkus wrote: On 11/18/2014 04:23 PM, Joshua D. Drake wrote: Forwarding this because they are having a dedicated PostgreSQL track put on by PgUS. I hope all will submit papers. This is a great conference of about 1500.

[GENERAL] Call for Speakers and Sponsors for pgDaySF 2015

2014-11-19 Thread Josh Berkus
All: We will be having a full day of PostgreSQL talks on March 10th, in Burlingame CA. This event is co-hosted with FOSS4G-NA, so you can get your full PostGIS fix. We are curently looking for both speakers, and sponsors of the event. More information here:

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Adrian Klaver
On 11/19/2014 12:09 PM, Josh Berkus wrote: On 11/19/2014 11:57 AM, Adrian Klaver wrote: So as not to have lost souls wandering around Seattle in April, LFNW is actually in Bellingham(about 90 miles N):) I'm now imagining geeks wandering around Pike Place Market with posters of the Postgres

Re: [GENERAL] how to delay sync by a set time, hour or day?

2014-11-19 Thread John Smith
On 11/19/14, Michael Paquier michael.paqu...@gmail.com wrote: On Wed, Nov 19, 2014 at 8:37 AM, John Smith jayzee.sm...@gmail.com wrote: i want to setup a standby slave that listens 24/7 but only syncs when told to. setting pause_at_recovery_target (boolean) in recovery.conf on slave doesn't

[GENERAL] better architecture?

2014-11-19 Thread zach cruise
i need some advice: 1. for our small business, i have a master (dev) - slave (prod) setup. i develop using the master. i get data from other people's dev (mssql) databases. i also get data from their prod (mssql) databases. i replicate everything on slave. apps using the master can connect only

Re: [GENERAL] how to delay sync by a set time, hour or day?

2014-11-19 Thread Sameer Kumar
On 20 Nov 2014 06:11, John Smith jayzee.sm...@gmail.com wrote: On 11/19/14, Michael Paquier michael.paqu...@gmail.com wrote: On Wed, Nov 19, 2014 at 8:37 AM, John Smith jayzee.sm...@gmail.com wrote: i want to setup a standby slave that listens 24/7 but only syncs when told to.

Re: [pdxpug] [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread gabrielle
On Wed, Nov 19, 2014 at 12:09 PM, Josh Berkus j...@agliodbs.com wrote: On 11/19/2014 11:57 AM, Adrian Klaver wrote: So as not to have lost souls wandering around Seattle in April, LFNW is actually in Bellingham(about 90 miles N):) I'm now imagining geeks wandering around Pike Place

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

2014-11-19 Thread Michael Paquier
On Thu, Nov 20, 2014 at 5:09 AM, Josh Berkus j...@agliodbs.com wrote: On 11/19/2014 11:57 AM, Adrian Klaver wrote: So as not to have lost souls wandering around Seattle in April, LFNW is actually in Bellingham(about 90 miles N):) I'm now imagining geeks wandering around Pike Place Market