.
* 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
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
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
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
, 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
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
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
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
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
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
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
11 matches
Mail list logo