think much of it at the time, but now I wonder if it was
indicative of trouble on the way?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
vidence of this error in the archives.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
any functions that provide
introspection of this nature. I ask because it seems like network-to-
network failures are a common enough occurrence that some mechanism
for archive verification is a must-have. I'm just trying to determine
how much of that functionality I'll have to buil
On Apr 26, 2007, at 6:51 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
1. What aspect of postgres' memory usage would create an "out of
memory" condition?
I'm guessing you ran the box out of swap space --- look into what
o
fference between an ERROR and FATAL "out of memory"
message?
3. What would cause postgres to die from a signal 11?
I've also got a core file if that's necessary for further forensics.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
On Apr 25, 2007, at 9:42 AM, Simon Riggs wrote:
On Thu, 2007-04-19 at 15:48 -0500, Thomas F. O'Connell wrote:
"If we take a backup of the standby server's files while it is
following logs shipped from the primary, we will be able to reload
that data and restart the standby
cessfully.
Here's how I envision it playing out in practice:
1. stop standby postgres server
2. [optional] preserve data directory, remove unnecessary WAL files
3. restart standby server
Is that all there is to it?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
tand it, though, pg_standby as distributed in contrib for
8.3 is designed to be backward compatible with 8.2.x.
http://archives.postgresql.org/pgsql-admin/2007-04/msg00069.php
I'm currently having good success in testing.
--
Thomas F. O'Connell
optimizing modern web applications
: fo
.
I still need to test restartable recovery and incrementable backups,
but I'd like to say thanks to Simon and the whole PostgreSQL Global
Development Group for a fine product and a robust community.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engine
On Mar 29, 2:17 pm, [EMAIL PROTECTED] ("Thomas F. O'Connell") wrote:
> I see that Simon has pushed pg_standbyinto contrib for 8.3. Is there
> anything that would make the current version in CVS unsuitable for
use
> in 8.2.x? I've done a cursory inspection of the
state this left the
recovery process, and I'm not helping myself much by reading the
code. Doesn't the non-zero exit from CheckForExternalTrigger mean
that pg_standby will be signaling to the standby server a file-not-
found scenario?
--
Thomas F. O'Connell
optimizing modern
config_manual.h to see whether anything would be unusable or behave
unexpectedly in 8.2.
I'm assuming the correct way to install it would be to take the
pg_standby directory from CVS, add it to an 8.2.x source contrib tree,
and build as if it were a part of contrib in 8.2?
--
Thomas F. O'C
1.x PG: all releases know about 2007 USDSTupdates
>
> 8.2.x PG: all releases know about 2007 USDSTupdates
>
> regards, tom lane
I'm curious. For 7.4.x, does the database require a restart for the
change to take effect? I'm aware of a few production installa
Shouldn't there be an announcement about the buggy 8.2.2 announced
yesterday preceding the availability of new binaries, or is the bug
not considered severe enough to invalidate the 8.2.2 sources that are
currently in distribution?
--
Thomas F. O'Connell
optimizing modern web ap
On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
>
> > but we just built 8.2.2 from source using cc, and now we're seeing
> > this type of error in the logs:
> > ERROR: attribute 3 ha
On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote:
> DETAIL: Table has type character varying, but query expects
> character varying.
In another thread, someone else is reporting this too. I'm
wondering whether something went wrong in the 8.2.2 release.
I
d a Bad Idea?
More important: Has this risked any catastrophic data corruption? If
we just switch to a gcc 8.2.2, will we be fine?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
ters. In fact, I think it will error out.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
---(end of broadcast)---
TIP 4: Have you searc
s a
restart doesn't take effect on reload, then how could a related
failure manifest at all, regardless of when?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
-
work around any incompatibilities). You don't have to rely on
pg_restore.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
---(end of broadcast)---
preceding your inability to get a table listing via psql?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
---(end of broadcast)---
TIP 5: don
On Jan 4, 2007, at 7:03 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
My big question is: Is there anything that happens late in the game
in a pg_dumpall that affects system catalogs or other non-data
internals in any critical ways that woul
any root causes as possible.
The new database is 8.2 (as were all the client utilities used in the
migration), built from source, running on Solaris:
SunOS x41-xl-01.int 5.10 Generic_118855-19 i86pc i386 i86pc
--
Thomas F. O'Connell
optimizing modern web applications
: for search
keep my data on in case of a problem with
the
OS.
Any help would be appreciated.
Shaun
Unless Ubuntu is doing anything funny, you should be able to set
data_directory in postgresql.conf:
http://www.postgresql.org/docs/8.1/static/runtime-config-file-
locations.html
--
Thomas F. O'Co
On Aug 8, 2006, at 1:10 PM, Merlin Moncure wrote:
On 8/8/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
> if have super high write volumes, consider writing your insert
call in
> C. prepare your statement, and use
On Aug 3, 2006, at 1:26 PM, Merlin Moncure wrote:
On 8/2/06, Thomas F. O'Connell <[EMAIL PROTECTED]> wrote:
I'm working on a postgres instance (8.1.2 running on Solaris 10)
where the
data directory (including WAL) is being mounted on tmpfs. Based on
this, and
with knowled
I'm curious to know more about the postgres implementation of subtransactions via SAVEPOINT.If I wanted to set up a multi-statement transaction in which I needed multiple SELECT ... FOR UPDATE + UPDATE blocks, it would seem advantageous to be able to combine the SELECT ... FOR UPDATE clauses with t
postgres
logs.
http://www.postgresql.org/docs/8.1/static/runtime-config-
logging.html#RUNTIME-CONFIG-LOGGING-WHAT
--
Thomas F. O'Connell
Sitening, LLC
http://www.sitening.com/
3004B Poston Avenue
Nashville, TN 37203-1314
615-469-5150 x802
615-469-5151 (fax)
---(e
On Aug 2, 2006, at 4:27 PM, [EMAIL PROTECTED] wrote:You're correct, I cannot use the pg_dump. I get a error message that the pg_dump is aborting because of a version mismatch, then it says to use the i opt. How do I call the pg_dump from the 8.1.4 version?You'll probably need to specify an absolut
to dump it; otherwise, it will fail with a complaint that it couldn't connect to anything on 5432. --Thomas F. O'ConnellSitening, LLChttp://www.sitening.com/3004B Poston AvenueNashville, TN 37203-1314615-469-5150 x802615-469-5151 (fax) On Aug 2, 2006, at 4:10 PM, [EMAIL PROTECTED] wrote:&quo
You'll need to specify the non-default port explicitly in your pg_dump command in order to back up the postmaster running on 55432.E.g., pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql owlBy default, the postgres command-line utilities attempt to connect to 5432 (or $PGPORT or whatever
I'm working on a postgres instance (8.1.2 running on Solaris 10) where the data directory (including WAL) is being mounted on tmpfs. Based on this, and with knowledge that fsync is disabled, I'm operating under the assumption that recoverability is not a precondition for optimized performance. With
le more nervous that it seems
indicative of an abstruse error condition. Any thoughts from the
hackers?
--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (offic
seems like it might
even be a % item?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
-
On Apr 4, 2006, at 4:53 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
As for how this plays out in the real world, a pg_dumpall will start
and run for a few hours. Sometime during that, this function might
get called. When it does, an ACCESS E
On Apr 4, 2006, at 12:53 AM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
I'm dealing with an application that can potentially do ad hoc DDL.
It uses a PG/pgSQL function, and the only DDL statements in the
function are CREATE TABLE and CREATE
application to its knees. This seems to be a result of connections
backing up waiting for the DDL to finish, and the DDL can't finish
until the backup process finishes because of the function's ACCESS
EXCLUSIVE lock conflicting with the database-wide ACCESS SHARE locks
acquired b
t the
results.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
On Apr 1, 2006, at 8:01 AM, Tatsuo Ishii wrote:
A whi
ly and why they are showing up
again.
pgpool itself seems to be working fine after the upgrade, so as long
as the warnings are harmless, it's not a big deal, but I'd like a
clean method of preventing log noise if one exists.
--
Thomas F. O'Connell
Database Architecture and P
On Mar 30, 2006, at 2:03 AM, Aaron Glenn wrote:Anyone care to share the great books, articles, manifestos, notes,leaflets, etc on data modelling they've come across? Ideally I'd liketo find a great college level book on data models, but I haven't comeacross one that even slightly holds "definitive
impact on all postgres clusters running on a server?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151
On Mar 21, 2006, at 11:54 AM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
2006-03-21 10:38:53 CST 1412 :LOG: archive recovery complete
2006-03-21 10:38:53 CST 1412 :LOG: could not truncate directory
"pg_multixact/offsets": apparent wra
m like healthy messages
nonetheless. I don't see much discussion of them in the archives. Are
they cause for concern?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-
force option or something similar
would be reasonable for dropdb because the state of the database in
terms of user activity wouldn't seem to matter a whole lot if the
intent is to drop it.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http:/
On Mar 11, 2006, at 2:44 PM, Matthew T. O'Connor wrote:
Thomas F. O'Connell wrote:
I administer a network where a postgres database on one machine is
nightly dumped to another machine where it is restored (for
verification purposes) once the dump completes. The process is
daemon
requires a superuser_reserved_connections slot.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151
On Dec 28, 2005, at 10:03 PM, Thomas F. O'Connell wrote:
[snip]
If the column alias is being declared in the subselect, the column
alias
is working.
select version();
ve
related to the limit clause of the inner query. Hackers?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
On Nov 30, 2005, at 11:24 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
I guess I'm still somewhat puzzled by the original statement of the
question, then. Why does that particular view of locks occasionally
tie a SELECT to a granted Row Exclu
On Nov 30, 2005, at 10:52 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
For instance, if a long SELECT were running against table_foo and an
UPDATE arrived wanting to update table_foo, I would expect to see in
pg_locks an entry corresponding to th
On Nov 30, 2005, at 9:22 PM, Thomas F. O'Connell wrote:
I'm monitoring locks using this query:
SELECT pgsa.procpid, pgsa.current_query, pgsa.query_start,
pgc.relname, pgl.mode, pgl.granted
FROM pg_catalog.pg_class pgc, pg_locks AS pgl, pg_stat_activity AS
pgsa
WHE
SQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---
On Nov 22, 2005, at 10:56 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
In an old thread <http://archives.postgresql.org/pgsql-admin/2004-01/
msg00271.php>, Tom Lane suggested that it would be "unreasonable" to
use pg_index to recon
.S. Regardless of the wisdom of using pg_index for such purposes,
the OP in the old thread raised what I think is a good question: why
are techniques for accessing int2vector nowhere documented if the
type itself makes its way into very user-visible documentation and
catalogs/views?
-
t can't do in the case of claimnum since it doesn't
exist in the view.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
--
ably also want to declare
variables to serve as targets for the results of your SELECTs.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
't
know enough about the underlying locking requirements of each step of
each SQL command to know when locks might implicitly be acquired.
Even if UPDATE is the only special case, it seems like it'd be worth
mentioning.
--
Thomas F. O'Connell
Database Architecture and P
useful to happen with the
results. I've replaced your SELECTs with PERFORMs to recreate your
function as originally written.
I recommend a closer reading of the chapter on PL/pgSQL:
http://www.postgresql.org/docs/8.0/static/plpgsql.html
--
Thomas F. O'Connell
Co-Founder, Information
ve read, the terms of the
transaction were not disclosed. I guess it's possible that MySQL
didn't have the financial reach to pull off the deal.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening
.
It should work in most of the cases.
regards
suresh
There's actually a make uninstall rule, too.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-
t be because pg_restore is designed
to restore a database rather than a cluster.
I think the only difference between "t" and "c" is that "c" is
compressed by default.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source
On Sep 19, 2005, at 7:10 PM, Bruce Momjian wrote:
Added to TODO:
* Allow WAL traffic to be steamed to another server for stand-by
replication
"steamed" or "streamed"?
:)
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic
to verify that any activity is occurring.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
On Sep 11, 2005, at 4:26 AM
On Sep 5, 2005, at 10:51 PM, Alvaro Herrera wrote:
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
I don't think any such behavior exists in PostgreSQL, and based on a
reading of the behavior in MySQL, I can't imagine it ever existing
considering th
I don't think any such behavior exists in PostgreSQL, and based on a reading of the behavior in MySQL, I can't imagine it ever existing considering the preference of PostgreSQL developers for correct (and sane) behavior. INSERT IGNORE seems like a foot-cannon... --Thomas F. O'ConnellCo-Founder, Inf
You're also free to set sort_mem (7.4.x) or work_mem (8.0.x) on a per
session basis, so you could try experimenting with raising the value
of those settings during sessions in which your query is running.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Stra
Andrus,
You might consider something like materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Whether table caching is a good idea depends completely on the
demands of your application.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sit
them by my own and if yes, for what? With
the LOCK command i can only lock tables, or?
You can use any lock mode specified:
http://www.postgresql.org/docs/8.0/static/sql-lock.html
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
;m not sure why you're getting errors. Is there a reason you did the
schema dump separately from the data dump rather than a monolithic
dump/restore?
Once you get your data import working, you might want to check out
contrib/adddepend, though, since you're coming from a pre-7.3 databa
x27;m still curious to know more about why/whether ROW SHARE is being acquired when a foreign key shouldn't have to be checked. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
for bgwriter? I'm under the impression that this
is mostly an issue with the implementation of temp tables and the
planner, but I'd like confirmation from folks who can read the code
more easily...
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strate
t to know whether continuing to run pg_autovacuum with this
architecture is a bad idea. If so, we can revert to not using temp
tables at all.
Further, why have we only noticed it once when this version of code
(and PostgreSQL) has been running for weeks?
--
Thomas F. O'Connell
Co-Foun
psonding to these. Should
there be some? Or do these qualify as bugs and should they be
submitted to that queue?
Thanks again to all developers and community folk who lent insight
into this error -- diagnosis and recovery (which was, thankfully,
virtually non-existent).
--
Thomas F. O&#
talking about the new integrated version of the code as far as access
to temp tables are concerned?
If contrib/pg_autovacuum, temp tables, and bgwriter don't mix well,
I'll need to rethink our vacuum strategy.
Thanks!
--
Thomas F. O'Connell
Co-Founder, Information Architect
On Jul 14, 2005, at 12:51 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
Unfortunately, this is a system where the interloper is superuser
(and, yes, changing this has been a TODO). But even so, I need help
understanding how one backend could acc
UM, as a result
of the inheritance relationship in the temp tables, is explicitly
attempting to access them?
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 372
ully. Do I still have cause for concern?
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jul 14, 2005, at 7:57 AM, Tom Lane wrote:
"
I'm developing a habit of being the most frequent replier to my own posts, but anyway: I discovered the meaning of 1663, which is the default tablespace oid.But I still need help with diagnosis and treatment... -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Stra
EX DATABASE? (What is a "standalone backend"? A single-user version?) Avoid VACUUMing? pg_dump and reload?The database is currently running. Should I stop it to prevent further damage?-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your
for the noise...
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jul 11, 2005, at 6:04 PM, Tom Lane wrote:
"Thomas F. O'C
ing an example of how to include a variable in the parameter list to SET. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
way, thanks for your insights. I don't think we're really in a
position to support postmaster-per-client hosting, though, at the
moment.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
involving a bit of mucking with system
catalogs and the schema search path?
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jul 11, 2005,
and pg_dump. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Jul 11, 2005, at 11:39 AM, Thomas F. O'Connell wrote:Then we ran into t
e a cluster-wide mechanism for viewing users.Again, I'm wondering whether anyone else in the community has developed any best practices when it comes to PostgreSQL hosting. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www
here any less intrusive ways of doing things? Am I hurting my prospects for upgrade paths? There were a few minor patches made to phpPgAdmin, for instance, to get it to use the new pb_db view. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open
ve much time to hack pg_autovacuum before 8.1 is
released, although if it doesn't become integrated by beta feature
freeze, I might give it a shot.
But I hope if anyone completes the linear improvement, they'll post
to the lists.
--
Thomas F. O'Connell
Co-Founder, Infor
s to be of use in a production environment (where I still
find its behavior to be preferable to a complicated list of manual
vacuums performed in cron).
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
k of a way today in which pg_dump might be able
to use statistics in almost the opposite way of pg_autovacuum, such
that it steered clear of objects in heavy use, but I'm not familiar
enough with the source to know how this might work.
-tfo
--
Thomas F. O'Connell
Co-Founder, I
;t require exclusive locks?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On May 23, 2005, at 3:18 PM, Scott Marlowe wrote:
ch CPU, it doesn't prevent further access.I'm suspicious more of something involving locks than of CPU.Oh, and one other small(ish) detail: the dumping client is using a 7.4.8 installation, whereas the server itself is 7.4.6.-tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sit
d be completely read-only and shouldn't require any exclusive locks.Connections don't really pile up excessively, and load on the machine does not get in the red zone. Is there anything else I should be noticing?-tfo -- Thomas F. O'Connell Co-Founder, Information Architect Siteni
There should be no need to recompile anything. See the entry for
max_connections:
http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-
CONFIG-CONNECTION
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
Any reason not to use pg_dump -s?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 25, 2005, at 10:29 AM, John Browne wrote:
Hel
would
DDL statements be more likely to cause lock acquisition at cross
purposes?
A simple example would help me understand this.
Thanks!
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue
dy, though...
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 12, 2005, at 12:51 PM, Mark Harrison wrote:
Suppose I'm adding
You'll need to post the actual error to the list to have any hope of
receiving good help.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
61
Isn't this also a symptom of inappropriate FSM settings?
Try running a VACUUM VERBOSE and check the FSM settings at the end.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source — Open Your i™
http://www.sitening.com/
110 30th Avenue Nort
From what I have gathered on the performance list, JFS seemed to be the
best overall choice, but I'd say check the archives of
pgsql-performance because so many of your I/O needs depends on what
you're going to be doing with your database.
-tfo
--
Thomas F. O'Connell
Co-Found
le
utility in contrib called pgbench that you could use to do some
testing.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source — Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 2
1 - 100 of 164 matches
Mail list logo
