nts above 1).
If you read and count ms carefully you will find that ar_tran_inv is
scanned 6 times and each of these times is taking about 25ms. 25x6 is half
of your query time right there and then you have the overhead in the joins
on top of that. Quick eyeball estimates is that this is where
folks are working on this, is there an ETA on a fix?
Is there anything I can do to help?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
arriage.parties)
join people p2 on p2 = any(marriage.parties) and p2.id <> p1.id
>
>
> --
> Veni, Vidi, VISA: I came, I saw, I did a little shopping.
>
> Maranatha! <><
> John McKown
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ation slots provide standby feedback and may further delay
vacuuming when the standby is offline.
> --
> Michael
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-ge
On Wed, Jul 5, 2017 at 3:51 PM, Bill Moran wrote:
> On Wed, 5 Jul 2017 13:28:29 +0200
> Chris Travers wrote:
>
> > On Wed, Jul 5, 2017 at 1:00 PM, PT wrote:
> >
> > > 2x the working size for a frequently updated table isn't terrible
> bloat.
> > &g
until you know how frequently autovacuum runs on
> that table and how long it takes to do its work.
>
Given the other time I have seen similar behaviour, the question in my mind
is why free pages near the beginning of the table don't seem to be re-used.
I would like to try to ver
her interpretations of the
declarative that are not at all equivalent. The hoops we have to jump
through to make this work in an imperative way in SQL are sometimes rather
amusing.
>
> Kind Regards,
> Jason
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Wed, Jul 5, 2017 at 7:18 AM, Chris Travers
wrote:
> Hi;
>
> First, I haven't seen major problems of database bloat in a long time
> which is why I find this case strange. I wanted to ask here what may be
> causing it.
>
> Problem:
> ==
> Database is
ve chained generators and you really need to watch what is
parallelizable and what is not, and what is running on the partitions and
what is running post-gathering/shuffling. Spark has no real facility for
parallelising a comprehension.
>
> Kind Regards,
> Jason
>
>>
--
Bes
y important to understand the imperative side of the data flow in
that case (what is partitioned and what is not).
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ently which is the
problem here? But why doesn't Postgres re-use any of the empty disk pages?
More importantly, is there anything that can be done to mitigate this issue
other than a frequent vacuum full?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Fle
ts 0 rows, it can handle the conflict.
>
For that, you could use xmin. That tracks the transaction where the row
first became visible.
Best Wishes,
Chris Travers
>
> Rob
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
xt: http://www.postgresql-archive.
> org/Unable-to-understand-index-only-scan-as-it-is-not-
> happening-for-one-table-while-it-happens-for-other-tp5968835.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing l
discussed here on Feb 28- Mar 1 in Malmo. Those in the area who are
interested can book online at
https://edument.se/education/categories/sql/advanced-postgresql/book
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com
interested and in the Southern Sweden or Copenhagen areas,
please feel free to register at
https://www.eventbrite.com/e/postgresql-at-10-tb-and-beyond-tickets-30841174784
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http
My recommendation. See them as tools in a toolkit, not a question of what
is best.
For places where you have SQL statements as primary do SQL or PLPGSQL
functions.
For places where you are manipulating values (parsing strings for example)
use something else (I usually use pl/perl for string mani
27;;
>
> Result should be :
>Array_1 = {{1,2,3,4,5}};
>
Forgot to reply all (in case someone searches the archives later):
Array_1 :== Array_1 || Array[Array_2]
>
>
>
> --
> Regards :
> Venktesh Guttedar.
>
>
--
Best Wishes,
Chris Travers
Efficito
ray_1 = [][];
> Array_2 = '{1,2,3,4,5}';
>
> Result should be :
>Array_1 = {{1,2,3,4,5}};
>
>
> --
> Regards :
> Venktesh Guttedar.
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
; --
> GPG key ID E4071346 @ eu.pool.sks-keyservers.net
> E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
e final file in RAM.
LOBs work best when you need a streaming interface (seek and friends) while
bytea's are otherwise much more pleasant to work with.
>
> Thanks very much for your insights,
>
> Rich
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org
> > IT DEV Lead
> > IT DEPT
> > Dynacom Tankers Mgmt
> >
> >
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsq
/www.postgresql.org/docs/9.5/static/app-pgrewind.html
>
>
>
> Subhankar Chattopadhyay
> Bangalore, India
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/p
On Dec 7, 2016 5:07 PM, "Karsten Hilbert" wrote:
>
> On Wed, Dec 07, 2016 at 07:57:54AM -0800, Rich Shepard wrote:
>
> > I have used '-- ' to enter comments about tables or columns and am
curious
> > about the value of storing comments in tables using the COMMENT key
word.
> > When is the latter
his is pgdg postgres 9.5
>
1262 is 'pg_database'::regclass::oid
I don't know for sure but things I would worry about given the performance
profile are:
1. NUMA swap insanity
2. Accumulation of dead tuples leading to what should be very short
operations taking longer.
No idea of that is helpful but where I would probably start
> Thanks,
> Torsten
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
://www.thomas-guettler.de/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Tue, Aug 16, 2016 at 3:11 PM, Merlin Moncure wrote:
> On Sun, Aug 14, 2016 at 5:58 AM, Chris Travers
> wrote:
>
> >>
> >> All this seems to be a huge change which will definitely not appear any
> >> time soon.
> >
> > I am willing to b
to call person_save." It then looks
> up the function argument names and
> > calls it something like this:
> >
> > SELECT * FROM person_save(?, ?, ?, ?)
> >
> > with parameters
> > $object->id, $object->first_name, $object->last_name,
> $object
bably end
you right back at the same amount of overhead as a temporary function.
>
> On Sun, Aug 14, 2016 at 10:42 AM, Chris Travers
> wrote:
>
>> If all you want is a temporary function, you *can* create it in the
>> pg_temp namespace though that seems hackish.
>>
On Sun, Aug 14, 2016 at 12:35 PM, Karsten Hilbert
wrote:
> On Fri, Aug 12, 2016 at 01:32:33PM +0200, Chris Travers wrote:
>
> >>> My preference is stored procedures plus service locators
> >>
> >> Would you care to elaborate a little on the latter (service lo
ure in foreseeable
> future :(.
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ers depending on environment and requirements but it is
a decent starting point.
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
>
On Fri, Aug 12, 2016 at 11:32 AM, Karsten Hilbert
wrote:
> På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers <
> chris.trav...@gmail.com[chris.trav...@gmail.com]>:
>
> > My preference is stored procedures plus service locators
>
> I know your work on the
be used to create a mapping layer generally.
But again, if you are primarily worried about development time, then that
is more important, usually, than information management as a whole.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh
wrote:
> På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers <
> chris.trav...@gmail.com>:
>
>
>
>
>>
>> Of course you *can* use them well. I remember talking about this with
>> one author o
On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh
wrote:
> På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers <
> chris.trav...@gmail.com>:
>
>
>
> On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh > wrote:
>>
>> På torsdag 11. august
--
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andr...@visena.com
> www.visena.com
> <https://www.visena.com>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Thu, Jul 28, 2016 at 8:09 PM, Edson Richter
wrote:
> Em 28/07/2016 13:07, Chris Travers escreveu:
>
>
>
> On Thu, Jul 28, 2016 at 3:38 PM, Scott Marlowe
> wrote:
>
>> On Wed, Jul 27, 2016 at 9:51 AM, Geoff Winkless
>> wrote:
>> > O
On Thu, Jul 28, 2016 at 6:32 PM, Alex Ignatov
wrote:
>
> On 28.07.2016 18:41, Igor Neyman wrote:
>
>> -Original Message-
>> From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
>> Sent: Thursday, July 28, 2016 11:26 AM
>> To: Igor Neyman ; Rakesh Kumar <
>> rakeshkumar46...@gmail.com>
>>
n index and table updates)?
>
> As someone who has gotten more than one bug fix from pgsql in less
> than 48 hours, I feel sorry for anyone who finds a bug in a MySQL
> version they are running in production.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
worry about this sort of thing too much. Of course
NFS might be another alternative at that level of complexity
So yeah, a sandbox ;-)
>
> --Scott
>
>
>>
>>
>>>
>>> Regards,
>>> Hristo S.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> --
>> Achilleas Mantzios
>> IT DEV Lead
>> IT DEPT
>> Dynacom Tankers Mgmt
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
>
> --
> --
> Scott Mead
> Sr. Architect
> *OpenSCG <http://openscg.com>*
> http://openscg.com
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ut it sounds like they
> had good reasons.
>
> https://eng.uber.com/mysql-migration/
>
> Thoughts?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
should reject.
>
> This leads me to think I need to create 2^5 or 32 unique constraints to
> handle the various combinations of data that I can store. Until now, this
> integrity is handled in the application code. That breaks when the
> application is multi-threaded and the rules
jorly bad plans
(sequential scan over the table, followed by order, followed by limit).
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
of overhead that you might be able to avoid with the right functions. If
you need solid scalability you need people who understand performance costs
of various options and can weigh them in a particular context.
>
>
> --
> regards Szymon Lipiński
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
es the test description and pass status. That makes it
easy to check using other tools.
Usually I set aside a range of things (negative id's for example) for
testing purposes.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your su
icas. A specific architecture using
one or more of these replication technologies would need to be designed
based on your specific needs of course.
>
> Thank you!
> Francesco
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
m the db,
loops through them, and transforms the data as part of the OLTP workflow.
It is obviously much better of one can think about SQL as business logic
but this is not that often.
I.e. people think the peg is square but indeed it is round.
--
Best Wishes,
Chris Travers
Efficito:
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Wed, Mar 23, 2016 at 9:39 AM, Chris Travers
wrote:
> Use a view with a DO INSTEAD trigger. That will allow you to return the
> tuple properly.
>
> On Tue, Mar 22, 2016 at 7:40 PM, CS DBA
> wrote:
>
>> Hi All;
>>
>> we setup partitioning for a large t
general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
finish within the scheduled downtime.
>
> Any suggestions for reclaiming the space without excessive downtime?
>
>
> * *
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Wed, Mar 9, 2016 at 4:53 PM, Alexander Farber wrote:
> Hello Chris,
>
> On Wed, Mar 9, 2016 at 4:42 PM, Chris Travers
> wrote:
>
>>
>>
>> On Wed, Mar 9, 2016 at 1:10 PM, Alexander Farber <
>> alexander.far...@gmail.com> wrote:
>>
>&g
);
>
> IF NOT FOUND THEN
> UPDATE words_games
> SET hand2 = new_hand,
> pile = pile_array,
> played2 = CURRENT_TIMESTAMP
> WHERE gid = in_gid
> AND player2 = in_uid
> -- and it is second player's turn
> AND (played2 IS NULL OR played2 < played1);
> END IF;
> */
>
> END
> $func$ LANGUAGE plpgsql;
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
E.
>>
>> FWIW, I just use pdftotext in my CGI.
>
> --
>
> =
> Stephen Davies Consulting P/L Phone: 08-8177
> 1595
> Adelaide, South Australia.M
On Tue, Feb 16, 2016 at 6:04 PM, Tom Lane wrote:
> I wrote:
> > Chris Travers writes:
> >> Unless there is a sense that this is a bad idea I will submit a doc
> patch.
>
> > I was already working on it ... I think what we want is something along
> >
Unless there is a sense that this is a bad idea I will submit a doc patch.
On Mon, Feb 15, 2016 at 8:22 PM, Chris Travers
wrote:
> Hi;
>
> Today I ran into a question from a client as to why an index was not
> used. The index had been freshly created and was on a relatively small
index was created.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ication code to
make work properly.
So there are my $0.02
>
> Thanks.
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
, but probably had more relevant
> experience than most. Not had any significant trouble on the Internet, and
> even the 'worst' (which was exceedingly minor) would not have been
> addressed by any practical CoC.
>
I say this as a white American who has lived most of my life in small towns
(places disparagingly called redneck country, flyover country, etc).
I think one has to see the current push as an aspect of American culture
wars, and the fact that a central part of American white culture is the
idea that what is good for Americans is good for everyone else. In other
words, one often sees these sorts of issues as culture wars turned global.
I don't think that ideology should be a factor in whether one can
participate in economic commons, and I think furthermore going that route
would hurt most the least powerful groups. But I think on this I am
preaching towards the choir.
Again, I wont respond further on this thread. I hope that the comments
above are things that bring us together rather than things we argue about.
>
>
>
> Cheers,
> Gavin
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
; +1-503-667-4564
> PostgreSQL Centered full stack support, consulting and development.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
&
On Sun, Jan 24, 2016 at 11:14 PM, David E. Wheeler
wrote:
> On Jan 24, 2016, at 11:28 AM, Chris Travers
> wrote:
>
> >> * PostgreSQL is a community project and takes no position on any
> >> political question aside from its usage in the public sector (which w
On Sun, Jan 24, 2016 at 6:34 PM, Joshua D. Drake
wrote:
> On 01/24/2016 08:13 AM, Chris Travers wrote:
>
> If I could make one proposal for an additional clause:
>>
>> * PostgreSQL is a community project and takes no position on any
>> political question aside from its
x27;t interested in the rest of the question.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
h can be reasonably considered harassment will not be
> tolerated.
>
> Link to enforcement policy will of course be required.
>
> Best,
>
> David
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to you
list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
olicy.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>> Best,
>>
>> David
>>
>>
>
> --
> Command Prompt, Inc. http://the.postgres.company/
> +1-503-667-4564
> PostgreSQL Centered full stack support, consulting and development.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
jump on a particular cultural
bandwagon here which may *appear* to be inclusive but is in fact very
exclusionary and would push the project into a very distinctly political
direction internationally.
> Geoff
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgr
mfortable. If you want to argue about it, take it off list. Otherwise
we consider both email signatures to be disruptive."
Surely part of the point of this exercise is to keep the community from
being used as a weapon in a political argument, particularly over issues
which are controversial globally.
>
> Best,
>
> David
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Thu, Jan 21, 2016 at 12:39 PM, Geoff Winkless
wrote:
> On 21 January 2016 at 11:28, Chris Travers
> wrote:
> > Resisting the urge to talk about how justice was actually seen in the
> Dark
> > Ages
>
> Pitchforks. Baying crowds dragging those they consider to
On Thu, Jan 21, 2016 at 11:43 AM, Geoff Winkless
wrote:
> On 21 January 2016 at 10:37, Chris Travers
> wrote:
> > At the end of the day this will require human judgment rather than
> > formulation.
>
> Then make it explicit.
>
> * Disruption of the collaborative s
lawed but in a culturally diverse group it is far
better than the alternative.
>
> Geoff
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Ch
ond is that we expect people to
treat eachother with respect regardless of political differences.
Personally I am in the second camp. I think the first is way
over-protective. I think it is fine to shut out the crusaders. But we
should recognize we are here to work together, come together, and do
ffort to work out issues.
>
>
>
>
> Thanks,
>
> Regina
>
>
>
> *From:* Regina Obe [mailto:l...@pcorp.us]
> *Sent:* Wednesday, January 13, 2016 9:08 AM
> *To:* 'Chris Travers'
> *Cc:* 'Geoff Winkless' ; 'Psql_General (E-mail)'
on the software, not on the other person.
People *can* take offense when you say their code is not good enough,
particularly when it is true, because for better or worse we do often
identify with what we produce. But I would hope that if the focus is on
improvement of the software the this beco
On Wed, Jan 13, 2016 at 9:00 AM, John R Pierce wrote:
> On 1/12/2016 11:32 PM, Chris Travers wrote:
>
>>
>> One of the nice things about the Ubuntu Code of Conduct is that it
>> focuses primarily on the positive. It is long, perhaps overly verbose, but
>> it do
sql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
entire purpose of having the CoC.
>>>
>>>
>> I don’t remember the “victimhood”
>> line, but it is important to make sure people understand that the problem
>> manifests itself both by being to sensitive by the complainer and not being
>> sensitive enough
On Jan 12, 2016 9:48 AM, "Regina Obe" wrote:
>>
>> Chris,
>>
>> >> For a Coc – I think it should be light, but make it clear that we do
not tolerate strangers coming into our group and demanding us to accept
their code, cause we want to be welcoming and show we have at least 15% of
code contributi
the fact that this is critical software and we have to maintain very high
standards of code?
>
>
> Thanks,
>
> Regina
>
>
>
> *From:* Chris Travers [mailto:chris.trav...@gmail.com]
> *Sent:* Tuesday, January 12, 2016 3:05 AM
> *To:* Regina Obe
> *Cc:* Bu
nd say
>
> "I feel your pain, but according to our Code of Conduct, we can't change
> it."
>
> Thanks,
> Regina
>
>
>
>
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Thu, Jun 18, 2015, 14:38 Sven Geggus
wrote:
Hello,
I supose this is simple, but I did not find a solution in the documentation.
Because you already are returning 2 columns.
I would like to be able to do something like this:
select myfunc('foo','bar');
or
select myfunc(foo, bar) from foob
e server-side.
>>
>> What's going on? Why isn't this a core language supported alongside SQL,
>> Perl and Python as part of the core project?
>>
>
> Out of curiosity and what's going on? Why there is no Common Lisp
> in PostgresSQL's core
kagers on Debian, RHEL, Fedora, etc. for that.
I think that process will get you everything and more that handing it off
to core would.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
%3Aemail.naml>
>
>
>
> --
> View this message in context: Re: Why isn't Java support part of
> Postgresql core?
> <http://postgresql.1045698.n5.nabble.com/Why-isn-t-Java-support-part-of-Postgresql-core-tp5819025p5819445.html>
> Sent from the PostgreSQL - general mailing list archive
> <http://postgresql.1045698.n5.nabble.com/PostgreSQL-general-f1843780.html>
> at Nabble.com.
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Sun, Sep 14, 2014 at 10:22 PM, cowwoc wrote:
> Hi,
>
> Out of curiosity, why is Postgresql's Java support so poor? I am
> specifically looking for the ability to write triggers in Java.
>
Because it hasn't been a priority of contributors. This is how
non-single-vendor open source projects wo
kind of hardware.
>
We also don't know how the data will be processed.
Where EAV dies a screaming horrible death is when you try to search on
multiple attributes. If this data is just never going to be searched on
attributes, EAV isn't that bad (I use it for some things where that is
clearly the case).
--
Best Wishes,
Chris Travers
#x27;; DROP TABLE things; --
In practice this means a great deal of manual review and restriction on
which users can access this feature.
Best Wishes,
Chris Travers
>
> --
> Bill Moran
> I need your help to succeed:
> http://gamesbybill.com
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
. However, I don't see any other way to store information about
> something as wide as places around the world.
>
> Regards,
> Jimmy
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
; --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
t
allow:
CREATE testfunction(test) returns int language sql as $$ select 1; $$;
SELECT testfunction FROM test;
That would allow first-class calculated columns.
I assume the work is mostly at the parser/grammatical level. Is there any
reason why supporting that would be a bad idea?
--
Best
h the
PGObject Perl framework) but the former is more common. That allows you to
separate what your applications expect to see from how your data is laid
out in your database. That avoids having to rewrite your application when
you change the physical table layout.
--
Best Wishes,
Chris Travers
Eff
he application and the database.
Going very far on this will require writing client libraries. I am working
on some in Perl. I would be happy to collaborate with those in other
languages. However it's best to start small, and experiment with adding a
little bit at a time to a good relation
ators oneself.
Personally in this case I would probably use inheritance instead for the
simple reason that tables can inherit but complex types cannot. You can
use CHECK(false) NOINHERIT to effectively relegate a table to a type if you
have a sufficiently recent version of PostgreSQL.
Best Wishes,
e
wouldn't be using it for PostgreSQL backups, but the general sense is that
the developers are very, very conservative about making guarantees of
stability and so far we haven't seen any indication that "experimental"
means anything other than "developers nervous abo
his is
because you have less of a need to re-use credentials in that setup.
For the kind of work *I* do, the per-user approach works better, but
without knowing a lot about your project I can't offer real recommendations.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ER
either need to go to a
related product (like Postgres-XC) or you are going to need to have some
other layer that can do the parallelism.
Best Wishes,
Chris Travers
> sorry for all the newbie pg questions...
> --
> --
> Andrew McIntyre
> amcint...@m-m.com
>
#x27;t
Postgres-XC (which is something very different than a typical "replication"
setup, and I would describe it more as an advanced sharding solution).
Best Wishes,
Chris Travers
>
>
> As does Bettina Kemme (of Postgres-R fame).
>
> Sincerely,
>
> Wolfgang
>
his route however, I don't
know whether Postgres-XC would be worth looking into.
The key here though is that design effort is important. If you carefully
design your federated storage, then you should be good. However this leads
to lots of problems and you need to think them through.
--
B
ess others.
Why should a user care? Because it means that there is better
compatibility than there would be for a typical fork. It is still a much
more complex product, and for a much more complex niche. However there
will be areas where they are not the same, particularly when it comes t
On Sun, Nov 17, 2013 at 6:57 PM, Tony Theodore wrote:
>
> On 15 Nov 2013, at 8:04 pm, Chris Travers wrote:
> >
> > In general, if you don't know you need composite types, you don't want
> them. You have basically three options and the way you are doing it is the
1 - 100 of 557 matches
Mail list logo
