On Wed, 11 Apr 2007, Jason Lustig wrote:
Hello all,
My website has been having issues with our new Linux/PostgreSQL server being
somewhat slow. I have done tests using Apache Benchmark and for pages that do
not connect to Postgres, the speeds are much faster (334 requests/second v.
1-2 reque
Jason Lustig skrev:
and work_mem to 8096. What would cause the computer to only use such a
small percentage of the CPU, with more than half of it waiting on I/O
requests?
Do your webpages write things to the database on each connect?
Maybe it do a bunch of writes each individually commited? F
Steve <[EMAIL PROTECTED]> writes:
> - What is temp_buffers used for exactly?
Temporary tables. Pages of temp tables belonging to your own backend
don't ever get loaded into the main shared-buffers arena, they are read
into backend-local memory. temp_buffers is the max amount (per backend)
of loc
Hello all,
My website has been having issues with our new Linux/PostgreSQL
server being somewhat slow. I have done tests using Apache Benchmark
and for pages that do not connect to Postgres, the speeds are much
faster (334 requests/second v. 1-2 requests/second), so it seems that
Postgres
Hey there;
I'm trying to tune the memory usage of a new machine that has a -lot- of
memory in it (32 gigs). We're upgrading from a machine that had 16 gigs
of RAM and using a database that's around 130-some gigs on disc. Our
largest tables have in the order of close to 10 million rows.
Pro
On Monday 09 April 2007 05:09:53 s d wrote:
> Hi,
> I am trying to figure out how to debug a performance problem / use psql
> explain. The table in question is:
> # \d word_association;
>Table "public.word_association"
> Column | Type | Modifiers
> +--
Thanks...worked perfectly!
Mike
On 4/11/07, Adam Rich <[EMAIL PROTECTED]> wrote:
Here's what I do...
1) Install postgresql-libs from the RHEL source
2) Install compat-postgresql-libs from postgresql.org (install, not
upgrade, use rpm -hiv) use force if necessary
3) Install postgresq-libs fr
Hi,
On Wed, 2007-04-11 at 13:25 -0400, Michael Dengler wrote:
> Thanks for the info. One more thingI am in rpm hell. When I try
> to
> # rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
> I get:
> error: Failed dependencies:
> libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
Here's what I do...
1) Install postgresql-libs from the RHEL source
2) Install compat-postgresql-libs from postgresql.org (install, not
upgrade, use rpm -hiv) use force if necessary
3) Install postgresq-libs from postgresql.org (again, install, not
upgrade, use rpm-hiv) use force if necessary
Hi,
Thanks for the info. One more thingI am in rpm hell. When I try to
# rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm
I get:
error: Failed dependencies:
libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
libpq.so.3 is needed by (installed)
postgresql-python-7.4.13-2.RH
10 matches
Mail list logo
