possibility of overlapping rows.
But, I removed date_part function and it use index now. It's too slow, so
I move all needed data into graphs_5m table and it works fine now, previous
time for graphs drawing was ~30-60seconds, today it's ~3-5 seconds. Thanx.
Best regards,
Robert
--
_
|
s. Any idea how to make it faster? I think,
that now it's ready to HW upgrade for faster result ...
Best regards,
Robert
--
_
|-| __ Robert Vojta -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" `o
PGP signature
---(end of broadcast
h
documentation again, thank you very much.
Best regards,
Robert
--
_
|-| __ Robert Vojta -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" `o
PGP signature
---(end of broadcast)---
TIP 2: you can get off all
try your suggestions ...
Best regards,
Robert
--
_
|-| __ Robert Vojta -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" `o
PGP signature
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
on 700MHz, 384MB RAM, SCSI disk. May I upgrade PostgreSQL? May I
upgrade RAM, CPU? I don't know what to do now and any help will be very
appreciated.
Thank you very much,
king regards,
Robert Vojta
--
_
|-| __ Robert Vojta -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" `o
PGP signature
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]