nning with at least -B 1024 if you can.
Just try this:
explain select * from where =
(Use for fieldname an indexed field).
If postgres is using an sequential scan in stead of an index scan. You have
to vacuum your database. This will REALLY remove deleted data from your indexes.
Hope it will work,
Dave Mertens
System Administrator ISM, Netherlands
the smallest unit. We save every amount in Eurocents. Our programs format
the amount to the proper format (US-format (35,673.56) or EuropeannFormat
(35.673,56). Currency signs are bad things in databases. Most database are
international, so most amounts also!
Sorry for this hard correction.
ions, etc).
I now, i looks bad, but it's really a good thing
Dave Mertens
Unix System Administrator
