Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Mark Morgan Lloyd
Jernigan, Kevin wrote: On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: HA Scaling Upgrade Add/Remove Oracle RAC 50% 50%easyeasy Streaming Rep. 100% 25%* hardeasy Sharding 0%100%hardhard

[GENERAL] what change in postgres 9.5 improvements for multi-CPU machines

2016-03-25 Thread 657985...@qq.com
hello everyone: I was bothered by the postgres spinlock for a long time . How to understand this sentence "postgres 9.5 performance improvements for multi-CPU machines" at present my database is 9.3.5 。 Can it solve the spinlock problem, if upgrade it to 9.5 ?

[GENERAL] HELP! Uninstalled wrong version of postgres

2016-03-25 Thread Howard News
Hi, I uninstalled the wrong version of postgres on Ubuntu using apt-get remove postgresql-9.0, convinced that this was an old unused version. You guess the rest... The data files still appear to be there, all 485GB of them. Can these be restored? Thanks. -- Sent via pgsql-general mailing

Re: [GENERAL] Hide the code from users postgres

2016-03-25 Thread Michael Milligan
He asked a legitimate question. Why he wants to hide the code is his business. If you don't know the answer, or don't want to tell him, don't answer. Michael Milligan

Re: [GENERAL] what change in postgres 9.5 improvements for multi-CPU machines

2016-03-25 Thread Merlin Moncure
On Fri, Mar 25, 2016 at 5:11 AM, 657985...@qq.com <657985...@qq.com> wrote: > hello everyone: > I was bothered by the postgres spinlock for a long time . How to > understand this sentence "postgres 9.5 performance improvements for > multi-CPU machines" > at present my database is 9.3.5 。 Can

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

2016-03-25 Thread Melvin Davidson
On Thu, Mar 24, 2016 at 6:58 PM, Melvin Davidson wrote: > > > On Thu, Mar 24, 2016 at 4:05 PM, James Robinson > wrote: > >> Folks, >> >> I see that psql's \d displays trigger information of a table by >> making a call to pg_catalog.pg_get_triggerdef(), which abstracts away most >> all ne

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

2016-03-25 Thread Melvin Davidson
On Fri, Mar 25, 2016 at 11:10 AM, Igor Neyman wrote: > Did you mean something like > > > > *SELECT substring(pg_get_triggerdef(tg.oid, TRUE) FROM position('WHEN' in > pg_get_triggerdef(tg.oid, TRUE))) AS when_cond FROM pg_trigger tg WHERE > tg.tgname = 'your_trigger_name'; * > > > -- > > *Melvi

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

2016-03-25 Thread James Robinson
> On Mar 25, 2016, at 11:10 AM, Igor Neyman wrote: > > This doesn’t answer OP question. > > Besides this query gets you not only “WHEN” clause but also whatever follows > it, for instance “EXECUTE PROCEDURE…” Yeah. I was imagining having to do doing something semantically equivalent, but bet

Re: [GENERAL] Only owners can ANALYZE tables...seems overly restrictive

2016-03-25 Thread Stephen Frost
David, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Thu, Mar 24, 2016 at 4:51 AM, Stephen Frost wrote: > > I don't see any reason why the patch itself would be terribly difficult, > > but are we sure we'd want just ANALYZE and not VACUUM also? Which would > > have to be another b

Re: [SPAM] Re: [GENERAL] PostgreSQL crash with PANIC message

2016-03-25 Thread Moreno Andreo
Il 23/03/2016 21:57, Adrian Klaver ha scritto: On 03/23/2016 12:02 PM, Moreno Andreo wrote: Il 23/03/2016 19:57, Adrian Klaver ha scritto: Might help to look in: Control Panel --> Administrative Tools --> Event Viewer No help there. Nothing strange or pointing to critical resource usage.

Re: [GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

2016-03-25 Thread James Robinson
> On Mar 25, 2016, at 3:02 PM, Igor Neyman wrote: > > James, > > Instead of pg_catalog, you could use INFORMATION_SCHEMA to get "WHEN" clause: > > select action_condition from information_schema.triggers where trigger_name = > 'your_trigger_name'; > > Regards, > Igor Hah, good suggestion. L

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Jernigan, Kevin
On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan Lloyd" wrote: >Jernigan, Kevin wrote: >> On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: > >>> >>> HA Scaling Upgrade Add/Remove >>>Oracle RAC 50% 50%easyeasy >>>

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Kevin Grittner
On Fri, Mar 25, 2016 at 4:15 PM, Jernigan, Kevin wrote: > On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark > Morgan Lloyd" markmll.pgsql-gene...@telemetry.co.uk> wrote: >> Just because a corporate has a hundred sites cooperating for inventory >> management doesn't mean

Re: [GENERAL] PostgreSQL advocacy

2016-03-25 Thread Mark Morgan Lloyd
Jernigan, Kevin wrote: On 3/25/16, 4:37 AM, "pgsql-general-ow...@postgresql.org on behalf of Mark Morgan Lloyd" wrote: Just because a corporate has a hundred sites cooperating for inventory management doesn't mean that the canteen menus have to be stored on Oracle RAC :-) Right, but ofte

Re: [GENERAL] HELP! Uninstalled wrong version of postgres

2016-03-25 Thread Leonardo M . Ramé
El 24/03/16 a las 14:19, Howard News escribió: Hi, I uninstalled the wrong version of postgres on Ubuntu using apt-get remove postgresql-9.0, convinced that this was an old unused version. You guess the rest... The data files still appear to be there, all 485GB of them. Can these be restored?

[GENERAL] Pg-Logical output pkg; can't install 9.4 and 9.5 on same Wheezy box

2016-03-25 Thread Jerry Sievers
Posted to Admin a few days ago... I'll try here next before going to Hackers or trying to locate the packagers. Anyone else as enthused as I am about Pg-Logical and tried installing both version on same host? Fails on the output plugin package due to header file conflict. I recall as mig