2016-01-06 9:08 GMT+02:00 Oleg Bartunov :
> I agree with Jim, something is wrong, I see our developers community isn't
> growing and getting older. There is no formal problem to start contribute,
> but steep learning curve and lack of mentoring practice scare people.
I agree, that learning curve
On 6 January 2016 at 20:36, Pavel Stehule wrote:
> Almost all developers write code for job not for hobby.
>
As much as I'm trying not to get involved in this thread mainly due to my
lack of ability to foresee that a block of text will solve a bunch of
problems, I do just want to point out that
> I agree with Jim, something is wrong, I see our developers community isn't
> growing and getting older.
> There is no formal problem to start contribute, but steep learning curve and
> lack of mentoring practice scare people.
The "Debian Med" Debian Blend has quite successfully used a
semi-stru
2016-01-06 9:20 GMT+01:00 David Rowley :
> On 6 January 2016 at 20:36, Pavel Stehule wrote:
>
>> Almost all developers write code for job not for hobby.
>>
>
> As much as I'm trying not to get involved in this thread mainly due to my
> lack of ability to foresee that a block of text will solve a
Hi All,
I just saw this thread.
I tend to agree with the general idea of having a code of conduct. If you are
on a long distance journey then it will help to have road signs every now and
then. Following your nose won't hurt but doesn't necessarily help either! LOL
More seriously, on the p
On Wed, Jan 06, 2016 at 11:22:17AM -, FarjadFarid(ChkNet) wrote:
> I am not in favour of massive price structures but that
> there should be $100-$200 costs for smallest version. Times
> several million products. This may allow postgresql to reduce
> its prices on its the top of the range prod
Hi Karsten,
> You may be mistaking the community version for any of the commercially
supported offerings ?
It is possible. Please fill in the figures.
What I am suggesting is that even for community version there should be a
charge.
But as I mentioned it is not just prices.
May be I wasn't
Hi Karsten,
> You may be mistaking the community version for any of the commercially
supported offerings ?
It is possible. Please fill in the figures.
What I am suggesting is that even for community version there should be a
charge.
But as I mentioned it is not just prices.
May be I wasn't
What are you talking about? What business structure? Commercial offerings can
and will continue to exist in terms of custom features or consulting.
Firstly, it ceases to be a community version when there is a charge. Secondly,
it would damage our community by shrinking the size to effectively no
Hi Everyone ,
My only aim is further progress of postgresql. Emails are not the best medium
for consulting about complex issues.
One last point I would like to make is this.
As per Sun Microsystem’s case charging zero dollars (for Java and mysql) means
there is zero income.
I hav
All,
The subject of the discussion/track is to whether or not there should be a
code of condect (Coc).
Whether or not there should be a charge for PostgreSQL does not belong in
this track, and is, in fact, a moot point as PostgreSQL IS a _free_
database, as is this community board.
If you feel it
> My only aim is further progress of postgresql.
Charging for it would do exactly that. Most people would simply switch
to MySQL (or Maria) or stop upgrading/upgrade to a fork.
> As per Sun Microsystem’s case charging zero dollars (for Java and mysql)
> means there is zero income.
Why do you thin
Hi James,
I value your passion and commitment to postgresql. I am equally passionate
about postgresql and am just like you another user but not pointing these on
simple commercial practical bases.
These are simple feedbacks.
Just one last example. Consider the music industry. For years Apple
Hi James,
I value your passion and commitment to postgresql. I am equally passionate
about postgresql and am just like you another user but pointing these on simple
commercial practical bases.
These are simple feedbacks.
Just one last example. Consider the music industry. For years Apple amo
On 1/6/16 2:17 AM, Victor Yegorov wrote:
Another very wanted change in the community is mentorship. Personally, I
don't feel confident to ask endless questions I have when looking into
the code, as I understand, that this might be a very basic (for
PostgreSQL hackers) stuff. For me it'd be a grea
While at first glance, it would seem a code of conduct is a good idea,
having once would be pointless if there is no way to enforce it.
As others have already shown by totally ignoring the subject of this track
and hijacking it into a discussion of fees (which, IMHO, is totally
ridiculous),
there i
As Melvin mentioned, this belongs in a new thread.
> Just one last example. Consider the music industry. For years Apple amongst
> others promoted low cost per unit downloads and then streaming. We all know
> the history.
>
> Once a thriving industry music industry has been decimated. Neither
On 1/6/16 1:36 AM, Pavel Stehule wrote:
The CoC doesn't solve it. We do on mature, stable, pretty complex
code - use C (not JavaScript or Java). This isn't hobby project or
student project.
No, CoC by itself doesn't grow the community. That doesn't mean we
shouldn't have one.
Another weakness
On 1/6/16 9:48 AM, Melvin Davidson wrote:
there is no way it can be enforced. So while I applaud Joshua Drake for
his good intent, I there must therefore take the position of saying no
to a CoC
A good CoC is not just a code, it is also a means of enforcement. To
wit, from the CouchDB CoC[1]:
> The coc sounds like a Washington politics play, but as long as the best
> still engage
> in this forum, I could care less. The list serves its purpose without
> overhead...a rare
> resource in today's flood of incoherent technical chatter.
Beyond "Hey! Look at us! We're telling people to play ni
2016-01-06 17:04 GMT+01:00 Jim Nasby :
> On 1/6/16 1:36 AM, Pavel Stehule wrote:
>
>> The CoC doesn't solve it. We do on mature, stable, pretty complex
>> code - use C (not JavaScript or Java). This isn't hobby project or
>> student project.
>>
>
> No, CoC by itself doesn't grow the community. Th
Hi Jim/Melvin and all,
Music industry is a good example where too low charges has damaged it. People
in the industry will tell you that not enough young talent are coming through
the system. I do agree that there is some corruption but there is no escaping
the fact that the industry's turn over
> No, CoC by itself doesn't grow the community. That doesn't mean we
> shouldn't have one.
I'd agree with that. Thinking back over my previous points, it does make
sense to have one, if only to deal with people who represent the
community in some way, i.e. have some kind of commit or marketing acce
On 01/06/16 08:04, Jim Nasby wrote:
...
increase the number of active developers. My very talented colleague
doesn't write to Postgres due C language. He like to write planner in
lisp or erlang. Or like to play in these languages. C is barrier for
younger people.
...
better job of "eating our
On 01/06/2016 08:11 AM, James Keener wrote:
The coc sounds like a Washington politics play, but as long as the best
still engage
in this forum, I could care less. The list serves its purpose without
overhead...a rare
resource in today's flood of incoherent technical chatter.
Beyond "Hey! Look a
On 01/06/2016 08:13 AM, Jim Nasby wrote:
(BTW, if your concern on enforcement is about control, not only can
people be removed from mailing lists and the like, but there actually is
a Postgres legal entity that could start legal proceedings if it ever
came to it.)
As a Director for 2 of the "l
2016-01-06 17:46 GMT+01:00 Jeff Anton :
> On 01/06/16 08:04, Jim Nasby wrote:
> ...
>
>> increase the number of active developers. My very talented colleague
>>> doesn't write to Postgres due C language. He like to write planner in
>>> lisp or erlang. Or like to play in these languages. C is barri
I would like to see the following added to the introduction to this list.
"When submitting to this list, please include the full version of
PostgreSQL and the O/S you are using.
Also, if you are reportaing a problem, it is essential that a minimal
amount of schema & data be
provided in order to du
On 06/01/2016 16:54, James Keener wrote:
> As Melvin mentioned, this belongs in a new thread.
And as such, it would have been really kind to actually start a new one.
(...)
--
Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
Loxodata - Conseil, expertise et formations
On Wed, Jan 6, 2016 at 9:15 AM, Melvin Davidson
wrote:
>
> I would like to see the following added to the introduction to this list.
>
> "When submitting to this list, please include the full version of
> PostgreSQL and the O/S you are using.
> Also, if you are reportaing a problem, it is essenti
On 01/06/2016 08:50 AM, Joshua D. Drake wrote:
On 01/06/2016 08:11 AM, James Keener wrote:
The coc sounds like a Washington politics play, but as long as the best
still engage
in this forum, I could care less. The list serves its purpose without
overhead...a rare
resource in today's flood of inc
On 01/06/2016 09:20 AM, Adrian Klaver wrote:
We just have to figure out if it will. (As a cis-hetero white middle
class male) I'm not a "targeted" group and as such my views may not be
of the most use here.
Which is another very good point.
Except it is not true. Re: my previous post about B
How does one "start a new thread"? I wasn't aware that changing the subject
wouldn't be enough. I tried :/
Jim
On January 6, 2016 12:17:54 PM EST, "Stéphane Schildknecht"
wrote:
>On 06/01/2016 16:54, James Keener wrote:
>> As Melvin mentioned, this belongs in a new thread.
>
>And as such, it w
Victor Yegorov wrote:
> Perhaps, this is a good project for a newby to do. Perhaps, it is
> worthwhile to create Developer's documentation, either as a section in
> the official docs or as a separate resource with structure and design
> similar to the official docs?
Here's an idea. We have a wik
Hi Joshua,
Thanks for the posting. That was a good list of areas to cover. Specially about
speakers/events/third party plugins etc.
How would you sum it up? Would it be right to summed up as anything that could
affect the Postgresql as a brand should be protected?
This is of course also an
Hi
I have installed postgresql-9.3 in my centos application. When the
application starts for first-time Postgres starts without any issue most of
the time. But when I reboot the centOs, Postgres is not getting started on
subsequent boot and I am getting the error,
LOG: invalid magic number
Hi,
Thanks for your answer!
I know that this is not the only language for triggers, but the
algorithm I have to implement only supports these triggers.
I have looked at the audit trigger, but that is not quite what I am
trying to achieve. I have implemented the stack push and pop for the
initial c
On 01/05/2016 11:18 AM, balajishanmu...@live.in wrote:
Hi
I have installed postgresql-9.3 in my centos application. When the
application starts for first-time Postgres starts without any issue most of
Not sure what you are talking about when you say CentOS application.
Are you saying when Cen
On Wed, 06 Jan 2016 12:46:08 -0500
James Keener wrote:
> How does one "start a new thread"? I wasn't aware that changing the
> subject wouldn't be enough. I tried :/
If you want to start a new thread don't reply to an existing one. Even
if you change the subject it is still part of the old threa
[offtopic alert]
On 2016-01-06 12:46 PM, James Keener wrote:
How does one "start a new thread"?
'New Message' in your favourite email client.
'pgsql-general@postgresql.org' in the 'To' box.
I wasn't aware that changing the subject wouldn't be enough. I tried :/
Check the raw source of the
Hi,
I'm not much of a contributor to the project any more, but I thought
perhaps some information about what some other communities do might be
helpful. (For those of you who don't know me, I used to be somewhat
active in this community until I got heavily involved in the Intenet
Engineering Task
Hello,
Is there any way for a client to know if a conflict happened in an ON
CONFLICT DO UPDATE query ?
Thanks !
--
Nicolas "Pause" ALBEZA
Responded to the separately cross-posted version on -www...in short this is
not a big reporting list and doesn't need the same rules or expectations.
Assume agnostic o/s and current release then deal with variations as they
are needed.
David J.
On Wednesday, January 6, 2016, Melvin Davidson wrot
By application I mean centOS.
We are starting and stopping Postgres using systemd service. We have a
service file called postgresql9.3.service which is used to start or stop
Postgres.
Excerpts of postgresql9.3.service
ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA}
ExecStart=
On Wed, Jan 6, 2016 at 12:36 PM, balajishanmu...@live.in
wrote:
> By application I mean centOS.
>
> We are starting and stopping Postgres using systemd service. We have a
> service file called postgresql9.3.service which is used to start or stop
> Postgres.
>
> Excerpts of postgresql9.3.service
>
Please quote only enough to remind readers of context an respond
below the quoted text. This is the conventional style for the
PostgreSQL lists, and saves a lot of time for the thousands who
will read this. Thanks!
On Wed, Jan 6, 2016 at 12:36 PM, Navaneethakrishnan Gopal
wrote:
> PostgreSQL
Most of the time I will be restarting centOS by issuing reboot command. Which
will do the orderly shutdown of all the service and sometimes just pull the
plug.
But the issue appears to be random. Is there a way that before Postgres
starts we can check whether data is flushed, if not flush it manua
On Wed, Jan 6, 2016 at 10:48 AM, Nicolas ALBEZA wrote:
> Hello,
>
> Is there any way for a client to know if a conflict happened in an ON
> CONFLICT DO UPDATE query ?
Here is one way:
create table foo (x int primary key, y text);
insert into foo values (3,'insert') on conflict (x) do update set
I see the insert policy check running but also the select policy using
on insert. I don't understand why the select policy is being run.
Could it possibly be related to using a sequence on the table?
Ted
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
On 01/06/2016 01:08 PM, balajishanmu...@live.in wrote:
Most of the time I will be restarting centOS by issuing reboot command. Which
will do the orderly shutdown of all the service and sometimes just pull the
plug.
But the issue appears to be random. Is there a way that before Postgres
starts we
Hi Kevin,
Thanks a lot for getting back on this.
1) Customer is facing issue in our application running 8.2 version PG
linux# su postgres -s /bin/sh -c "postgres --version"
postgres (PostgreSQL) 8.2.3
unicorn=# select version();
version
--
On 1/6/2016 8:50 AM, Joshua D. Drake wrote:
It provides a sense of confidence to those who are not confident that
they can come play in our playground and not be bullied. That is what
every single code of conduct is about. There are a lot of very
talented people in the FLOSS community that just
On 1/6/2016 8:25 AM, FarjadFarid(ChkNet) wrote:
Music industry is a good example where too low charges has damaged it. People
in the industry will tell you that not enough young talent are coming through
the system. I do agree that there is some corruption but there is no escaping
the fact tha
Uhm, you mean this one?
https://git.kernel.org/cgit/linux/kernel/git/torvalds/linux.git/commit/?id=b0bc65729070b9cbdbb53ff042984a3c545a0e34
+If however, anyone feels personally abused, threatened, or otherwise
+uncomfortable due to this process, that is not acceptable. If so,
+please contact the
On 1/6/2016 9:15 AM, Melvin Davidson wrote:
I would like to see the following added to the introduction to this list.
"When submitting to this list, please include the full version of
PostgreSQL and the O/S you are using.
Also, if you are reportaing a problem, it is essential that a minimal
a
hi,
I've been using Postgres for years ( :heart: ) and I'm still in doubt
about this. Would somebody provide an authoritative, definitive,
narrative answer?
-> Can a function like `LEFT()` use an index?
(Or do I have to find an "equivalent" operator in order to leverage
indexes?)
Thanks!
Seamus
On 1/6/16 5:15 PM, Seamus Abshere wrote:
I've been using Postgres for years ( :heart: ) and I'm still in doubt
about this. Would somebody provide an authoritative, definitive,
narrative answer?
-> Can a function like `LEFT()` use an index?
(Or do I have to find an "equivalent" operator in order
On 01/06/2016 02:50 PM, David Gibbons wrote:
On 1/6/2016 8:50 AM, Joshua D. Drake wrote:
It provides a sense of confidence to those who are not confident
that they can come play in our playground and not be bullied.
That is what every single code of conduct is about.
Seamus Abshere writes:
> I've been using Postgres for years ( :heart: ) and I'm still in doubt
> about this. Would somebody provide an authoritative, definitive,
> narrative answer?
> -> Can a function like `LEFT()` use an index?
To do what?
Since the question makes little sense as stated, I'm
On Wed, Jan 6, 2016, at 08:41 PM, Tom Lane wrote:
> Seamus Abshere writes:
> > -> Can a function like `LEFT()` use an index?
> Since the question makes little sense as stated, I'm going to assume
> you mean "can a query like SELECT ... WHERE left(foo, 3) = 'bar'
> use an index on column foo?"
>
>
Seamus Abshere writes:
> I should have been more general. In layman's/narrative terms, what's the
> deal with functions vs. operators for postgres indexes?
> For example, `exist(hstore,text)` vs. `hstore ? text` ?
Yeah. exist(hstore,text) and hstore?text may yield the same result,
but only the
Is it possible to get the parse tree in a C trigger function which is
invoked when DML (INSERT/UPDATE/DELETE against a view) is executed?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Sent via pgsql-general ma
* Ted Toth (txt...@gmail.com) wrote:
> I see the insert policy check running but also the select policy using
> on insert. I don't understand why the select policy is being run.
> Could it possibly be related to using a sequence on the table?
It's used when SELECT rights are required on the table,
> On 1/4/16 12:18 PM, Luke Coldiron wrote:
> > Is there a way to achieve the performance of the COPY FROM STDIN command
> > within a C extension function connected to the db connection that called
> > the C function? I have text that I would like to receive as input to a C
> > function that contain
On Wed, Jan 6, 2016 at 4:29 PM, Mohammed Ajil wrote:
> What is an executor hook?
Here you go, with a particular focus on the ones names Executor*_hook:
https://wiki.postgresql.org/images/e/e3/Hooks_in_postgresql.pdf
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
On 1/6/16 5:41 PM, Tom Lane wrote:
Since the question makes little sense as stated, I'm going to assume
you mean "can a query like SELECT ... WHERE left(foo, 3) = 'bar'
use an index on column foo?"
The answer to that is no, there is no such optimization built into
Postgres. (In principle there
On 1/6/16 7:03 PM, Tatsuo Ishii wrote:
Is it possible to get the parse tree in a C trigger function which is
invoked when DML (INSERT/UPDATE/DELETE against a view) is executed?
Yes, it's in fcinfo->flinfo->fn_expr.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analy
On 1/6/16 9:45 PM, Luke Coldiron wrote:
In the example above I'm not sure if I can use some sub struct of the
SPIPlanPtr and hand it off to the DoCopy function as the CopyStmt or if I
need to go about this entirely different. Any advice on the matter would be
much appreciated.
I don't know off-
Dear Team,
Please suggest, how much RAM and core should be define for New Postgres
database server, if we will use Postgres 9.3 and above.
If suppose my postgres database size will be near about 300 to 500 GB for
future.
There is any document regarding this server configuration, suggest ?
Regar
On 07/01/16 18:39, Sachin Srivastava wrote:
Dear Team,
Please suggest, how much RAM and core should be define for New
Postgres database server, if we will use Postgres 9.3 and above.
If suppose my postgres database size will be near about 300 to 500 GB
for future.
There is any document reg
On Wed, Jan 6, 2016 at 10:39 PM, Sachin Srivastava
wrote:
> Dear Team,
>
> Please suggest, how much RAM and core should be define for New Postgres
> database server, if we will use Postgres 9.3 and above.
>
> If suppose my postgres database size will be near about 300 to 500 GB for
> future.
>
>
Dear David,
Q: RAM holds data that is recently accessed - how much of that will you
have?
Ans: Kindly confirm, as per your question “RAM holds data that is recently
accessed” : How we figured out that how much data we will have. Is it
depends of Total WAL files (total "checkpoint_segment"
72 matches
Mail list logo
