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
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
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 build myself...
--
Thomas F. O'Connell
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
other
processes got started as a result of adding
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's recovery process
. [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
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
: for search engines, for usability, and for performance :
http
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 engines, for usability
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 code, but I'll admit
that I haven't
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 web applications
: for search
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'Connell
optimizing modern
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 installations
where the OS changed, but postgres time functions didn't take hold.
--
Thomas F. O'Connell
optimizing
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
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.
Is this the other
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 has wrong type
DETAIL: Table has type character varying
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 applications
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 searched our list archives
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
---(end of broadcast
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 would make an interrupted
pg_dumpall
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't forget
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)---
TIP 5: don't
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 engines, for usability
to 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'Connell
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 knowledge that fsync
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 the parameterized
version
the 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)
---(end
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
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.
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
, 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:"Thomas F. O'Connell" [EMAIL
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
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 (office)
615-469-5151 (fax
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)
---(end of broadcast
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 INDEX statements. But I'm
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 EXCLUSIVE lock is held against
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 while back, I
. 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 by the backup process.
--
Thomas F
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
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 Programming
Co-Founder
Sitening
an
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 (fax
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-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax
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 wraparound
2006-03-21 10:38:53 CST 1412
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://www.sitening.com/
3004 B
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 (fax
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
roughly
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)
---(end of broadcast
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();
version
-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)
---(end
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
WHERE pgl.pid
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 the SELECT with granted
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 Exclusive lock?
You sure it's
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?
--
Thomas F. O'Connell
Database
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 reconstruct (expressional) indexes (in 7.4
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
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)
---(end of broadcast
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 Programming
Co-Founder
Sitening, LLC
http
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 Architect
Sitening, LLC
Open Source Solutions. Optimized Web Development.
http://www.sitening.com/
110 30th Avenue
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.com/
110 30th Avenue North, Suite 6
Nashville
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-6320
615-469-5150
615-469
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: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615
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 Open Source: Open Your i™
http
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, Sim
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,
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 the preference
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
Strategic Open
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
Sitening
, 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™
http://www.sitening.com/
110 30th
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 database.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source
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
Strategic Open Source
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:
Thomas F. O'Connell
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 37203-6320
615-260-0005
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 access the temp table
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
Sitening, LLC
Strategic Open
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'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open
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-Founder, Information Architect
Sitening, LLC
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 i™ http://www.sitening.com/ 110 3
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 Strategic Open
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.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203
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 the problem
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, at 12
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/
110 30th Avenue North, Suite 6
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
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'Connell [EMAIL
ings? 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 Your i™ http://www.sitening.com/ 110 30th Av
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, Information Architect
Sitening, LLC
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/
110 30th Avenue
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 Sitening, LLC Strategic Open Source: Open
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 Sitening, LLC
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:
Basically, it sounds
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, Information Architect
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
http
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:
Hello,
I
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 North, Suite 6
...
-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 row to a table, and one
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
615-260-0005
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 North, Suite 6
needs.
-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 25, 2005, at 1:39 PM, Andrus Moor wrote:
Thomas,
thank you for reply
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 27, 2005, at 11:38 AM, Dan
1 - 100 of 161 matches
Mail list logo