Hello,
Can anybody tell us - how much 'text' datatype harder for
database vs 'varchar(xx)' datatype? How much queries, which
use this types differ in performance? We use only 'text'
fields. Is 'varchar' (without specifying width) synonym
for 'text', or not?Thanks.
Hello,
In the FreeBSD 4.5 appear additional O_DIRECT option for open(2),
which mean "eliminate or reduce cache effects". I think, that double
buffering the same disk blocks is ineffective. I grepped all
PostgreSQL sources for this options and didn't find this anywhe
Hi all,
the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0)
is affectd by an error that not permit anymore to use the
pgdb interface for python.
In that file there is present the following query:
SELECT typname, typprtlen, typlen
FROM pg_type WHERE oid = %s" % oid
the column typ
[Removing cross post to [EMAIL PROTECTED]]
* Gaetano Mendola <[EMAIL PROTECTED]> [2002-12-08 17:45 +0100]:
> Hi all,
>
> the file pgdb.py distribuited with Postgresql 7.3 RPM ( RedHat 8.0)
> is affectd by an error that not permit anymore to use the
> pgdb interface for python.
>
> In that file t
On Sun, 2002-12-08 at 08:28, Ruslan A Dautkhanov wrote:
> Hello,
>
> Can anybody tell us - how much 'text' datatype harder for
> database vs 'varchar(xx)' datatype?
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/datatype-character.html
>From that page: "Tip: There are n
