Hi,
We have a number of automated performance tests (to test our own code)
involving PostgreSQL. Test cases are supposed to drop and recreate
tables each time they run.
The problem is that some of the tests show a linear performance
degradation overtime. (We have data for three months back in
PS:
PGSQL version is: 8.2.7. (BTW, which catalog view contains the
back-end version number?)
On Mon, Sep 29, 2008 at 11:37 AM, Peter Kovacs
[EMAIL PROTECTED] wrote:
Hi,
We have a number of automated performance tests (to test our own code)
involving PostgreSQL. Test cases are supposed
Thank you!
Peter
On Mon, Sep 29, 2008 at 2:42 PM, Tom Lane [EMAIL PROTECTED] wrote:
Peter Kovacs [EMAIL PROTECTED] writes:
It is not immediately clear from the documentation, but the VACUUM
command also deals with the system catalogs as well, correct?
If it's run without any argument
On Mon, Sep 22, 2008 at 4:43 PM, Tom Lane [EMAIL PROTECTED] wrote:
Vladimir Rusinov [EMAIL PROTECTED] writes:
But now I'm getting following error:
pg_dump: WARNING: terminating connection because of crash of another server
process
As a rule of thumb, you should disable OOM kill on any
. I needed to add TAB complete to get the default bash
behaviour back.
Peter
On Thu, Jun 19, 2008 at 11:05 PM, Peter Kovacs
[EMAIL PROTECTED] wrote:
Thank you, Tom!
Peter
On Thu, Jun 19, 2008 at 8:13 PM, Tom Lane [EMAIL PROTECTED] wrote:
I wrote:
I find this pretty stupid, actually, since
Hi,
It appears as though psql ignored the settings in my ~/.inputrc file:
-
[EMAIL PROTECTED] bin]$ cat ~/.inputrc
set editing-mode vi
set disable-completion on
-
psql persists in emacs mode and completion is not disabled either.
-
[EMAIL
? Or is there something
to set in /etc/inputrc ?
Thanks
Peter
On Thu, Jun 19, 2008 at 5:24 PM, Tom Lane [EMAIL PROTECTED] wrote:
Peter Kovacs [EMAIL PROTECTED] writes:
It appears as though psql ignored the settings in my ~/.inputrc file:
Seems to work for me in 8.3.3. Maybe a permissions problem
bash honors the settings in ~/.inputrc . Completion gets disabled in a
new bash shell.
Thanks
Peter
On Thu, Jun 19, 2008 at 6:13 PM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Peter Kovacs escribió:
It doesn't appear to be interested in my ~/.inputrc file:
Maybe your readline version stopped
Thank you, Tom!
Peter
On Thu, Jun 19, 2008 at 8:13 PM, Tom Lane [EMAIL PROTECTED] wrote:
I wrote:
I find this pretty stupid, actually, since per the manual readline
can fall back to /etc/inputrc all by itself; all the /etc/profile code
is accomplishing is to screw up this corner case. Off
tkprof generates performance characteristics for an arbitrary number
of SQL statements. The output includes measurements for the individual
SQL statements as well as cumulated values for the sequence of SQL
statements being measured. Data is presented in a two dimensional
format with the first
Sorry if this is not the right place to tell about this, or if it is a
known problem.
Thanks,
Peter
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
PS:
I forgot to mention the PgSQL version:
[EMAIL PROTECTED] ~]# yum info postgresql
Installed Packages
Name : postgresql
Arch : i386
Version: 8.2.6
Release: 1.fc8
On Wed, Mar 12, 2008 at 9:48 AM, Peter Kovacs
[EMAIL PROTECTED] wrote:
Sorry if this is not the right place to tell about
I didn't. Yes initdb is in there. (I was not aware of the existence of
that package.)
Thanks
Peter
On Wed, Mar 12, 2008 at 3:47 PM, Tom Lane [EMAIL PROTECTED] wrote:
Peter Kovacs [EMAIL PROTECTED] writes:
PS:
I forgot to mention the PgSQL version:
[EMAIL PROTECTED] ~]# yum info
with SELECT pg_relation_size('table name');
Carol
On Feb 13, 2008, at 1:43 PM, Peter Kovacs wrote:
Hi,
How can I find out how much space is taken up by database objects in data
files?
Give this query a try. It's a variation of one posted on this list some time
ago
Hi,
How can I find out how much space is taken up by database objects in data files?
Thanks
Peter
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
with SELECT pg_relation_size('table name');
Carol
On Feb 13, 2008, at 1:43 PM, Peter Kovacs wrote:
Hi,
How can I find out how much space is taken up by database objects in data
files?
Give this query a try. It's a variation of one posted on this list some time
ago. Unfortunately
Hi,
On system startup PostgreSQL 8.1.4 refuses to start due to the pid
file is left over from previous session on Solaris 10 x86. After
removing the old pid file, PG start up and creates a new pid file:
[EMAIL PROTECTED] /# ls -l /var/opt/postgresql/data/postmaster.pid
-rw--- 1 postgres
Are there any known issues related to compiling for OS X on Intel?
Thanks
Peter
Guido Neitzer wrote:
On 29.05.2006, at 19:56 Uhr, Mitch Pirtle wrote:
Now finally getting comfortable on the new PowerBook, and after weeks
of whining about no OS X packages I discovered the fink binaries,
which
18 matches
Mail list logo