[GENERAL] Maximum size for char or varchar with limit

2010-12-08 Thread Rob Gansevles
Hello, Does anyone know what the maximum length is for char or varchar columns with limit. I saw some answers to this same question referring to section 8.3 of the docs, but I don't see the actual numbers there. I know you can go to 1GB if you don't specify the limit, but I would like to know wha

Re: [GENERAL] Maximum size for char or varchar with limit

2010-12-08 Thread Rob Gansevles
: > On Wednesday 08 December 2010 5:47:25 am Rob Gansevles wrote: >> Hello, >> >> Does anyone know what the maximum length is for char or varchar >> columns with limit. >> I saw some answers to this same question referring to section 8.3 of >> the docs, but I don&

Re: [GENERAL] Maximum size for char or varchar with limit

2010-12-08 Thread Rob Gansevles
Thanks Tom, this is very helpful. Rob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Cached prepared statement slow after using it 5 times

2011-06-26 Thread Rob Gansevles
Hi, I came across a strange issue when caching prepared statement.. We are accessing postgres(9.0.3) via the jdbc driver (9.0b801) using a prepared statement cache. This works very good but in -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

[GENERAL] Reusing cached prepared statement slow after 5 executions

2011-06-26 Thread Rob Gansevles
Hi, I came across a strange issue when caching prepared statement.. We are accessing postgres(9.0.3) via the jdbc driver (9.0b801) using a prepared statement cache. This works very good but in 1 case the 5th execution (and later ones) suddenly takes 30 seconds as the first few just take less then

Re: [GENERAL] Reusing cached prepared statement slow after 5 executions

2011-06-26 Thread Rob Gansevles
I can confirm, when I call ps.setPrepareThreshold(1) the query is slow immediately, so the plan must be different with the server prepared statements. Thanks, Rob On Sun, Jun 26, 2011 at 5:11 PM, Tom Lane wrote: > David Johnston writes: >> This is likely the case where the first few "prepared

[GENERAL] Configure default for sorting of null-values?

2010-09-01 Thread Rob Gansevles
Hi, >From the docs I see that you can control null values being sorted before or after all non-null-values using 'NULLS LAST' or 'NULLS FIRST' in the order by clause. The default behaviour is to act as though nulls are larger than non-nulls. My question is, is there a way to configure this defau

Re: [GENERAL] Configure default for sorting of null-values?

2010-09-07 Thread Rob Gansevles
Does anyone know if this is configurable? Or should I file a feature request? Rob On Wed, Sep 1, 2010 at 10:05 AM, Rob Gansevles wrote: > Hi, > > From the docs I see that you can control null values being sorted > before or after all non-null-values using 'NULLS LAST'