Re: [GENERAL] vacuum and 24/7 uptime

2001-07-11 Thread Philip Molter
. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?

2001-07-10 Thread Philip Molter
and not worry about it. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [GENERAL] HUPing a database

2001-07-06 Thread Philip Molter
On Fri, Jul 06, 2001 at 06:15:47PM +0200, Peter Eisentraut wrote: : Philip Molter writes: : : I'm doing logging of PG information, and I'd like to rotate the logs. : What's the proper way to HUP the server once the logs have been : rotated? : : There isn't one. You're better off piping

Re: [GENERAL] Changing optimizations

2001-07-05 Thread Philip Molter
plans, just to rule : that out. My brain hurts when I do that (literally thousands of lines of output). Thanks for the help, Philip * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6

[GENERAL] Determining scan types

2001-07-03 Thread Philip Molter
, but the just values, not the number of rows nor the indexing of the tables. It's baffling. All tables being joined (10) are being explicitly joined using INNER JOIN or LEFT JOIN in an order that should (at least it was) making optimal use of the indexing. * Philip Molter * DataFoundry.net * http

Re: [GENERAL] Determining scan types

2001-07-03 Thread Philip Molter
On Tue, Jul 03, 2001 at 10:42:37AM -0400, Sam Tregar wrote: : On Tue, 3 Jul 2001, Philip Molter wrote: : : What causes this and how can I fix it? : : Have you tried a VACUUM ANALYZE? For some reason Postgres isn't able to : use its indexes fully unless you VACUUM ANALYZE often. : : I

Re: [GENERAL] Determining scan types

2001-07-03 Thread Philip Molter
joining methods where it would normally use sequential scans (not that I'm complaining too much; CPU performance has more than doubled since taking out sequential scans). * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Weird error

2001-06-27 Thread Philip Molter
On Wed, Jun 27, 2001 at 11:30:54AM -0400, Tom Lane wrote: : Philip Molter [EMAIL PROTECTED] writes: : I am using 7.1.2. : : Don't suppose you want to dig in there with a debugger when it happens? : You must be seeing some hard-to-replicate problem in VACUUM's : tuple-chain-moving logic

Re: [GENERAL] Re: Red Hat to support PostgreSQL

2001-06-27 Thread Philip Molter
sure that many people's attitudes about RH are the same way. Older versions of RedHat just felt really bloated and slow. RH7.1 feels much tighter, but if I had been turned off by older versions, I never would've tried it. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL

Re: [GENERAL] Re: Red Hat to support PostgreSQL

2001-06-27 Thread Philip Molter
know what causes that, and better yet, anyone know how to fix it? We see similar behavior under Solaris. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[GENERAL] Adding a NOT NULL column?

2001-06-26 Thread Philip Molter
do that like: ALTER TABLE ADD c NOT NULL ALTER TABLE ADD CONSTRAINT c NOT NULL each time it fails on the 'NOT'. How do I add that constraint? * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] ---(end of broadcast