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 ind
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
> +
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
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
> cur
Hi!
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 state. Th
