us too.
Please examine the values in my messages in past 2
days, you'll see what i mean.
I am sure default values are erronous.
Regards
Ismail Kizir
Thanks Josh,
I'll subscribe to that group.
Regards
Ismail Kizir
- Original Message -
From: "Josh Berkus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Ismail Kizir" <[EMAIL PROTECTED]>
Sent: Tuesday, May 25, 2004 8:34 PM
Subject
t optimize for that range.
Finally, i've set seq_scan off and, it works now.
But i think, there must be a way to handle those settings automatically for
cpu, ram and hdd settings(is it a sweet dream??)
Thanks
Ismail Kizir
- Original Message -
From: "Gaetano Mendola" <[
SCSI (10ms. access time i think)
3x128 mb. SDRAM
Regards
Ismail Kizir
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Ismail Kizir" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 24, 2004 11:52 PM
Subject: Re: [HACKERS] Opti
to compute this.
> SELECT COUNT(*) AS c FROM articletbl WHERE
> mydate = '2004-04-24';
850 records, it takes only 40 ms. to compute this.
It is evident that there is a problem here! Am I wrong??
Regards
Ismail Kizir
---(end of broadcast)
;2004-05-24' ))
QUERY PLAN
Aggregate (cost=20279.72..20279.72 rows=1 width=4)
-> Index Scan using ind_articletbltrh on articletbl (cost=0.00..20279.40
rows=127 width=4)
Index Cond: ((tarih >= '2004-05-10'::date) AND (tarih <
'2004-05-24'::date))
-10-25;184
2002-10-24;205
2002-10-23;187
2002-10-22;194
2002-10-21;202
Ismail Kizir
- Original Message -
From: "Hans-Jürgen Schönig" <[EMAIL PROTECTED]>
To: "Ismail Kizir" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 24, 2004 8:17 P
ï
Hi
everybody,1 EXPLAIN SELECT COUNT(*) AS c FROM articletbl
WHERE ((mydate BETWEEN '2004-04-24' AND
'2004-05-24' ))2 EXPLAIN SELECT COUNT(*) AS c FROM articletbl
WHERE ((mydate = '2004-04-24'))(I
ran VACUUM ANALYZE before running those)mydate is an indexed date
column.
- Original Message -
From: "Ismail Kizir" <[EMAIL PROTECTED]>
To: "Tom Lane" <[EMAIL PROTECTED]>
Sent: Friday, May 07, 2004 2:22 AM
Subject: Re: [HACKERS] Fixing the Turkish problem
> Tom,
>
> Thank you very much for turkish locale fix.
>
