Stephan Szabo schrieb:
> Did you reset the table contents between these two (remember that
> explain analyze actually runs the query)? The second appears to be
> changing no rows from the output.
I for myself did not, but as there are runnig automatic jobs
periodically I can't tell, if one ran i
Hi folks!
I have just a issue again with unused indexes. I have a database with a
couple of tables and I have to do an sync job with them. For marking
which row has to be transfered I added a new column token (integer, I
will need some more tokens in near future) to every table.
Before determini
Hi all!
First thanks to any answer by now :-)
> You don't post your table definitions (please do), but it looks like
> test_b, test_c, test_d and test_e might be bigints? If so, you may
> want to do explicit "AND test_b=1::bigint AND test_c=2::bigint" etc.
> -- 7.4 doesn't figure this out for you
Hi, all!
I've been using postgresql for a long time now, but today I had some
problem I couldn't solve properly - hope here some more experienced
users have some hint's for me.
First, I'm using postgresql 7.4.7 on a 2GHz machine having 1.5GByte RAM
and I have a table with about 220 columns and 2
