Re: [GENERAL] vacuum and 24/7 uptime

2001-07-11 Thread Philip Molter
be unnecessary. * 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
'd set everything high 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 o

Re: [GENERAL] Changing optimizations

2001-07-05 Thread Philip Molter
n. It would be good to look at EXPLAIN : VERBOSE output not just EXPLAIN output for the two 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

Re: [GENERAL] Determining scan types

2001-07-03 Thread Philip Molter
now, it's using less efficient 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]

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

[GENERAL] Determining scan types

2001-07-03 Thread Philip Molter
ve changed, 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 * DataFou

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

2001-06-27 Thread Philip Molter
o 13%). Anyone 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

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

2001-06-27 Thread Philip Molter
Linux box, things worked much better. Go figure. I'm 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. *

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

[GENERAL] Adding a NOT NULL column?

2001-06-26 Thread Philip Molter
would 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] ---(e