Tambet,
In one of our applications we have a database function, which
recalculates COGS (cost of good sold) for certain period. This involves
deleting bunch of rows from one table, inserting them again in correct
order and updating them one-by-one (sometimes one row twice) to reflect
current
Hello,
My version of Postgresql is 7.4.3.
I have a simple table with 2 indexes:
Table public.tst
Column | Type | Modifiers
+-+-
tst_id | bigint
On Sun, 13 Mar 2005 04:40 pm, Tom Pfeifer wrote:
Hello,
My version of Postgresql is 7.4.3.
I have a simple table with 2 indexes:
Table public.tst
Column | Type | Modifiers
Russell Smith [EMAIL PROTECTED] writes:
On Sun, 13 Mar 2005 04:40 pm, Tom Pfeifer wrote:
I get really slow repoonse times when using the following select statement
(About 20 seconds).
maach=# explain select * from tst where tst_id = 639246;
Before 8.0, bigint would not use an index unless