[GENERAL] question about memory usage

2014-07-22 Thread klo uo
Hi, I run Windows and I started using 64 bit PostgreSQL 9.3 a month ago. I have several PostGIS databases on localhost, with these statistics: === Xact XactRolled Blocks Blocks TuplesTuples S

Re: [GENERAL] question about memory usage

2014-07-23 Thread klo uo
Bill, thanks for your reply. "shared_buffers" is set to "128MB". Now that you mention config file, the only thing I did change there, and was suggested to me while I made some on my databases was "max_locks_per_transaction = 5" (which has default value 1). After resetting "max_locks_per_

Re: [GENERAL] question about memory usage

2014-07-23 Thread klo uo
:10 PM, Tomas Vondra wrote: > On 23 Červenec 2014, 15:56, klo uo wrote: > > Bill, thanks for your reply. > > > > "shared_buffers" is set to "128MB". > > > > Now that you mention config file, the only thing I did change

[GENERAL] Calltips in pgAdmin SQL Editor

2014-07-26 Thread klo uo
Hi, I believe SQL Editor in pgAdmin wx GUI is Scintilla. Scintilla supports calltips (as in SciTE with *.api files). If above is true, is there a way to make SQL Editor support calltips on user defined commands?

Re: [GENERAL] Calltips in pgAdmin SQL Editor

2014-07-27 Thread klo uo
ation about parameters and return values Apologies for posting in wrong list, would be great if Administrator could move the message thread to appropriate group. Thanks, Klo On Sun, Jul 27, 2014 at 1:43 PM, Guillaume Lelarge wrote: > Hi, > > 2014-07-27 8:55 GMT+02:00 klo uo : > >

Re: [GENERAL] Calltips in pgAdmin SQL Editor

2014-07-27 Thread klo uo
OK, replica here: http://www.postgresql.org/message-id/caa-8ld8rntybiqwoz1rh69ugj0nbp30cgj1vv2_t6kly7me...@mail.gmail.com Thanks On Sun, Jul 27, 2014 at 2:22 PM, Guillaume Lelarge wrote: > 2014-07-27 14:13 GMT+02:00 klo uo : > > >> >> Apologies for posting in wrong li

[GENERAL] How to restore backup database

2014-09-08 Thread klo uo
Hi, I use PostrgrSQL 9.3 for couple of months now, on Windows. I installed new Window OS, and before installing, I made tar backups of my PostgreSQL databases. Now I want to restore these on my new OS, but I can't find such option in pgAdmin. In documentation (http://www.postgresql.org/docs/9.3/

Re: [GENERAL] How to restore backup database

2014-09-08 Thread klo uo
guess I was expecting similar behavior. Cheers On Mon, Sep 8, 2014 at 6:47 PM, Adrian Klaver wrote: > On 09/08/2014 09:04 AM, klo uo wrote: > >> Hi, >> >> I use PostrgrSQL 9.3 for couple of months now, on Windows. >> I installed new Window OS, and before installin

Re: [GENERAL] How to restore backup database

2014-09-08 Thread klo uo
On Mon, Sep 8, 2014 at 8:10 PM, Adrian Klaver wrote: > > You do not have to create a database in Postgres either. There are some > system databases already created for you, template0(read only best left > alone), template1 and postgres. You can connect to one of these(best > practices, use postgre