Re: [GENERAL] recordings of pgconf us 2016

On Sun, May 29, 2016 at 12:36 AM, Johannes wrote: > I guess I have seen all video recording from pgconf us 2015 at youtube. > Are there any recording from this year available? > We are still waiting to have them edited by the video company. Hopefully it will be soon.

Re: [GENERAL] multicolumn index and setting effective_cache_size using human-readable-numbers

On Mon, Feb 29, 2016 at 8:56 AM, Geoff Winkless wrote: > I'm sure I'm missing something here. > > A query takes 50 seconds; it's doing a seq-scan on a joined table, > even though the table is joined via a field that's the leftmost column > in a multicolumn index >

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

On Tue, Jan 19, 2016 at 5:05 PM, Peter Devoy wrote: > As part of the extension I am writing I am trying to create a trigger > procedure in which the value of the primary key of the NEW or OLD row > is used. The trigger will be fired by arbitrary tables so the column > name must

Re: [GENERAL] WIP: CoC V4

On Tue, Jan 12, 2016 at 11:50 AM, Joshua D. Drake wrote: > Tl;dr; > > * Removed specific examples and reworded #3 to be more concise > > PostgreSQL Global Development Group (PGDG) Code of Conduct (CoC): > > 1. The CoC is to provide community guidelines for creating and

Re: [GENERAL] PGConf NYC 2015 videos

On Wed, May 13, 2015 at 9:24 AM, Lukas Lehner webleh...@gmail.com wrote: Hi Where can I download PGConf NYC 2015 videos? Was there a recording? Yes, the talks were recorded. There was a lot of content so we are still working on getting everything together. We hope to have them up soon. I

Re: [GENERAL] PGConf NYC 2015 videos

On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman y...@zioup.com wrote: On 2015-05-13 07:37, Jim Mlodgenski wrote: Yes, the talks were recorded. There was a lot of content so we are still working on getting everything together. We hope to have them up soon. Will you be posting

Re: [GENERAL] debugging with gdb in postgres

On Tue, Jul 8, 2014 at 12:40 PM, Ravi Kiran ravi.kolanp...@gmail.com wrote: hi, I am trying to learn how postgresql implements the join algorithms. So I am trying to learn about the source code of the executor precisely the file nodenestloop.c . In the executor file I have nodenestloop.o

Re: [GENERAL] postgres-fdw questions

On Fri, Jan 24, 2014 at 4:20 AM, Emmanuel Medernach meder...@clermont.in2p3.fr wrote: Hello, I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have some questions: - What are the limits to the number of foreign tables ? - What is the current status about foreign joins

Re: [GENERAL] Amazon EC2 CPU Utilization

pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- -- Jim Mlodgenski EnterpriseDB (http://www.enterprisedb.com)

Re: [GENERAL] Amazon EC2 CPU Utilization

postgres: stats collector process -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- -- Jim Mlodgenski EnterpriseDB (http://www.enterprisedb.com)

Re: [GENERAL] Swapped download links for 8.4.1 zip binaries

the Mac binaries, when clicking on the Mac icon, you'll get the windows binaries :) This is now fixed. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- -- Jim

Re: [GENERAL] horizontal sharding

is it possible to paritition without changing client code Yes, but it depends on the SQL in your client code. If you are just using simple SQL with no stored functions, you should be able to slip in either solution without changing the client code. -- Jim Mlodgenski EnterpriseDB (http

Re: [GENERAL] horizontal sharding

. There are agents running on each of the nodes that handles the inter-node communication allowing it to be transparent to the calling application. -- Jim Mlodgenski EnterpriseDB (http://www.enterprisedb.com)