Re: [ADMIN] Error while trying to back up database: out of memroy

2008-09-29 Thread Peter Kovacs
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 kil

Re: [ADMIN] Do we need vacuuming when tables are regularly dropped?

2008-09-29 Thread Peter Kovacs
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,

Re: [ADMIN] Do we need vacuuming when tables are regularly dropped?

2008-09-29 Thread Peter Kovacs
On Mon, Sep 29, 2008 at 2:16 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Peter Kovacs" <[EMAIL PROTECTED]> writes: >> We have a number of automated performance tests (to test our own code) >> involving PostgreSQL. Test cases are supposed to drop and recreate &

Re: [ADMIN] Do we need vacuuming when tables are regularly dropped?

2008-09-29 Thread Peter Kovacs
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

[ADMIN] Do we need vacuuming when tables are regularly dropped?

2008-09-29 Thread Peter Kovacs
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 the

Re: [ADMIN] Readline support in psql -- worked earlier for me

2008-08-21 Thread Peter Kovacs
eybindings. 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]> w

Re: [ADMIN] Readline support in psql -- worked earlier for me

2008-06-19 Thread Peter Kovacs
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 cas

Re: [ADMIN] Readline support in psql -- worked earlier for me

2008-06-19 Thread Peter Kovacs
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: > > M

Re: [ADMIN] Readline support in psql -- worked earlier for me

2008-06-19 Thread Peter Kovacs
...}) = 0 open("/etc/inputrc", O_RDONLY) = 5 -- Should I, perhaps, set something in ~/.psqlrc ? 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"

[ADMIN] Readline support in psql -- worked earlier for me

2008-06-19 Thread Peter Kovacs
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 PROTECTE

Re: [ADMIN] Tuning

2008-03-26 Thread Peter Kovacs
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 dime

Re: [ADMIN] No initdb in Fedora 8

2008-03-12 Thread Peter Kovacs
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

Re: [ADMIN] No initdb in Fedora 8

2008-03-12 Thread Peter Kovacs
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 t

[ADMIN] No initdb in Fedora 8

2008-03-12 Thread Peter Kovacs
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

Re: [ADMIN] How much space do database objects take up in data files

2008-02-15 Thread Peter Kovacs
e name'); You can get the size of tables > > 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

Re: [ADMIN] How much space do database objects take up in data files

2008-02-13 Thread Peter Kovacs
e name'); You can get the size of tables > > 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 da

[ADMIN] How much space do database objects take up in data files

2008-02-13 Thread Peter Kovacs
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

[ADMIN] pid file problem

2007-02-12 Thread Peter Kovacs
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

Re: [ADMIN] 8.0 install via fink on OS X, now what?

2006-05-29 Thread Peter Kovacs
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