On Tue, Aug 27, 2024, 5:09 AM Chris Travers wrote:
> This message is being sent from the Community Code of Conduct Committee,
> with the approval of the Core Team.
>
> As part of the Community CoC policy, the Committee membership is to be
> refreshed on an annual basis. We are
to tell us about yourself that is helpful for us
to know about your potential involvement with the CoC Committee?
Please be sure to send your reply to the CoC email listed above. Thank you!
Regards,
Chris Travers
Acting Chair
PostgreSQL Community Code of Conduct Committee
Abramova, Sergei Kim, Simon Pain, and Chris Travers currently sit
on the committee.
Chris Travers is currently acting as chair.
More information about those on the committee can be found at the above
link.
Best Wishes,
Chris Travers
Interim Chair, Code of Conduct Committee
ion is to require a password plus
clientcert=sameuser. This allows you to authorize devices/user accounts
for specific remote database connections and provides that second factor --
i.e. something you have as well as something you know.
>
>
> Regards
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
time commitment
irequirements are not set. Any amount of help is welcome no matter how
small.
Is anyone interested in helping out?
Best Wishes,
Chris Travers
uldn't prune.
>
Was there a datatype issue here? Like having a partition key of type
timestamp, but the query casting from date?
>
> When I departitioned the tables, performance became acceptable.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
eneral approach is to COPY FROM STDIN and then use pg_putcopydata for
each row, and finally pg_putcopyend to close out this. It's not too
different from what psql does in the background.
>
>
> --
>
> Bien à vous, Vincent Veyron
>
&g
On Thu, Nov 30, 2023 at 9:03 AM Abdul Qoyyuum
wrote:
> Hi Chris,
>
> On Wed, Nov 29, 2023 at 7:38 PM Chris Travers
> wrote:
>
>>
>>
>> On Wed, Nov 29, 2023 at 4:36 PM Abdul Qoyyuum
>> wrote:
>>
>>> Hi all,
>>>
>>> Knowi
ndicators.
However, once these errors start happening, you are in danger territory and
need to find out why (and correct the underlying problem) before you get
data loss.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Hi everyone,
Does anyone here know if the default PostgreSQL images set NUMA policies?
I am assuming not? Is there an easy way to make them do this?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
between myself and the audience.
Slides should be a mnemonic device for you as a speaker and for the
audience later, not a source of direct information except when you need a
visual exploration and then the images are helpful.
>
>
> HTH,
>
> SteveT
>
> Steve Litt
>
> Autumn 2023 featured book: Rapid Learning for the 21st Century
> http://www.troubleshooters.com/rl21
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
e other reasons to rewrite but it really depends on a
lot of factors.
>
> Yours,
> Laurenz Albe
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
t;
>
>
>
>
> best regards,
> Ilya Kosmodemiansky,
> CEO, Data Egret GmbH
> Herrenstr. 1 A 2,
> Spiesen-Elversberg, Germany
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
creating all
the partitions you expect even if they are empty, and seeing how long
EXPLAIN takes to run. If that's good enough, then go for it. If it is too
long then you could pre-calculate what partition to hit or you could use
fewer partitions.
>
> Thanks.
>
>
--
Best Wishes
up
>> pg_dumpall --globals-only > globals.sql
>>
>
> What is the relevance of globals-only and what this will do ${DB}.log
> // or is it ${DB}.sql ?
>
> pg_dump --format=d --verbose --jobs=$THREADS $DB &> ${DB}.log // .log
>> couldn't get an idea what it mean
>>
>> If you're 100% positive that the system you might someday restore to is
>> *exactly* the same distro & version, and Postgresql major version, then
>> I'd use PgBackRest.
>>
>> --
>> Born in Arizona, moved to Babylonia.
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
stgresql
> > password to the same password at once.
>
> To the same value??
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Jun 2, 2023, 09:36 Oliver Kohll wrote:
> Hi,
>
> Just wondering, does anyone else create apps which might not have 'big'
> data, but quite complex arrangements of views joining to each other?
>
> If so, do you have scripts to aid refactoring them e.g. drop/recreate/test
> them in the righ
The latest entry is at:
https://www.timescale.com/blog/a-postgresql-developers-perspective-five-interesting-patches-from-januarys-commitfest/?utm_source=timescaledb&utm_medium=linkedin&utm_campaign=mar-2023-advocacy&utm_content=tsdb-blog
--
Best Wishes,
Chris Travers
o just roll their
own solutions.
>
> > Trying to write documentation on how to develop a complete solution
> > would be quite an effort and would certainly go beyond bash scripting
> > and likely wouldn't end up getting used anyway- those who are developing
> > such s
n the picture. And there are
other areas of complexity, such as how you handle partial page writes.
On the whole I think for small dbs it might perform well enough. On large
or high velocity dbs I think you will have more problems than expected.
Having worked with PostgreSQL on ZFS I wouldn't
ght true for Sybase, but I've never done a
> detailed comparison.
>
Indeed. MongoDB has some interesting features like capped collections
which make it useful as a cache, but my experience always leaves me feeling
like performance and scalability are lacking.
>
>
> Cheers,
> Gav
rther. Kind regards, James
>
If you are posting here, is it because they want to move all these to
PostgreSQL?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
e basically immutable.
>
> --
> Scott Ribe
> scott_r...@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
lue from, say, 100 IDR to 100 EUR at least for
display purposes.
I have some thoughts about how to do a multi-currency type but I am not
actually sure you get anything by tying the data together instead of having
it in separate columns.
>
> cheers,
> raf
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
high throughput systems (I have
systems where a db cluster generates 10-20TB of WAL per day)
So I am not at all sure this would be a step in the right direction or
worth the work.
>
> --
> Andreas Joseph Krogh
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
iting an import for JSON objects into a particular database is
indeed trivial.
>
> C
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
sense of index possibilities and
how the indexes actually work.
> lbrtchx
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
the big names that use Postgres, e.g. MasterCard, Government
> agencies, Banks, etc.
> >
> You might be interested in this:
> https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP.
mption inefficiency (in
> comparison to MySQL) problem?
>
Long run pluggable storage should give people a different set of options
and choices to make here.
>
> Many thanks,
>
> sps-ray
>
>
> ---
> This email has been checked for viruses by Avast antivirus software
n indexes
So you can:
create index foo on bar ((id % 1000));
And then use the index on:
select * from bar where id % 1000 = 45;
You could similarly
create index foo on bar (extract(day from date_field));
The left side needs to be indexed (and an immutable expression) but beyond
that.
>
&g
time and can often avoid running it on selection time if it
is just a part of the where clause.
In my experience usually we have used trigger-updated functions when the
field values are very large or expensive, and may need to be part of the
column list, and functions with functional indexes whe
es.
> You have no idea how large a can of worms that opens (but I'll just
> mention that "which characters are letters" doesn't even have a well
> defined universal answer).
>
+1
>
> regards, tom lane
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
t direction.
>
> The only mechanism available to put any semantics into the database is via
> the naming of identifiers. Why screw with that? Imagine what would happen
> if your IDE decided to do that to your java code.
>
>
> Different languages address case and identif
If you are considering MySQL you
might want to use MariaDB instead. But PostgreSQL avoids most of these
issues and ensures that even if you are distributing the db with a
proprietary application, there are no licensing implications of doing that.
> Regards,
> Sonam
>
--
Best Wishes,
Chri
On Thu, Feb 28, 2019 at 1:50 PM Nicolas Grilly
wrote:
> On Thu, Feb 28, 2019 at 1:24 PM Chris Travers
> wrote:
>
>> 1. a) TB-scale full text search systems.
>> b) PostgreSQL's full text search is quite capable but not so
>> powerful that it can completely r
t instead.
>
> Don't use Postgres like cache, don't use Postgres for non transactional
> short life often updated data.
>
> Use inmemory databases instead
>
> Pavel
>
>
>>
>> Regards,
>>Thomas Güttler
>>
>>
>> --
>> Thomas
; --
>
> Thanks and Regards,
> Sachin Kotwal
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
gt;>
>>> On Wed, Oct 3, 2018, 7:43 PM Sonam Sharma wrote:
>>>
>>>> I have restored the database from backup dump but the size of source
>>>> and target databases are different. What can be the reason for this ?
>>>>
>>>> Regards,
>>>> Sonam
>>>>
>>>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
atabase is constructed with pg_dump and restore on fresh postgres
> installation.
>
Sounds like warming up the cache, but still in a test environment you may
want to add auto_explain to your list of preloads and perhaps set it to
dump explain analyze when it hits a certain threshold. Note t
nice addition and
prevents a lot of concern.
>
> --
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
oC to emphasise that while we don't want to restrain people
> from "calling out" egregious behaviour, going via the CoC team is often
> more likely to lead to constructive communication and positive change.
>
Agreed on this.
My objection to the additional wording is simply that a) I think it does
not tackle the problem it needs to tackle, and b) creates a claim which
covers a bunch of things that it really shouldn't. It's a serious bug and
I still hope it gets fixed before it causes problems.
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
reason to think that feedback gathered now will have
any impact at all in the next revision.
>
> regards, tom lane
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
oing elsewhere. So I don't think ti is a question of "trust us" but
rather that the community won't let that sort of abuse happen no matter who
is on the CoC committee.
>
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
nk&utm_campaign=sig-email&utm_content=emailclient>
> <#m_-9091154853724945458_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Mon, Sep 17, 2018 at 6:08 PM Steve Litt
wrote:
> On Mon, 17 Sep 2018 17:39:20 +0200
> Chris Travers wrote:
>
>
> > Exactly. And actually the first sentence is not new. The second one
> > is a real problem though. I am going to try one last time at an
&g
> JD
>
> --
> Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
> *** A fault and talent of mine is to tell it exactly how it is. ***
> PostgreSQL centered full stack support, consulting and development.
> Advocate: @amplifypostgres || Learn: https://postgresconf.org
> * Unless otherwise stated, opinions are my own. *
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
y big problem here since it
means you can have race conditions in advisory locks that can't happen with
other locking issues. I still love advisory locks but they are not a good
tool for this.
The real solution most of the time is actually to lock the rows by
selecting FOR UPDATE and possibly SK
another Code of Conduct that takes precedence (such as a
conference's Code of Conduct)." I don't think that sentence solves the
problems you are trying to solve, and I think it creates new ones.
However I have said my piece. Unless there are replies that provide
something new for me to add, I won't continue arguing over that from here.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
se while I don't see
the current community taking action on the basis of political views, I do
see a problem more generally with how these fights get picked and would
prefer to see some softening of language to protect the community in that
case. But again, I am probably being paranoid.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
and keep the peace, giving people room for civic
engagement even on divisive issues.
And frankly I am probably being paranoid here though I find paranoia is a
good thing when it comes to care of databases and computer systems. But I
do worry about the interactions between the PostgreSQL comm
is today and we must continue to do this.
2. Compared to the rest of the world, people from my culture (the US) have
a tendency to take disagreements regarding political policies, social
theories, etc. personally and see abuse/attack where mere disagreement was
present. People making complaints aren't necessarily acting in bad faith.
3. If we don't set the expectation ahead of time that we remain
pluralistic in terms of political philosophy, culture, then it is way too
easy to end up in a situation where people are bringing up bad press for
failing to kick out people who disagree with them.
Like it or not there are precedents for this in the open source community,
such as the dismissal of Brendan Eich, and in an international project with
developers from all kinds of cultures with different views on deeply
divisive issues, such conflicts could hurt our community.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Sep 14, 2018 at 4:16 PM Tom Lane wrote:
> [ Let's try to trim this discussion to just -general, please ]
>
> Robert Eckhardt writes:
> > On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver
> > wrote:
> >> On 9/14/18 1:31 AM, Chris Travers wrote:
&g
On Fri, Sep 14, 2018 at 4:14 PM Dave Page wrote:
>
>
> On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake
> wrote:
>
>> On 09/14/2018 01:31 AM, Chris Travers wrote:
>>
>>
>> I apologize for the glacial slowness with which this has all been moving.
&
On Fri, Sep 14, 2018 at 11:45 AM Ilya Kosmodemiansky
wrote:
> On Fri, Sep 14, 2018 at 10:31 AM, Chris Travers
> wrote:
> > I really have to object to this addition:
> > "This Code is meant to cover all interaction between community members,
> > whether
On Fri, Sep 14, 2018 at 10:31 AM Chris Travers
wrote:
>
>
> On Wed, Sep 12, 2018 at 10:53 PM Tom Lane wrote:
>
>> I wrote:
>> > Stephen Frost writes:
>> >> We seem to be a bit past that timeline... Do we have any update on
>> when
>>
PostgreSQL.
>
> I think we are about ready to announce the initial membership of the
> CoC committee, as well, but that should be a separate post.
>
> regards, tom lane
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ly free ?
>> > Any performance issues or any limitations?
>>
>> Yes, yes, depends
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
this is clearly intended to be supported we would
like to work with upstream library vendors to make sure this functionality
is included. My reading of the docs is that parameterized queries are not
possible but simple queries are. Is this correct?
--
Best Wishes,
Chris Travers
Efficito:
direction.
>
> I'd probably leave it up to the CoC team/people to figure it out. :)
+1
If it were me I would just say that CoC has an obligation to try in good
faith to resolve things in line with the common interest of an
international community and leave it at that.
>
>
&
ommittee will likely have to sort out such
> situations and try to reconcile the two people without either starting a
> war or driving away either person. They may not always succeed. But not
> trying is not a better answer.
For what its worth, I am 100% in agreement with everything
;This word does not mean anything bad
> where I come from."
>
This is true but it is needed that the committee is culturally diverse and
advertised as such. Otherwise I am concerned that it would signal to some
people that a certain sort of abuse would be permitted.
>
> --
> -- Christophe Pettus
>x...@thebuild.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, Jun 7, 2018 at 2:14 AM, Jan Claeys wrote:
> On Wed, 2018-06-06 at 07:27 +0200, Chris Travers wrote:
> > The real fear here is the code of conduct being co-opted as a weapon
> > of world-wide culture war and that's what is driving a lot of the
> > resistance here
On Wed, Jun 6, 2018 at 2:07 AM, Jan Claeys wrote:
> On Tue, 2018-06-05 at 16:45 +0200, Chris Travers wrote:
> > If I may suggest: The committee should be international as well
> > and include people from around the world. The last thing we want is
> > for it to be dominat
gt;
>
At the end I see signals in the current CoC that make me hopeful. Phrases
like "common interest" occur. There are some minor changes I think would
help avoid problems. But they aren't big deals. The big thing is I trust
our community not to exclude people based, for example, on political or
cultural perspectives and thats really important.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
banned), and this is one issue which is incredibly divisive
throughout the world with a lot of people having very deep-seated feelings
on the issue, where one can expect small differences to lead to big
conflicts. And I think we want to avoid wading into those conflicts.
>
> Jim
>
>
to form viable third parties in the US political landscape. An
international CoC committee is our best defense against an effort to co-opt
the community in the way you are worried about.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
king the CoC official as of
> July 1 2018.
>
> regards, tom lane
>
> [1] https://www.postgresql.org/message-id/56a8516b.8000...@agliodbs.com
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
to
addressing these sorts of issues.
>
>
> Be very careful in attempting to codify 'correct' behaviour!
>>
>>
> Correct. I think one way to look at all of this is, "if you wouldn't say
> it to your boss or a client don't say it here". That too has problems but
> generally speaking I think it keeps the restrictions rational.
>
>
I will post a more specific set of thoughts here but in general I think the
presumption ought to be that people are trying to work together.
Misunderstanding can happen. But let's try to act in a collegial and
generally respectful way around eachother.
--
Best Regards,
Chris Travers
Database Administrator
Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com
Saarbrücker Straße 37a, 10405 Berlin
digit to the right of the decimal point.
>>> --
>>> Mike Nolan
>>>
>>>
>>
> >Percentage calculation exists in almost any databse and information
> system
>
> That is not exactly true. AFAIK, only Oracle has a Percentage function.
> SQL Server and MySQL do not.
> It has already been shown that it is just as easy to code percentage
> inline (EG: SELECT (50.8 x 5.2) / 100 AS pct; ## .026416
> as it is to call a function SELECT pct(50.8, 5.2);
> Please do not false statements to justify a request for a non-needed
> enhancement.
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
aces. Stay
tuned ;-)
>
> Kind regards
>
> Thiemo
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Nov 30, 2017 08:35, "Durumdara" wrote:
Hello!
Somewhere the users made mistakes on prices (stock).
I need to search for big differences between values.
For example:
20
21
21,5
30
28
..
46392 <-
46392 <-
But it could be:
42300
43100
44000
43800
65000 <-
42100
Human eye could locate these
71 matches
Mail list logo
