Re: [GENERAL] recordings of pgconf us 2016

2016-05-31 Thread Jim Mlodgenski
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

2016-02-29 Thread Jim Mlodgenski
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 > (http://www.postgresql.org/docs/

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

2016-01-19 Thread Jim Mlodgenski
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 be dynamic. Somet

Re: [GENERAL] WIP: CoC V4

2016-01-12 Thread Jim Mlodgenski
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 enforcing a > safe, respect

Re: [GENERAL] PGConf NYC 2015 videos

2015-05-13 Thread Jim Mlodgenski
On Wed, May 13, 2015 at 9:43 AM, Yves Dorfsman 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. > > > >

Re: [GENERAL] PGConf NYC 2015 videos

2015-05-13 Thread Jim Mlodgenski
On Wed, May 13, 2015 at 9:24 AM, Lukas Lehner 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 live in Europe

Re: [GENERAL] debugging with gdb in postgres

2014-07-08 Thread Jim Mlodgenski
On Tue, Jul 8, 2014 at 12:40 PM, Ravi Kiran 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 but no binary exe

Re: [GENERAL] postgres-fdw questions

2014-01-24 Thread Jim Mlodgenski
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 forei

Re: [GENERAL] Amazon EC2 CPU Utilization

2010-01-27 Thread Jim Mlodgenski
postgres 20 0 49808 2012 1544 R 3.3 0.0 0:01.81 pgbench -S -c > 1 -T > 30 > > 1513 postgres 20 0 49808 2016 1544 S 3.0 0.0 0:01.07 pgbench -S -c > 1 -T > 30 > > 1522 postgres 20 0 49808 2012 1544 S 3.0 0.0 0:00.86 pgbench -S -c > 1 -T > 30 >

Re: [GENERAL] Amazon EC2 CPU Utilization

2010-01-27 Thread Jim Mlodgenski
0.00 0.000.000.00 0.00 0.00 0.00 > 0.000.00 0.00 0.00 > > Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz > avgqu-sz await svctm %util > sda1 0.00 3.570.00 0.79 0.0034.9244.

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

2009-09-09 Thread Jim Mlodgenski
nges to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Jim Mlodgenski EnterpriseDB (http://www.enterprisedb.com)

Re: [GENERAL] horizontal sharding

2009-06-15 Thread Jim Mlodgenski
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)

Re: [GENERAL] horizontal sharding

2009-06-15 Thread Jim Mlodgenski
onal situations. > > also 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 Mlodgens

Re: [GENERAL] What's up with EnterpriseDB?

2005-08-11 Thread Jim Mlodgenski
it that as well. Thanks,   Jim --------- Jim Mlodgenski Sr. Architect http://www.enterprisedb.com         From: David Fetter <[EMAIL PROTECTED]>Date: Aug 10, 2005 5:54 PMSubject: Re: [GENERAL] What's up with EnterpriseDB?To: "Joshua D. Drake" <[EMAIL PROTECTED]>Cc