On Thu, 11 Dec 2003 04:13:28 +
Alfranio Correia Junior <[EMAIL PROTECTED]> wrote:
> r b w swpd free buff cache si sobibo incs
> us sy id
> 2 29 1 106716 9576 7000 409876 32 154 5888 1262 616 1575
> 8 12 80
On linux I've found as soon as it has t
Alfranio Correia Junior <[EMAIL PROTECTED]> writes:
> I am facing a problem trying to put 500 concurrent users accessing
> a postgresql instance.
I think you're going to need to buy more RAM. 1Gb of RAM means there
is a maximum of 2Mb available per Postgres process before you start
to go into swa
Hi list,
I need to know if there is anything like hints of Oracle in
Postgres..otherwise..I wish to find a way to force a query plan to use the
indexes or tell the optimizer things like "optimize based in statistics", "I
want to define the order of the a join" , "optimize based on a execution
hello
maybe
http://www.gtsm.com/oscon2003/toc.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
bye
Pavel
On Thu, 11 Dec 2003, sandra ruiz wrote:
> Hi list,
>
> I need to know if there is anything like hints of Oracle in
> Postgres..otherwise..I wish to find a way to force a
show
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Quoth [EMAIL PROTECTED] ("sandra ruiz"):
> I need to know if there is anything like hints of Oracle in
> Postgres..otherwise..I wish to find a way to force a query plan to use
> the indexes or tell the optimizer things like "optimize based in
> statistics", "I want to define the order of the a join
Hi everyone,
I want to pick your brains for hardware suggestions about a
Linux-based PostgreSQL 7.4 server. It will be a dedicated DB server
backing our web sites and hit by application servers (which do
connection pooling). I've hopefully provided all relevant
information below. Any though
On Thu, Dec 11, 2003 at 11:00:19 -0500,
sandra ruiz <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> I need to know if there is anything like hints of Oracle in
> Postgres..otherwise..I wish to find a way to force a query plan to use the
> indexes or tell the optimizer things like "optimize based in
Jeff Bohmer wrote:
We're willing to shell out extra bucks to get something that will
undoubtedly handle the projected peak load in 12 months with excellent
performance. But we're not familiar with PG's performance on Linux and
don't like to waste money.
Properly tuned, PG on Linux runs really n
Properly tuned, PG on Linux runs really nice. A few people have
mentioned the VM swapping algorithm on Linux is semi-dumb. I get
around that problem by having a ton of memory and almost no swap.
I think we want your approach: enough RAM to avoid swapping altogether.
With 4GB of RAM, you're al
Just one more piece of advice, you might want to look into a good battery
backed cache hardware RAID controller. They work quite well for heavily
updated databases. The more drives you throw at the RAID array the faster
it will be.
---(end of broadcast)--
Jeff Bohmer wrote:
It seems I don't fully understand the bigmem situation. I've searched
the archives, googled, checked RedHat's docs, etc. But I'm getting
conflicting, incomplete and/or out of date information. Does anyone
have pointers to bigmem info or configuration for the 2.4 kernel?
Big
Hi,
I've got very slow insert performance on some
table which has trigger based on complex PL/pgSQL function.
Apparently insert is slow due some slow sql inside that function,
since CPU load is very high and disk usage is low during insert.
I run Red Hat 9
Anthlon 2.6
1GB ram
Fast IDE Disk
Setti
Thanks for the advices,
The performance is a bit better now. Unfortunately, the machine does not
allow
to put more than 200 - ~250 users without noticing swap hell.
I have to face the fact that I don't have enough memory
I used the following configuration:
effective_cache_size = 65000
share
Jeff Bohmer wrote:
Well if this is the case, you probably should get an Opteron server
*now* and just run 32-bit Linux on it until you're sure about the
software. No point in buying a Xeon and then throwing the machine away
in a year when you decide you need 64-bit for more speed.
That's a goo
Mark Kirkwood wrote:
> This is a well-worn thread title - apologies, but these results seemed
> interesting, and hopefully useful in the quest to get better performance
> on Solaris:
>
> I was curious to see if the rather uninspiring pgbench performance
> obtained from a Sun 280R (see General:
16 matches
Mail list logo
