Gerhard Hintermayer wrote:
> Is there a way to make postgres use the index on the timestamp
> column ? The timing is from a test table, production tables have a
> lot more rows.
It's a mistake to assume that the plan you get on a small table will
resemble the plan you will get on a big table.
I'm trying to make use of indices for following table
auftrag_l1
a_nr | integer
ts | timestamp without time zone
and 10-15 other columns
I do have indices
"idx_auftrag_l1_anr" btree (a_nr)
"idx_auftrag_l1_ts" btree (ts)
when I query the table by
explain analyze select * fr
Please keep the list copied. I'm moving this to the pgsql-admin
list (with a blind copy to -bugs), since there is really no hint of
a PostgreSQL bug here, except possibly in terms of how we document
this issue.
Suprabhat Mohapatra wrote:
> Should I send you the sample code that we are using
Hello,
I have installed postgresql 9 on fedora 14 having python 2.7. Now
created plpythonu language in my database and created a simple
function to calculate sum of two variables.
while importing math libbrary and executing the function i got the error
PL/Python: ImportError: No module named cmath
