On Wed, April 1, 2015 9:25 am, FarjadFarid(ChkNet) [via PostgreSQL] wrote: >
> > It sounds like your system had crashed several times. > > > My suggestion would be first ensure that your tables and indexes are not > corrupted. > > Second suggestion is to ensure your index is tightly represents the data > you are accessing. The tighter it is the faster the response time. The > less memory and CPU usage. > > Of course these are basic for any good DB but these essential before > moving to more complex issues. > > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Bill Moran > Sent: 01 April 2015 13:48 > To: TonyS > Cc: [email protected] > Subject: Re: [GENERAL] Would like to know how analyze works technically > > > On Wed, 1 Apr 2015 04:33:07 -0700 (MST) > TonyS <[email protected]> wrote: > > >> On Wed, April 1, 2015 12:18 am, Tom Lane-2 [via PostgreSQL] wrote: >> >>> >>> TonyS <[email protected]> writes: >>> >>> >>>> Running "analyze verbose;" and watching top, the system starts out >>>> using no swap data and about 4GB of cached memory and about 1GB of >>>> used memory. As it runs, the amount of used RAM climbs, and >>>> eventually the used swap memory increases to 100% and after being at >>>> that level for a couple of minutes, the analyze function crashes and >>>> indicates "server closed the connection unexpectedly." >>> Thanks for the suggestion. What command/tool do you use to check a PostgreSQL database for corruption? -- View this message in context: http://postgresql.nabble.com/Would-like-to-know-how-analyze-works-technically-tp5844197p5844259.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
