takes a while
to retrieve the request results before submitting a subsequent query,
that can result in problems?
Without index, table size and sample distribution information (or
explain verbose output), it is difficult to say if any one query could
be made to execute faster.
Marc Mitchell
Enterp
Try "pg_dumpall -g".
See http://www.postgresql.org/docs/7.4/interactive/app-pg-dumpall.html
Good luck.
Marc Mitchell - Transportation Practice Director
Enterprise Information Solutions
Downers Grove, IL 60515
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mai
This is follow-up to a problem first reported on 3/1/04. The problem
has continued to occur intermittently and recently we experienced the
first occurrence where the first column of a table was the column where
the corrupted and thus we could not recover it.
Google groups searching have found nume
future point in time.
Any ideas on what's causing this?
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe c
t; but has yet to really begin issuing any statements and take
locks from transactions that are idle "mid-transaction". The latter of
which spells death for a multi-user, OLTP application.
I'll be curious to hear others experience with this.
Marc Mitchell
Enterprise Information S
ncy? This is a development
database so the main things we need are the schemas which were not
changing at time of the crash. The data can be recovered from System
Test scripts. We're looking to do something quicker than a recovery
from a backup.
Any input would be appreciated.
Marc Mitchell
essage appear in the
postmaster log?
Marc
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 1:45 PM
Subject: Re: [ADMIN] Query performanc iss
tables, Explain
would seem to indicate things are still good but actual query time is
really bad. Any help would be much appreciated.
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
[EMAIL PROTECTED]
---(end of br
ill be looking for info that something within a later
release will makes things better.
If it is the latter, I need to continue my learning journey into the
optimizer, Analyze and statistics.
Can someone shed light as to which path I should be following?
Marc Mitchell - Senior Application Ar
statistics
differences between your development and production databases, you are
experiencing the election of a different and less optimum query plan on one
machine vs. the other. An "explain" would quickly confirm this.
Hope this helps.
Marc Mitchell - Senior Application Architect
En
hange fields in another table based on the values
of the row inserted, then the rule should have access to NEW. attributes
for the columns and their inserted values and there is no need for you to
go out searching (SELECTing) for them.
Hope this helps,
Marc Mitchell - Senior Application Arch
.
Hope this helps.
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
[EMAIL PROTECTED]
- Original Message -
From: "Gary DeSorbo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 11:24
a matter of the types
of slings and arrows your dealing with and just how outrageous your
fortune.
Hope this helps,
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
[EMAIL PROTECTED]
- Original Message -
From: "working4a
for 15 straight days prior to encountering this and
this is the first occurrence in 3 months of otherwise trouble-free up-time.
Any help in responding to this would be appreciated and we're open to
helping further diagnose if the cause is still undetermined.
Thanks,
Marc Mitchell - Senior Appli
is not be a defect in pg_dump?
For us, the solution was to drop all triggers, functions and then the
language itself via cmdline droplang followed by a cmdline createlang.
With this done, we could add back our functions and triggers.
Marc Mitchell
Enterprise Information Solutions, Inc.
[EM
g. However, I've yet to find a
reference specifically talking about LIKE and query plans. There is no
reference in "4.6.1. Pattern Matching with LIKE" .
I'd like to know if indexes can be used and I've go something else setup
wrong or if indexes and LIKEs don't
ning to an
outside source even if that meaning is that it is simply their own unique
identifier.
We've been faced with this question many a time. We almost always chose an
int PK and more often than not when we've strayed from this course, it's
come back to haunt us.
Hope this i
2, plc.loc_uid,
plc.nd_zipcode, p
Is there something here I'm missing.
Marc Mitchell
Enterprise Information Solutions, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
pgsqlPostgres automatically creates a unique index to assure data integrity
(see CREATE INDEX statement).
The online docs at
http://www.postgresql.org/idocs/index.php?sql-createtable.html state the
following:
" Postgres automatically creates a unique index to assure data integrity
(see CREATE IN
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 10:51 PM
Subject: Re: [ADMIN] INSERT performace.
> Marc Mitchell wrote:
> > We
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Marc Mitchell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 11:06 PM
Subject: Re: [ADMIN] INSERT performace.
> "Marc Mitchell" <[EMAIL PRO
We have a fresh database and have begun to observe performance degradation
for INSERTs as a table went from empty to 100,000-ish rows. Initial
INSERTs were sub second while after 30k rows, they were 1-3 seconds.
Note that we have done NO performance tuning yet nor are there any indexes
on the ta
We have existing database where several tables have GRANT ALL TO PUBLIC.
However, when new users are added, they seem to get privilege problem until
another GRANT ALL TO PUBLIC is issued. If this is truly the case (and
we're not crazy) then each time a new user is added, new GRANTs will have
to b
23 matches
Mail list logo
