Michael Rudolph wrote:
>
> To let all of you know the status of my problem: I got on one large
> step when realized, that I forgot a "vacuum analyze" after copying the
> data. When I did this, my performance gain was huge - but didn't reach
> the performance of centura at all. It is still a bit sl
> > There is one table, let's
> > say table1, with about 11. rows. On doing a "select distinct var1
> > from table1" via ODBC-Driver, I had to wait about 15 sec for the result.
1. I assume following index exists:
create index table1_x0 on table1 (var1);
"select distinct" when execut
> How many rows are returned by the query in reality ?
> Does the table *table1* have an index on the column *var1*
> in your centura sqlbase ?
... and did you do a "vacuum analyze"? What is the schema? What is the
query? What is the result of "explain" for that query?
All of these things are re
pgsql-odbc doesn't seem a right place to post.
I forwarded my reply to pgsql-hackers also.
Michael Rudolph wrote:
>
> Hi,
>
> I have a performance-problem with my Postgresql-database: up to now I
> had centura sqlbase but for some reasons I have to change to Postgres.
> After copying the data of
