Re: [SQL] Slow SELECT -> Growing Database

2002-06-27 Thread Marcos Garcia
On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote: > On 24 Jun 2002, Marcos Garcia wrote: > > Hmm, that should only happen if you're doing alot of updates or deletes > I would guess (updates would cause it to slow down as well since it's > similar to a delete and insert u

Re: [SQL] Slow SELECT with distinct, in a TIMESTAMP type column

2002-06-24 Thread Marcos Garcia
) -> Index Scan using send_total_smsdate_idx on send_total (cost=0.00..31053.60 rows=12315 width=8) (actual time=108.59..195145.43 rows=12087 loops=1) Total runtime: 195226.24 msec On Mon, 2002-06-24 at 19:36, Stephan Szabo wrote: > > On 24 Jun 2002, Marcos Garcia wrote: > > &

[SQL] Slow SELECT with distinct, in a TIMESTAMP type column

2002-06-24 Thread Marcos Garcia
Hi, I've a table "send_total" like this: Table "send_total" Column | Type | Modifiers ---+--+--- id