Hello,
I have a question for Btree indexes on a varchar field.
Does postgres (7.0.2) uses a special encoding when creating
Btree indexes on varchar??
Is it much more efficient to create indexes on integer than
on strings with average length 30 chars??
Thank you in advance for your help
Regard
Hello,
I have created a table
test1(fromuri varchar(350), tovalue(varchar(3000))
and I have created a btree index on the fromuri attribute.
The size of the table is 630kb while the size of the index is
417kb.
I execute the following query
select * from test1 where fromuri like 'http://ww%';
Hello,
I am using jdbc interface to load my data and Postgresql 7.02.
I want to use copy command to load data from a unicode file.
How can I notify the server that the encoding of the file is unicode
and not the default encoding of the file system.
Thanks in advance
Regards
Sofia Alexaki
Hello,
I have two questions concerning space and time required to
load huge volume of data in the DBMS.
To note I use JDBC interface to load the schema and data in the postgresql
In order to create the tables contained in my database
I use the command stmt.executeUpdate("CREATE TABLE t1
Hello,
A)
I am going to load a huge amount of data in the DBMS using JDBC
and I want to reduce as much as possible the required loading time.
Initially I loaded all data in one transaction. Subsequently, I increased
the number of buffers and disabled fsync() (-o -F) and I loaded the
data again
Hello,
I have the following tables in my database
Painter(id integer, uri varchar(256))
paints(id1 integer, id2 integer)
in order to speed up the join (select * from painter, paints where
painter.id= paints.id1) between these two tables I have created indexes
on the field painter.id and/or pa
Hello,
I have the following tables in my db
Painter (id integer, uri varchar(256)) and
paints (id1 integer, id2 integer)
I want to optimize the question
select id from Painter where uri = 'x';
What kind of index (Btree or Hash) is more efficient to create on field
uri since it'