[GENERAL] Query planning

2014-10-31 Thread Jayadevan M
Hi all, I am going through PostgreSQL documentation on how row estimation is done in PostgreSQL. http://www.postgresql.org/docs/current/static/row-estimation-examples.html There is a reference to cardinality (rel_cardinality) there. But that is an estimate of the number of rows in the table,

Re: [GENERAL] Planet Postgres

2014-10-31 Thread Magnus Hagander
On Thu, Oct 30, 2014 at 8:31 PM, Stephen Frost sfr...@snowman.net wrote: * Adrian Klaver (adrian.kla...@aklaver.com) wrote: On 10/30/2014 12:02 PM, Torsten Förtsch wrote: I don't know if this is the right mailing list for my question but I have already emailed pla...@postgresql.org without any

Re: [GENERAL] Planet Postgres

2014-10-31 Thread Torsten Förtsch
On 31/10/14 09:38, Magnus Hagander wrote: I think in this particular case, much of the blame can be placed on everybody being at pgconf.eu last week, and struggling under backlogs. But as Stephen says, the backlog will eventually get worked through, and the moderation happen. I see. No

Re: [GENERAL] PostgreSQL on tablet grade SSD ?

2014-10-31 Thread Merlin Moncure
On Thu, Oct 30, 2014 at 4:30 AM, Karsten Hilbert karsten.hilb...@gmx.net wrote: Hi ! Can anyone share any experiences with running PostgreSQL on a tablet ? (Surface Pro 3, ASUS Transformer) (or point to things I should read, searching the web didn't turn up anything that seemed relevant

Re: [GENERAL] PostgreSQL on tablet grade SSD ?

2014-10-31 Thread David Boreham
On 10/31/2014 7:31 AM, Merlin Moncure wrote: Can anyone share any experiences with running PostgreSQL on a tablet ? (Surface Pro 3, ASUS Transformer) The SSD in a modern tablet is considerably faster than a hard drive in a high-end server from the era when PG was originally developed so

[GENERAL] Basic question regarding insert

2014-10-31 Thread Anil Menon
Hi, I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? Assume an OLTP environment were a lots of inserts are happening to a transaction

Re: [GENERAL] Basic question regarding insert

2014-10-31 Thread Adrian Klaver
On 10/31/2014 03:24 AM, Anil Menon wrote: Hi, I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? Assume an OLTP environment were a lots

Re: [GENERAL] Basic question regarding insert

2014-10-31 Thread John R Pierce
On 10/31/2014 3:24 AM, Anil Menon wrote: I have a very basic question on inserts - I tried to get a good authoritative answer but could not really find one to my satisfaction in the usual places. TLDR : can (after) insert trigger be run in parallel? the trigger is run in the context of the

Re: [GENERAL] Query planning

2014-10-31 Thread Emanuel Calvo
El 31/10/14 a las 04:46, Jayadevan M escibió: Hi all, I am going through PostgreSQL documentation on how row estimation is done in PostgreSQL. http://www.postgresql.org/docs/current/static/row-estimation-examples.html There is a reference to cardinality (rel_cardinality) there. But that is

[GENERAL] LOADing functions

2014-10-31 Thread Andrew Becker
Hi - I seem to be unable to reLOAD a shared library within the session that I LOADed it. I am developing a UDF and my debugging changes do not appear to take until I quit psql and restart. The following code sequence demonstrates the issue |kbmod=# CREATE OR REPLACE FUNCTION hello(TEXT)

Re: [GENERAL] LOADing functions

2014-10-31 Thread Tom Lane
Andrew Becker acbec...@gmail.com writes: Hi - I seem to be unable to reLOAD a shared library within the session that I LOADed it. Nope, you can't, there's no such functionality. Hints as to what is going wrong here? I would certainly expect to be able to re-load a shared library while

Re: [GENERAL] LOADing functions

2014-10-31 Thread Adrian Klaver
On 10/31/2014 03:00 PM, Andrew Becker wrote: Hi - I seem to be unable to reLOAD a shared library within the session that I LOADed it. I am developing a UDF and my debugging changes do not appear to take until I quit psql and restart. The following code sequence demonstrates the issue |kbmod=#