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 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

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 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 po

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" wrote: > > On 11/19/14, Michael Paquier wrote: > > On Wed, Nov 19, 2014 at 8:37 AM, John Smith 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 recover

[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 t

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 wrote: > On Wed, Nov 19, 2014 at 8:37 AM, John Smith 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 help since docs say it only "spe

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 el

[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: http://sfpostgres.org/pgday-sf-2015-c

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. I

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 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 opportunity

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

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) ge

Re: [GENERAL] Performance question

2014-11-19 Thread Francisco Olarte
Hi Anil: On Wed, Nov 19, 2014 at 5:26 PM, Anil Menon 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 let the optimize

[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

[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: http://www.postgre

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 en

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: https://docs.google.com/spreadsheets/d/1w9HM8w9YUpu

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 d

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 wrote: > Robert Haas writes: >> On Thu, Nov 13, 2014 at 7:34 PM, Tom Lane wrote: >>> One thing that occurs to me is that if the generic plan estimate comes >>> out much cheaper than the custom one, maybe we should assume that the >>> generic's cost estim

Re: [GENERAL] postgresql for small business

2014-11-19 Thread Eric Pierce
On 11/19/14, 6:54 AM, "Ernesto Quiñones" 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 for yo

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 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 which include

[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 --

[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, keys.p

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 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 establish" ca