On Jan 14, 2009, at 8:47 AM, Kevin Kempter wrote:
Hi all;
Anyone know what system catalogs I need to query to find out # of
disk reads
and # of memory / buffercache reads ?
See blks_hit and blks_read on the pg_stat_database view.
Erik Jones, Database Administrator
Engine Yard
Support, Sca
Carol Walter writes:
> If I need to rerun configure what else do I have to do. Do I have to
> run gmake uninstall? Do I have to run gmake distclean?
distclean is a good idea.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
On Fri, Jan 16, 2009 at 11:32 AM, Carol Walter wrote:
> Hello,
>
> If I need to rerun configure what else do I have to do. Do I have to run
> gmake uninstall? Do I have to run gmake distclean? I've got a running
> version of 8.3.4 (on Solaris 10) but I have to reconfigure so postgres will
> know
On Fri, Jan 16, 2009 at 01:32:37PM -0500, Carol Walter wrote:
> If I need to rerun configure what else do I have to do.
http://www.postgresql.org/docs/8.3/interactive/install-procedure.html
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
h
Hello,
If I need to rerun configure what else do I have to do. Do I have to
run gmake uninstall? Do I have to run gmake distclean? I've got a
running version of 8.3.4 (on Solaris 10) but I have to reconfigure so
postgres will know where the openssl bits are.
Thanks,
Carol
--
Sent v
Just a quick question - why do you use quite old release 8.1 instead of
8.3.5 ?
Post only changes in postgresql.conf and explain analyze of your slow
query.
Oleg
On Fri, 16 Jan 2009, Francesco Andreozzi wrote:
Hi all, i send this mesage because i just made a migration from my old mysql
db on
On Fri, Jan 16, 2009 at 04:18:02PM +0100, Francesco Andreozzi wrote:
> Hi all, i send this mesage because i just made a migration from my old
> mysql db on a more robust postgres server.
> I'm using version 8.1 on a linux debian 4.0
> i have a dual core XEON 2.33GHz and 2Gb of ram ... 2 disk 15k m
Hi all, i send this mesage because i just made a migration from my old
mysql db on a more robust postgres server.
I'm using version 8.1 on a linux debian 4.0
i have a dual core XEON 2.33GHz and 2Gb of ram ... 2 disk 15k mirrored
database works good but the performance are horrible! i hope is my
