[ADMIN] postmaster hangs up - no log entry

2003-08-08 Thread Együd Csaba
Hi All, could anybody suggest me something in connection with the following problem? The posmaster process (7.3.2 on an RH7.1 box) hangs up during some operation. There is no log entry which could indicate the reason of the error. Just stops working. Where should I start it? Thank you in advance.

Re: [ADMIN] counting rows

2003-08-08 Thread Tom Lane
[EMAIL PROTECTED] writes: > so, i am wondering if analyze also does a table scan, It does not --- it does a statistical sampling, and it's quite possible that the estimate will be badly off. regards, tom lane ---(end of broadcast)--

Re: [ADMIN] counting rows

2003-08-08 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > i need to get a row count on a large table. it appears that > select count(*) from ; > always does a table scan, whether i have an index or not, and that is too > slow. http://www.gtsm.com/oscon2003/findrows.html - -- Greg Sabino Mullane [EM

[ADMIN] Installation problem with libreadline

2003-08-08 Thread pw
Hello, I have seen a number of links via google describing build problems (./configure) with postgres and libreadline.so . How do I go about resolving the undefined ncurses references in libreadline? I have Mandrake Linux. Thanks for the help Peter ---(end of broadcas