Re: [GENERAL] Joining 16 tables seems slow

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 approx 200ms of your query time comes from. Looking at this in more detail it doesn't look This is not a problem with too many tables in the join but the fact that you are joining the same tables in multiple times in ways you end up needing to repeatedly sequentially scan them. I also don't think an index is going to help unless you have accounting data going way back (since you are looking for about a year's worth of data) or unless 90% of your transactions get marked as deleted. So I think you are stuck with the sequential scans on this table and optimizing will probably mean reducing the number of times you scan that table. > > Frank > > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

[GENERAL] pgxn manager down

). If 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

Re: [GENERAL] bidirectional mapping?

riage m on p1 = any(marriage.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

Re: [GENERAL] vacuum on streaming replication

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

Re: [GENERAL] Strange case of database bloat

On Wed, Jul 5, 2017 at 3:51 PM, Bill Moran <wmo...@potentialtech.com> wrote: > On Wed, 5 Jul 2017 13:28:29 +0200 > Chris Travers <chris.trav...@gmail.com> wrote: > > > On Wed, Jul 5, 2017 at 1:00 PM, PT <wmo...@potentialtech.com> wrote: > > > > > 2x

Re: [GENERAL] Strange case of database bloat

speculation 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 verify that

Re: [GENERAL] Imperative Query Languages

, there are other 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 A

Re: [GENERAL] Strange case of database bloat

On Wed, Jul 5, 2017 at 7:18 AM, Chris Travers <chris.trav...@gmail.com> 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. > > Probl

Re: [GENERAL] Imperative Query Languages

Nope. You have 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 > &g

Re: [GENERAL] Imperative Query Languages

there it is extremely 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

[GENERAL] Strange case of database bloat

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 Flexible

Re: [GENERAL] Is the row version available in SQL?

ad > > … and if that gets 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

Re: [GENERAL] Unable to understand index only scan as it is not happening for one table while it happens for other

> View this message in context: 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 vi

[GENERAL] Recorded PostgreSQL at 10TB and Beyond

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

[GENERAL] Free seminar in Malmo: PostgreSQL at 10TB and Beyond

are 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

Re: [GENERAL] Performance PLV8 vs PLPGSQL

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

Re: [GENERAL] Appending to multidimentional array.

> 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: Hosted

Re: [GENERAL] Appending to multidimentional array.

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

Re: [GENERAL] Looking for an online mentor

sten > -- > 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/mailp

Re: [GENERAL] PDF files: to store in database or not

esql.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

Re: [GENERAL] pgbasebackup necessary for master slave change?

-- > > 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://w

Re: [GENERAL] pgbasebackup necessary for master slave change?

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/pgsql-

Re: [GENERAL] When to use COMMENT vs --

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

Re: [GENERAL] high transaction rate

I prevent contention? > > This 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

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

mas-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

Re: [GENERAL] Any reasons for 'DO' statement not returning result?

On Tue, Aug 16, 2016 at 3:11 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Sun, Aug 14, 2016 at 5:58 AM, Chris Travers <chris.trav...@gmail.com> > wrote: > > >> > >> All this seems to be a huge change which will definitely not appear any > >>

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

have a person object and want 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,

Re: [GENERAL] Any reasons for 'DO' statement not returning result?

ght back at the same amount of overhead as a temporary function. > > On Sun, Aug 14, 2016 at 10:42 AM, Chris Travers <chris.trav...@gmail.com> > wrote: > >> If all you want is a temporary function, you *can* create it in the >> pg_temp namespace though that seems hack

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

On Sun, Aug 14, 2016 at 12:35 PM, Karsten Hilbert <karsten.hilb...@gmx.net> 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 elaborat

Re: [GENERAL] Any reasons for 'DO' statement not returning result?

no luck with that feature 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

Re: [GENERAL] Postgres Pain Points: 1 pg_hba conf

Of course that differs 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 subscrip

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

On Fri, Aug 12, 2016 at 11:32 AM, Karsten Hilbert <karsten.hilb...@gmx.net> 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 > &g

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

n really handy. The same basic approach can 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

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh <andr...@visena.com> 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 thi

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh <andr...@visena.com> 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 <andr...@visena.com >

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

; -- > *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

Re: [GENERAL] Uber migrated from Postgres to MySQL

On Thu, Jul 28, 2016 at 8:09 PM, Edson Richter <edsonrich...@hotmail.com> wrote: > Em 28/07/2016 13:07, Chris Travers escreveu: > > > > On Thu, Jul 28, 2016 at 3:38 PM, Scott Marlowe <scott.marl...@gmail.com> > wrote: > >> On Wed, Jul 27, 2016 at 9:51

Re: [GENERAL] Uber migrated from Postgres to MySQL

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

Re: [GENERAL] Uber migrated from Postgres to MySQL

this is exhibit A as to why (I am sure it is a thread race issue between 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. &g

Re: [GENERAL] Uber migrated from Postgres to MySQL

to 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

Re: [GENERAL] Uber migrated from Postgres to MySQL

unds 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 >

Re: [GENERAL] unique constraint with several null values

ly appreciated. I can't do much about the data > model itself right now, I need to protect the integrity of the data. > > Thanks! > -mark- > > > > > > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [GENERAL] Enhansement proposal: ordering by parameter

r uniformly majorly 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

Re: [GENERAL] Thoughts on "Love Your Database"

id 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

Re: [GENERAL] Thoughts on "Love Your Database"

anges 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

Re: [GENERAL] Scaling Database for heavy load

to query against your replicas. 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

Re: [GENERAL] Thoughts on "Love Your Database"

ql-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

Re: [GENERAL] Partitioning and ORM tools

On Wed, Mar 23, 2016 at 9:39 AM, Chris Travers <chris.trav...@gmail.com> 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 <cs_...@consistentstate.com> > wrote: > >>

Re: [GENERAL] Partitioning and ORM tools

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

Re: [GENERAL] vacuum - reclaiming disk space.

L cannot > seem to finish within the scheduled downtime. > > Any suggestions for reclaiming the space without excessive downtime? > > > * <mike.blackw...@rrd.com>* > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [GENERAL] How to delete few elements from array beginning?

On Wed, Mar 9, 2016 at 4:53 PM, Alexander Farber <alexander.far...@gmail.com > wrote: > Hello Chris, > > On Wed, Mar 9, 2016 at 4:42 PM, Chris Travers <chris.trav...@gmail.com> > wrote: > >> >> >> On Wed, Mar 9, 2016 at 1:10 PM, Alexander

Re: [GENERAL] How to delete few elements from array beginning?

layed1 IS NULL OR played1 < played2); > > 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

Re: [GENERAL] Replacement for Oracle Text

very INSERT or UPDATE. >> >> FWIW, I just use pdftotext in my CGI. > > -- > > = > Stephen Davies Consulting P/L Phone: 08-8177 > 1595 > Adelaide, South Australia.

Re: [GENERAL] Suggest note in index documentation about long running transactions

On Tue, Feb 16, 2016 at 6:04 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > I wrote: > > Chris Travers <chris.trav...@gmail.com> writes: > >> Unless there is a sense that this is a bad idea I will submit a doc > patch. > > > I was already working on it .

Re: [GENERAL] Suggest note in index documentation about long running transactions

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 <chris.trav...@gmail.com> wrote: > Hi; > > Today I ran into a question from a client as to why an index was not > used. The index had be

[GENERAL] Suggest note in index documentation about long running transactions

the 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

Re: [GENERAL] PostgreSQL vs Firebird SQL

s in application 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

Re: [GENERAL] Let's Do the CoC Right

essed 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

Re: [GENERAL] CoC [Final v2]

stgres.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/mail

Re: [GENERAL] Let's Do the CoC Right

> 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

Re: [GENERAL] CoC [Final v2]

, first comes the CoC, then comes the > enforcement policy. > > 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

Re: [GENERAL] A motion

neral 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

Re: [GENERAL] CoC [Final v2]

simply saying we aren'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

Re: [GENERAL] CoC [Final v2]

> > > * Behaviour which 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

Re: [GENERAL] CoC [Final v2]

On Sun, Jan 24, 2016 at 6:34 PM, Joshua D. Drake <j...@commandprompt.com> 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 >>

Re: [GENERAL] CoC [Final v2]

On Sun, Jan 24, 2016 at 11:14 PM, David E. Wheeler <da...@justatheory.com> wrote: > On Jan 24, 2016, at 11:28 AM, Chris Travers <chris.trav...@gmail.com> > wrote: > > >> * PostgreSQL is a community project and takes no position on any > >> political ques

Re: [GENERAL] Let's Do the CoC Right

e uncomfortable. 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

Re: [GENERAL] CoC [Final]

On Thu, Jan 21, 2016 at 12:39 PM, Geoff Winkless <pgsqlad...@geoff.dj> wrote: > On 21 January 2016 at 11:28, Chris Travers <chris.trav...@gmail.com> > wrote: > > Resisting the urge to talk about how justice was actually seen in the > Dark > > Ages > > P

Re: [GENERAL] CoC [Final]

On Thu, Jan 21, 2016 at 11:43 AM, Geoff Winkless <pgsqlad...@geoff.dj> wrote: > On 21 January 2016 at 10:37, Chris Travers <chris.trav...@gmail.com> > wrote: > > At the end of the day this will require human judgment rather than > > formulation. > > The

Re: [GENERAL] CoC [Final]

an formulation. Human judgment may be flawed 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.or

Re: [GENERAL] WIP: CoC V5

y. The second 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 togeth

Re: [GENERAL] Code of Conduct: Is it time?

On Wed, Jan 13, 2016 at 9:00 AM, John R Pierce <pie...@hogranch.com> 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

Re: [GENERAL] WIP: CoC V5

ast a bit less of a problem.. > > 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

Re: [GENERAL] WIP: CoC V5

rt to work out issues. > > > > > Thanks, > > Regina > > > > *From:* Regina Obe [mailto:l...@pcorp.us] > *Sent:* Wednesday, January 13, 2016 9:08 AM > *To:* 'Chris Travers' <chris.trav...@gmail.com> > *Cc:* 'Geoff Winkless' <pgsqlad...@geoff.dj>; 'Psq

Re: [GENERAL] WIP: CoC V5

ia 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

Re: [GENERAL] Code of Conduct: Is it time?

to sensitive by the complainer and not being >> sensitive enough by the group. I do believe that in any document it needs to >> be stated that everyone is expected to be tolerant of others. A free >> society cannot exist without some level of tolerance. >> >> Neil >> >> > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [GENERAL] Code of Conduct: Is it time?

brief note about 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 <l..

Re: [GENERAL] Code of Conduct: Is it time?

uot;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

Re: [GENERAL] Code of Conduct: Is it time?

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

Re: [GENERAL] PL/pgSQL: How to return two columns and multiple rows

On Thu, Jun 18, 2015, 14:38 Sven Geggus li...@fuchsschwanzdomain.de 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

Re: [GENERAL] Why isn't Java support part of Postgresql core?

the software easily installable on multiple platforms. Work with the maintainers of the Windows installer to include that. Work with packagers 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

Re: [GENERAL] Why isn't Java support part of Postgresql core?

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? :-) Armed Bear Common Lisp should be accessible from pl/java right? *ducks* -- // Dmitriy. -- Best Wishes, Chris Travers Efficito

