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.
> Sinc
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?
-Origin
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 6
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
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
>
