Mr. Tom Lane
--- Tom Lane [EMAIL PROTECTED] wrote:
Eduardo Almeida [EMAIL PROTECTED] writes:
I need some help in a TPCH 100GB benchmark.
Here I put the query #19, the explain and the
top
for it.
IIRC, this is one of the cases that inspired the
work that's been done
on the query
Hello,
(note best viewed in fixed-width font)
I'm still trying to find where my performance bottle neck is...
I have 4G ram, PG 7.3.4
shared_buffers = 75000
effective_cache_size = 75000
Run a query I've been having trouble with and watch the output of vmstat
(linux):
$ vmstat 1
procs
All,
Does PG store when a table was last analyzed?
Thanks,
__
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
---(end of broadcast)---
TIP
Use the text_pattern_ops operator when creating the index, see:
http://www.postgresql.org/docs/7.4/static/indexes-opclass.html
Michael Ryan S. Puncia wrote:
Sorry .. I am a newbie and I don't know :(
How can I know that I am in C locale ?
How can I change my database to use C locale?
After reading the replies to this, it is clear that this is a
Lintel-centric question, but I will throw in my experience.
I am curious if there are any real life production
quad processor setups running postgresql out there.
Yes. We are running a 24/7 operation on a quad CPU Sun V880.
Since