Re: [GENERAL] Application written in pure pgsql, good idea?

2015-02-28 Thread BladeOfLight16
On Sat, Feb 28, 2015 at 3:39 PM, inspector morse wrote: > > Is it a good idea to write a simple application (consisting of just data > entry interfaces) in pure pgsql? > > Basically, we would have each page has a stored function in postgresql > that is called by php+apache (the http get/post valu

[GENERAL] Re: [postgresql 9.3.5] autovacuums stuck on non-existent pg_toast tables

2015-02-28 Thread tpham
Hi Álvaro, Pardon my stupidity. I kept looking for things in the wrong place. The pg_toast tables have always been there, I was just issuing the commands yo mentioned in a different database. Need to get more sleep. xD In the end, we decided the entire database needed a good cleaning. So we sched

[GENERAL] Re: [postgresql 9.3.5] autovacuums stuck on non-existent pg_toast tables

2015-02-28 Thread tpham
Hi Erik, I thouht pg_cancel_backend and pg_terminate_backend simply send SIGINT and SIGTERM, respectively, to the backend process? We did try using the commands and sending the signals ourselves, but to no avail. -- View this message in context: http://postgresql.nabble.com/postgresql-9-3-5-au

Re: [GENERAL] Performance on DISABLE TRIGGER

2015-02-28 Thread David Steele
On 2/27/15 9:07 AM, gmb wrote: > Hi all > > I'm doing some maintenance - which is done quite often, never had this > problem before - which requires me to disable triggers, run some updates and > then re-enable the triggers. > Where the whole process normally take 30 sec , it took much longer tod

Re: [GENERAL] Application written in pure pgsql, good idea?

2015-02-28 Thread Adrian Klaver
On 02/28/2015 01:39 PM, Jan de Visser wrote: On February 28, 2015 03:39:06 PM inspector morse wrote: Is it a good idea to write a simple application (consisting of just data entry interfaces) in pure pgsql? Basically, we would have each page has a stored function in postgresql that is called by

Re: [GENERAL] Application written in pure pgsql, good idea?

2015-02-28 Thread Jan de Visser
On February 28, 2015 03:39:06 PM inspector morse wrote: > Is it a good idea to write a simple application (consisting of just data > entry interfaces) in pure pgsql? > > Basically, we would have each page has a stored function in postgresql that > is called by php+apache (the http get/post values

[GENERAL] Application written in pure pgsql, good idea?

2015-02-28 Thread inspector morse
Is it a good idea to write a simple application (consisting of just data entry interfaces) in pure pgsql? Basically, we would have each page has a stored function in postgresql that is called by php+apache (the http get/post values would be passed into postgrel as an array). The pgpsql would rend