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
:
> 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&
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
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
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
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
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
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'