Re: [ADMIN] PLEASE GOD HELP US!

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 Enterprise Information Solutions, Inc

Re: [ADMIN] How to export users?

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] [mailto:[EMAIL

Re: [ADMIN] Row data corruption under 7.3.5

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

[ADMIN] Query performanc issue - too many table?

would be much appreciated. Marc Mitchell - Senior Application Architect Enterprise Information Solutions, Inc. Downers Grove, IL 60515 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [ADMIN] Query performanc issue - too many table?

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 issue - too many table? Marc Mitchell [EMAIL PROTECTED] writes: I am

[ADMIN] IN subselects and index / seq_scan question....

capabilibilities and will 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

Re: [ADMIN] Weird processes

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 Enterprise Information Solutions

Re: [ADMIN] DB Performance

. 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 AM Subject: [ADMIN] DB

Re: [ADMIN] To Blob or Not to Blob? THAT is the question.

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: working4aliving [EMAIL PROTECTED] To: [EMAIL

Re: [ADMIN] How do I restore data changes made after the backup?

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 Application Architect Enterprise Information Solutions, Inc. Downers Grove, IL 60515 [EMAIL PROTECTED

[ADMIN] LIKE operator and indexes

. 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 mix. Marc Mitchell - Senior Application Architect Enterprise Information Solutions, Inc. [EMAIL PROTECTED

Re: [ADMIN] string PK vs. interger PK

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 is helpful. Marc Mitchell

[ADMIN] pg_dump and views

. Marc Mitchell Enterprise Information Solutions, Inc. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] PRIMARY KEY Indexes.

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

[ADMIN] INSERT performace.

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

Re: [ADMIN] INSERT performace.

- 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 have a fresh database and have begun to observe performance

[ADMIN] Grant all to Public adding users

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