[ADMIN] possible memory leak in Server Status window

2011-02-07 Thread Julius Tuskenis
Hello, all! Last Friday I've installed pgAdmin 1.12.2 (build Dec 13, 2010) into one of our clients servers (Windows server 2003 SE SP2). Postgresql 8.3.3 runs on it. As we were looking how to improve performance we were using Server Status tool (great tool, especially with recent changes - th

Re: [ADMIN] possible memory leak in Server Status window

2011-02-07 Thread Guillaume Lelarge
Le 07/02/2011 09:31, Julius Tuskenis a écrit : > Hello, all! > > Last Friday I've installed pgAdmin 1.12.2 (build Dec 13, 2010) into one > of our clients servers (Windows server 2003 SE SP2). Postgresql 8.3.3 > runs on it. As we were looking how to improve performance we were using > Server Status

Re: [ADMIN] How to

2011-02-07 Thread Guy Deleeuw
Hello Kevin, > > You should probably look at reqorking the v_stock view to use joins > instead of subqueries -- they often optimize much better. This is the problem effectively. For creating this view I use a query tools that generate the code, not a good idea. I update and work now :-) Best rega

Re: [ADMIN] possible memory leak in Server Status window

2011-02-07 Thread Julius Tuskenis
2011.02.07 11:52, Guillaume Lelarge rašė: Did you lower each report? because each individual report has its own timer. I'm sorry, I have only one report (Server status window). When you say "lower" do you mean "minimize" ? No, I have left it on screen. Or do you mean refresh interval? As I ha

Re: [ADMIN] possible memory leak in Server Status window

2011-02-07 Thread Julius Tuskenis
2011.02.07 13:14, Julius Tuskenis rašė: 2011.02.07 11:52, Guillaume Lelarge rašė: Did you lower each report? because each individual report has its own timer. I'm sorry, I have only one report (Server status window). When you say "lower" do you mean "minimize" ? No, I have left it on screen.

Re: [ADMIN] possible memory leak in Server Status window

2011-02-07 Thread Guillaume Lelarge
Le 07/02/2011 12:14, Julius Tuskenis a écrit : > 2011.02.07 11:52, Guillaume Lelarge rašė: >> Did you lower each report? because each individual report has its own >> timer. >> > I'm sorry, I have only one report (Server status window). When you say > "lower" do you mean "minimize" ? No, I have lef

[ADMIN] pg_top and skytools on windows

2011-02-07 Thread Protasov Vladimir
Hi, guys! I'm using postgres 9.0 both on windows and linux and windows-servers is the problem. I need pg_top and londiste on win-servers, but i cannot build it. Does anyone have any experience or ideas on building postgres tools on windows? -- Regards, Vladimir Protasov. -- Sent via pgsql-

Re: [ADMIN] How to

2011-02-07 Thread Nicolas Thauvin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/02/2011 17:30, Kevin Grittner wrote: > Guy Deleeuw wrote: > > My hardware : lapto hp envy I7 processor with a ssd disk > >> Memory : >> totalused free shared buffers cached >> Mem: 8129356 2866516

Re: [ADMIN] How to

2011-02-07 Thread Kevin Grittner
Nicolas Thauvin wrote: > On 06/02/2011 17:30, Kevin Grittner wrote: >> Guy Deleeuw wrote: >> >> My hardware : lapto hp envy I7 processor with a ssd disk >> >>> Memory : >>> totalused free shared buffers cached >>>8129356 2866516 5262840 0 387172 9

[ADMIN] PANIC: heap_update_redo: invalid lp

2011-02-07 Thread Chavdar Kopoev
Hello, My production database cannot start: * Starting PostgreSQL 8.4 database server * The PostgreSQL server failed to start. Please check the log output. Log file as follow: 2011-02-07 19:39:52 EET 891LOG: database system was interrupted while in recovery at 2011-02-07 19:33:25 EET 2011-0