[ADMIN] postmaster hangs up - no log entry
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. Best Regards, -- Csaba --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.505 / Virus Database: 302 - Release Date: 2003. 07. 30. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] counting rows
[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)--- TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] counting rows
-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 [EMAIL PROTECTED] PGP Key: 0x14964AC8 200308060951 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html iD8DBQE/MQgmvJuQZxSWSsgRAkFDAJwPz5C7OljCg4TYqxvw4/WjLr8TlgCgovtS xQPuL/l+QCPgmwVDeX0yocM= =XtnA -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[ADMIN] Installation problem with libreadline
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 broadcast)--- TIP 8: explain analyze is your friend
