On Wed, Jul 18, 2007 at 11:02:51PM +0100, Richard Huxton wrote:
Francisco Reyes wrote:
As far as I know, currently one can set the search path globally, or on
a per role bases.
I was wondering if it could be possible to have a per database search_path.
I believe this would be not only
On Wed, Jul 18, 2007 at 11:30:48AM -0500, Scott Marlowe wrote:
EnterpriseDB, a commercially enhanced version of PostgreSQL can do
query parallelization, but it comes at a cost, and that cost is making
sure you have enough spindles / I/O bandwidth that you won't be
actually slowing your system
On Thu, May 17, 2007 at 08:19:08AM -0500, Lee Keel wrote:
I am restoring a 51GB backup file that has been running for almost 26 hours.
There have been no errors and things are still working. I have turned fsync
off, but that still did not speed things up. Can anyone provide me with the
On Wed, May 16, 2007 at 03:40:27PM -0700, Glen Parker wrote:
I think I know the answer to this, but...
Is there a semi-easy way vacuum all tables in a database *except* those
that are clustered?
You could query for tables that aren't clustered and use that to build a
list of VACUUM
Moving to -docs...
Does anyone know what the history of the docs saying that GNU tar had
issues with files changing underneath it? According to this report it's
actually BSD tar that has the issue.
On Wed, May 09, 2007 at 10:19:05AM -0700, Jeff Davis wrote:
On Wed, 2007-05-09 at 11:40 -0500,
On Sun, May 13, 2007 at 08:44:48PM +0200, Gerhard Wiesinger wrote:
Are there some presentations or documents of the internals of PostgreSQL
available?
Especially I'm looking for the concepts and detailed internals of general
transaction handling, internals of commit log, transaction logs,
On Sun, May 13, 2007 at 09:25:37PM +0200, Felix Kater wrote:
can I use a given tableoid (instead of the tablename) to select
columns from that table somehow?
SELECT * FROM ??tableoid??
snip
So, I worked around that by peforming two queries: The first to retrieve
the table's name from
On Fri, May 11, 2007 at 04:58:28PM +0300, Sorin N. Ciolofan wrote:
I increased significantly the number of shared buffers from 3000 to 100 000
(80Mb)
BTW, 100,000 shared buffers is actually 800MB, not 80.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB
On Tue, Feb 27, 2007 at 11:26:02AM -0800, Dhaval Shah wrote:
I am planning to use 8.2 and the average inserts/deletes and updates
across all tables is moderate. That is, it is a moderate sized
database with moderate usage of tables.
Given that, how often do I need to reindex the tables? Do I
On Tue, Feb 27, 2007 at 06:43:51PM -0600, John Jawed wrote:
Is there any difference as far as when the uniqueness of values is
checked in DML between a unique index vs a unique constraint? Or is
the only difference syntax between unique indices and constraints in
PostgreSQL?
Syntax only,
, the planner can make use of the
knowledge that a column or set of columns is guaranteed to be unique.
PostgreSQL currently can't do that.
John
On 2/27/07, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Tue, Feb 27, 2007 at 06:43:51PM -0600, John Jawed wrote:
Is there any difference as far
On Fri, Feb 23, 2007 at 01:49:06PM +1300, Andrej Ricnik-Bay wrote:
On 2/23/07, Jim Nasby [EMAIL PROTECTED] wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://tweakers.net recently did a
On Fri, Feb 23, 2007 at 01:25:25PM +, Dave Page wrote:
Given the recent discussions of applications stacks, PHP Ruby etc. it
seems an ideal time for me to introduce a project I've been working on.
StackBuilder is an extension of the Windows installer for PostgreSQL
that will allow the
On Fri, Feb 23, 2007 at 04:08:45PM -0300, Alvaro Herrera wrote:
Mark Stosberg wrote:
I just tried to add something to the pg_autovacuum table for the first
time today (with 8.1). I wanted to make the simplest possible entry:
Disable auto-vacuuming for a table. However, the data model
to monopolize the machine.
--
Jim C. Nasby, Database Architect[EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: Where do you want to go today?
Linux: Where do you want to go tomorrow?
FreeBSD: Are you guys coming, or what
On Fri, Feb 23, 2007 at 06:47:52PM -0500, Tom Lane wrote:
I wrote:
I don't find this particularly important, because we have never intended
direct update of catalog entries to be a primary way of interacting with
the system. The current pg_autovacuum setup is a stopgap until the dust
has
On Tue, Jan 23, 2007 at 07:47:26AM -0800, Subramaniam Aiylam wrote:
Hello all,
I have a setup in which four client machines access
a Postgres database (8.1.1) running on a Linux box.
So, there are connections from each machine to the
database; hence, the Linux box has about 2 postgres
On Sun, Jan 21, 2007 at 11:39:45AM +, Heikki Linnakangas wrote:
Russell Smith wrote:
Strange idea that I haven't researched, Given Vacuum can't be run in a
transaction, it is possible at a certain point to quit the current
transaction and start another one. There has been much chat and
On Sat, Jan 20, 2007 at 11:19:50AM -0600, Kelly Burkhart wrote:
On 1/20/07, Shoaib Mir [EMAIL PROTECTED] wrote:
Should help -- ALTER TABLE tablename ALTER columname TYPE text;
I was looking for a way to alter a column from varchar(n) to text
without using the alter command and consequently
On Sun, Jan 21, 2007 at 06:55:56AM -0800, brian stone wrote:
Are there any built in tools or 3rd party tools for distributing a postgresql
database? I need an active active configuration; master-master with fail
over. The project I am working needs to support a very large number of
On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote:
On 1/21/07, mbneto [EMAIL PROTECTED] wrote:
Hi,
I have a dumpall file generated from a 8.0 version that I need to import
back to a 7.4 server.
Is there a way to do that?
a psql -f db.out template1 gives me
On Thu, Jan 11, 2007 at 06:04:56PM -0500, Andrew Dunstan wrote:
Please don't. At least not on the PostgreSQL web site nor in the docs.
And no, I don't run my production servers on Windows either.
For good or ill, we made a decision years ago to do a proper Windows
port. I think that it's
On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote:
The downside of this is that a real EACCES problem wouldn't get noted at
any level higher than LOG, and so you could theoretically lose data
without much warning. But I'm not seeing anything else we could do
about it --- AFAIK we have
On Thu, Jan 11, 2007 at 04:32:42PM -0500, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
Given that this could result in data loss, if this was to be done I'd
very much want to see a way to disable it in a production environment.
Production environments are the same ones that won't
On Mon, Oct 30, 2006 at 10:49:33PM -0500, Ron Peterson wrote:
I created a set of PostgreSQL functions which implement the extended set
of digest/hashing functions provided by the Mhash library
(http://mhash.sourceforge.net/).
For anyone interested, the code is available here:
On Thu, Nov 09, 2006 at 08:54:20AM -0500, Rick Schumeyer wrote:
To date I have always used pg on a system where I had pg superuser status.
I'm trying to move a database from such a system to one where I am just
a user, and I'm having a couple of problems.
The first is, the output of pg_dump
On Thu, Nov 09, 2006 at 04:37:23PM +0100, Alban Hertroys wrote:
'lo list,
I have a plpgsql SP where I loop through a cursor. I have an internal
variable that keeps the previous row, so that I can compare it with the
current row in the cursor.
Like so;
DECLARE
current
You want to do count(DISTINCT part_id) and count(DISTINCT desc).
On Sat, Nov 11, 2006 at 04:25:51PM -0800, Kojak wrote:
Here's a description of the scenario. The question I'm asking follows
the description.
3 tables
table1:
job_no int4
rate1 float4
qty1 float4
rate2 float4
qty2 float4
On Tue, Nov 14, 2006 at 06:08:44AM -0800, [EMAIL PROTECTED] wrote:
Good morning,
I've recently just inherited a PostgreSQL database that is a back end
for some logistics software we use here. We have our own Oracle
servers in our group on faster machines with automated backup so we
would
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's causing
it. I wasn't able to catch a backtrace before we killed it. I
do not see autovac locks in the pg_locks view.
On Tue, Nov 14, 2006 at 01:31:28PM -0500, Carlson, James (Jim) wrote:
I have an old server that is still working faithfully. It is running Red
Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
I am concerned is closer than I want it to be, I have set up a shinny
new
On Tue, Nov 14, 2006 at 12:53:56PM -0700, Ed L. wrote:
On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's
Moving to -general (and please start a new thread instead of hijacking
an existing one).
On Thu, Nov 02, 2006 at 01:14:22PM -0500, louis gonzales wrote:
Hello all,
Is there an existing mechanism is postgresql that can automatically
increment/decrement on a daily basis w/out user interaction?
On Sun, Oct 22, 2006 at 12:03:38AM +0300, Devrim GUNDUZ wrote:
On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote:
Can we convert from Postgres to Oracle !!???
You can also run our software and get Oracle syntax for 1/25th the cost.
--
Jim Nasby
On Thu, Oct 19, 2006 at 07:51:17AM -0300, Rodrigo Sakai wrote:
I?m developing a specialist application that needs a different kind of
referential integrity! I need interval referential integrity where the
bounds of the referenced interval must overlaps (or be equal) the bounds of
the
On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote:
Only if each message is contained in its own transaction since now()
is effectively a constant throughout a transaction. In this case, I
would choose a surrogate key since it is likely that the table will
be referenced.
See
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
index.
shared_buffers = 1000 # min 16 or max_connections*2, 8KB each
This is *way*
On Tue, Oct 17, 2006 at 02:43:28PM -0400, Vivek Khera wrote:
On Oct 17, 2006, at 2:35 PM, Steve Poe wrote:
Vivek,
What methods of backup do you recommend for medium to large
databases? In our example, we have a 20GB database and it takes 2
hrs to load from a pg_dump file.
my
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
Hi everybody!
I ask you for your help on a problem I have.
I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
some VERY memory intense queries, that put processor up to 40%. I see
Note that you're likely to see
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 16:08, Jim C. Nasby wrote:
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
Hi everybody!
I ask you for your help on a problem I have.
I have
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
Hello all,
I read a paper, which is Query optimization in the presence of Foreign
Functions.
And the paper , there is a paragraph like below.
In order to reduce the number of invocations, caching the results of
invocation
And PLEASE do not post something to 3 lists; it's a lot of extra traffic
for no reason.
Moving to -hackers.
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
Hello all,
I read a paper, which is Query optimization in the presence of Foreign
Functions.
And the paper , there is a
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote:
In any case, you'll be much, much happier if you do this project on at
least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
support requirements it will probably remain supported for a few more
years by Tom/the
On Thu, Oct 12, 2006 at 05:39:20PM -0500, Scott Marlowe wrote:
It seems to me the first logical step would be having the ability to
flip a switch and when the postmaster hits a slow query, it saves both
the query that ran long, as well as the output of explain or explain
analyze or
On Fri, Oct 13, 2006 at 11:53:15AM -0400, AgentM wrote:
One simple first step would be to run an ANALYZE whenever a
sequential scan is executed. Is there a reason not to do this? It
Yes. You want a seqscan on a small (couple pages) table, and ANALYZE has
a very high overhead on some
The only case I can think of where view partitioning makes more sense is
if it's list partitioning where you can also drop a field from your
tables. IE: if you have 10 projects, create 10 project_xx tables where
xx is the ID of the project, UNION ALL them together in a view, and
create rules on
On Fri, Oct 13, 2006 at 01:52:10PM -0400, Merlin Moncure wrote:
On 10/13/06, Tom Lane [EMAIL PROTECTED] wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Is that really true? In theory block n+1 could be half a revolution
after block n, allowing you to commit two transactions per
On Thu, Oct 12, 2006 at 07:40:42PM +0200, Tim Tassonis wrote:
I have yet to see a good application that supports database
independence.
If you are talking about high- end applications (big databases with lot
of transactions), you're of course right. However, there are a lot of
On Wed, Oct 11, 2006 at 11:13:21AM +0700, Luki Rustianto wrote:
... so what if the database size is above 20 GB, do we have to do
pg_dump each at periodics time to get reliable backup?
No, you can also use Point In Time Recovery (PITR).
--
Jim Nasby
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:
When I start PostgreSQL service, the below error message is displayed and
finally service didn't started.
The PostgreSQL Database Server 8.0 service of a local computer cannot begin.
Error 1069: Service was not
On Thu, Oct 12, 2006 at 03:31:50PM -0500, Scott Marlowe wrote:
While all the talk of a hinting system over in hackers and perform is
good, and I have a few queries that could live with a simple hint system
pop up now and again, I keep thinking that a query planner that learns
from its mistakes
Moving to -general.
On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS, Chennai. wrote:
All,
We are facing few issues while we install Postgres 8.0 in Windows 2000
Japanese OS. Installer kit name : postgresql-8.0-ja
Is there a reason you're not using 8.1.4? 8.0 was the first
And run, do not walk, to the latest version of 7.4.x. Better yet,
upgrade to 8.1.4.
On Thu, Oct 05, 2006 at 01:04:05AM +0500, Shoaib Mir wrote:
Run the following
pg_ctl -D data folder path status
to see if you have the db server running or not?
As these seems to me you dont have the
Please take a look at
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html first.
In a nutshell, set shared_buffers to between 10% and 25% of your memory
if it's a server. And increase estimated_cache_size to something close
to how much memory you have.
On Tue, Oct 03, 2006 at
On Fri, Oct 06, 2006 at 05:15:55PM +0200, Thomas Poindessous wrote:
Hello,
I have a problem with my postgresql 7.4.9 server.
I tried to restore a dump on the backup server (same version).
I got this error :
pg_restore: ERROR: date/time field value out of range: 0001-02-29
00:00:00
On Tue, Oct 10, 2006 at 06:25:21PM -0300, Jorge Godoy wrote:
Jacob Coby [EMAIL PROTECTED] writes:
We were looking to improve our session performance, so I did a basic
test of using mysql 4.0 innodb vs postgres 8.1. The test did a simple
retrieve, update, save; 1 time per page. mysql was
On Tue, Oct 10, 2006 at 05:31:08PM -0700, Richard Broersma Jr wrote:
My test server's sw/raid array recently died where I kept my PostgreSQL data
directory. I have
both a full dump of the database and a file system back-up of the data
directory.
I tried to restore my file system back-up
Patches welcome. :)
BTW, -docs or -www might be a better place to discuss this.
On Mon, Oct 02, 2006 at 05:11:20PM -0400, Brandon Aiken wrote:
I think the problem would be partly mitigated be better or more obvious
documentation that makes it clear that a) PostgreSQL is probably not
On Thu, Sep 28, 2006 at 01:27:24PM +0300, Adnan DURSUN wrote:
Hi all
I wanna know what is going on while a DML command works. For example
;
Which commands are executed by the core when we send an UPDATE tab
SET col = val1...
in case there is a foreing key or an
On Thu, Sep 28, 2006 at 03:19:46PM -0700, Casey Duncan wrote:
I have some databases that have grown significantly over time (as
databases do). As the databases have grown, I have noticed that the
statistics have grown less and less accurate. In particular, the
n_distinct values have
I believe there's a TODO item for index-organized tables/clustered
tables. If not, there's certainly been discussion about it on the
-hackers list.
On Sun, Sep 17, 2006 at 10:21:27PM -0700, CG wrote:
As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a
lot of cases, the
On Thu, Sep 21, 2006 at 10:48:47AM -0500, Scott Marlowe wrote:
On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear
On Wed, Sep 20, 2006 at 05:30:59PM -0700, CSN wrote:
PostgreSQL doesn't have any booth babes? ;P
Berkus doesn't count??! He's got long hair! What more do you want?!
:P
csn
On 09/20/06 16:38, Philip Hallstrom wrote:
[snip]
I think that description is false. At a certain point in the
On Fri, Sep 22, 2006 at 11:14:06AM +0200, Andrew Kelly wrote:
On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote:
Merlin Moncure wrote:
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently
On Mon, Sep 18, 2006 at 12:29:56AM +0300, Enver ALTIN wrote:
On Fri, 2006-09-15 at 09:38 -0700, Joshua D. Drake wrote:
Hello,
Hi Joshua,
Yeah, this is a cross post and it is slightly off topic but IMHO this is
important.
Tomorrow one of our own, Devrim Gunduz is becoming a man.
On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
Is there any utility in postgresql which can do the following?
Moving to pgsql-general, which is the appropriate list for this.
The utility must update the table whenever there is any change in the
text file.
COPY command helps to
, yet I'm not sure it's even
possible since the docs only mention it in passing, and I wasn't able to
find anyone example script that implements a restore_command that does
this. Am I missing something that is obvious?
See above pgfoundry link. :)
--
Jim C. Nasby, Sr. Engineering Consultant
C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 4: Have you searched our
don't. :( Unless you manually break your
operation up into multiple steps.
There is a lot of discussion on bizgres-general right now about
statement queuing, which migth help in your case.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
to
fire on any other operation that is happening concurrently. Is this
even possible?
Best bet would be to have the procedure only execute as a given user
(probably via security definer) and detect that in the trigger.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive
regression tests, or a lack of
people/motivation to work on them?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end
the database down and copy files
around' and the like. Nothing remotely close to the abilities of Slony.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
easy; they're probably one
of the most complex pieces of IT in commmon use today. IMO, in trying to
'make it simple', a lot of people end up burned.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http
on that site).
See also the MySQL/PostgreSQL thread that was on this list yesterday.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
on your
hardware.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 3: Have
appreciated.
Don't use OIDs, use SERIALs instead. You're going to run into all kinds
of problems using OIDs.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569
the schema name or ensure that bar is in search_path.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast
have a sequence for translation_id and grab from it manually
every time you create a translation, then just use that value when you
insert into translation_phrase.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
format (I guess I am asking if someone has seen or
written a PDF generator script/storedProc for Postgres)?
No, but you should be able to make that happen using an untrusted
language/function and some external tools.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive
in the face of volatile arguments.
I believe a safe alternative would be...
INSERT INTO ... SELECT * FROM
(SELECT random()*20 FROM ...)
;
You might need to add an ORDER BY to the subquery to ensure PostgreSQL
doesn't pull it into the main query.
--
Jim C. Nasby, Sr. Engineering Consultant
be greatly appreciated.
Thanks,
Brandon
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Jim C. Nasby, Sr
tables?
You're more likely to run into problems with large fields being toasted
than plain large tables. IIRC Oracle's large object support is better
than PostgreSQL's.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231
.
The Oid will wraparound when it reaches the 32bits unsigned integer limit.
If you don't use the oid explicitely in your application, then you don't
worry about it.
Except IIRC the OP is running 7.4 which doesn't have checks in DDL code
to deal with OID collisions. :(
--
Jim C. Nasby, Sr
) CRC'd, because there was
extensive discussion around 32 bit vs 64 bit CRCs. There is no such
check for data pages, although PostgreSQL has other ways to detect
errors. But in a nutshell, if you care about your data, buy hardware you
can trust.
--
Jim C. Nasby, Sr. Engineering Consultant
On Mon, Jun 12, 2006 at 05:02:09PM +0100, John Sidney-Woollett wrote:
Jim C. Nasby wrote:
Except IIRC the OP is running 7.4 which doesn't have checks in DDL
code to deal with OID collisions. :(
This is not good news! :(
What about other long runing 7.4.x DBs? Do you really have to dump
on the subject of oids
http://www.postgresql.org/docs/faqs.FAQ.html#item4.12
Basically, it's best if you just don't use them.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
On Mon, Jun 12, 2006 at 07:55:22PM +0200, Florian Weimer wrote:
* Jim C. Nasby:
Anyway, how would be the chances for PostgreSQL to detect such a
corruption on a heap or index data file? It's typically hard to
detect this at the application level, so I don't expect wonders. I'm
just
is triggered only when a row value to be stored in a
table is wider than BLCKSZ/4 bytes (normally 2Kb).
BTW, 'row value' seems a bit prone to confusion (could be interpreted as
the row itself). It'd probably be better to say 'field'. Barring
objections, I'll submit a patch.
--
Jim C. Nasby, Sr
process will be the only
process that can see it. When you are through with it, delete the record, all
within the same transaction, and your purpose will be served.
If you use a temp table for that, you can have it truncate on
commit/rollback.
--
Jim C. Nasby, Sr. Engineering Consultant
This tells me that you need to be vacuuming more. Autovac is your
friend.
On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:
Yeah - I just did a reindex, that fixed the indexes at least.
Alex
On 6/8/06, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Thu, Jun 08, 2006 at 06:03:23PM
column
instead.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
TIP 3: Have
Lutzeb?ck* [EMAIL PROTECTED] Tel +49.30.5362.1635 Fax .1638
CTO AEC/communications GmbH http://www.aeccom.com, Berlin, Germany
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Slony, pgmirror, and I think there's another one.
google:postgresql replication
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED
On Fri, Jun 09, 2006 at 01:51:23PM -0500, Scott Marlowe wrote:
On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote:
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql replication for
postgresql 8.0?
Slony, pgmirror, and I think
this for a bunch of
tables is to write some code that will generate the trigger code for
you.
BTW, you can also do the auditing with rules. Just remember that you
can't reliably audit SELECTS, since someone could always do:
BEGIN;
SELECT ...
ROLLBACK;
--
Jim C. Nasby, Sr. Engineering Consultant
, only a VACUUM FULL will.
If that drops the size of the relations substantially, you'll probably
want to REINDEX everything to reclaim lost space in the indexes as well.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231
access on the website, you could well find yourself very
disappointed with the performance of MyISAM and it's table-level
locking. There's probably also some gains to be had on the PostgreSQL
performance.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http
, and the
combination of the two.
Thanks In Advanced.
Chris
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
back to 7.2 if not 7.1 or 7.0).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast
the function, but I got an error, cannot
run vacuum inside of function.
Any thoughts?
Best bet would probably be to turn on autovacuum. Short of that, setup a
cronjob.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
1 - 100 of 631 matches
Mail list logo