Re: [GENERAL] Why isn't Java support part of Postgresql core?

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

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On Sun, Sep 14, 2014 at 10:22 PM, cowwoc cow...@bbs.darktech.org 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

Re: [GENERAL] PostgreSQL as a triple store

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

Re: [GENERAL] PostgreSQL as a triple store

you see any pitfalls here. The triples table will grow very fast in this setup and may become a bottleneck. 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

Re: [GENERAL] PostgreSQL as a triple store

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

[GENERAL] Feature proposal and discussion: full-fledged column/function equivalence

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 Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust

Re: [GENERAL] Re: Feature proposal and discussion: full-fledged column/function equivalence

the PostgreSQL - general mailing list archive at Nabble.com. -- 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

Re: [GENERAL] Security Issues: Allowing Clients to Execute SQL in the Backend.

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 Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [GENERAL] Composite type

Wishes, Chris Travers

Re: [GENERAL] Composite type

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, Chris

Re: [GENERAL] PostgreSQL with ZFS on Linux

other than developers nervous about calling it stable. This being said, we aren't very far into our evaluation yet and our view could change. -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more.shtml

Re: [GENERAL] DB Authentication Design

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 ERP. Robust and Flexible. No vendor lock-in. http

Re: [GENERAL] question on parallelism

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 http://www.mindspring.com/~amcintyr

Re: [GENERAL] Multi Master Replication

, 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Multi Master Replication

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. -- Best Wishes, Chris Travers

Re: postgresql.org inconsistent (Re: [GENERAL] PG replication across DataCenters)

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 to performance. Best Wishes, Chris Travers Cheers, Steve -- Sent via

Re: [GENERAL] Composite types or composite keys?

On Sun, Nov 17, 2013 at 6:57 PM, Tony Theodore tony.theod...@gmail.comwrote: On 15 Nov 2013, at 8:04 pm, Chris Travers chris.trav...@gmail.com 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

[GENERAL] select ... inherits?

tests that this does something rather unexpected, in that it overrides the default column names returned with whatever is in the inherits list, but only when you have a from clause. Is this a bug, a feature, or undefined behavior? -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP

  1   2   3   4   5   6   >