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
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 syst
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
> op
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 comm
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??
> So, I worked around that by peforming two queries: The first to retrieve
> the table's name from pg_c
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 lo
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, Ji
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
rally a
SELECT) with certain conditions, 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
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,
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?
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
ike schedulers.
Actually, I believe part of the discussion also involved how to handle
long-running workloads that you don't want to monopolize the machine.
--
Jim C. Nasby, Database Architect[EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #182
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
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
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 d
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 postgre
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 m
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
> tra
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 conseq
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 ch
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
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.
>
>
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 ha
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,
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 s
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 vie
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
> wo
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
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 table
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_
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:
>
> http:/
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 Mon, Oct 23, 2006 at 11:19:13PM +0530, sumit kumar wrote:
> Hello ,
> does anybody help me out telling how the PostGRESQL estimates
> cardinality of LIKE operator.
Try asking on pgsql-hackers... (sorry, I don't know the answer myself).
--
Jim Nasby
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* to
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 time
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 refe
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/th
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 y
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
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
> invoca
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
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
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 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 revolution.
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 tha
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 platfo
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
> > > ana
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 mista
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 w
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 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
> a
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 bac
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.
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
>
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 07:50:4
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 status
>
> to see if you have the db server running or not?
>
> As these seems to me you dont have the database serv
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 wi
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
> configu
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 b
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 k
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
> > > appar
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 poi
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 eve
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 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 beco
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
with a link or two?
> Thanks.
Right now, you basically 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 Consul
's got its uses, but it's got its issues as well.
And if you're vacuuming frequently enough, there shouldn't be that much
need to reindex.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com
d to recover you'll have most of what you need...but
> >perhaps not all.
>
> I say the "hot standby" is a common scenario, 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 exa
's also a PostgreSQL section 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/pe
;easy', but the reality is
that unless it's a pretty trivial embedded database, databases (both
RDBMSes and database design and use) aren't 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 peo
care not to use same TCP port numbers for tests), but it
> still seems flaky as hell.
I attended a talk about MySQL and High Availability once and was pretty
unimpressed. Lots of 'now you take the database down and copy files
around' and the like. Nothing remotely close to the abilities o
'm a little worried about writing tests based on GPLed code
> for Slony-I or other replication systems. Might these need to be
> clean-roomed?
Is there actually a lack of ideas for our regression tests, or a lack of
people/motivation to work on them?
--
Jim C. Nasby, Sr. Engineering Cons
those triggers 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
e1) that would account for this problem? Could it be a bug
> in pgadmin?
Possibly. Can you reproduce it in psql? Keep in mind you'll need to
either specify the schema name or ensure that bar is in search_path.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
ably.
> ANY advice 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.n
cost_delay to about 20, depending 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 broadca
rases) are references.
BTW, it's "PostgreSQL" or "Postgres" if you must.
> What is the best solution?
I'd just 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
rmance of postgres
> vs. oracle, specifically with very large 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
ow 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. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.
macro and has the usual
> multiple-evaluation gotchas 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 mai
Doc From the BLOB colum and dump
> it into a PDF 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,
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 applic
I'm a bit lost
> 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
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 runi
atch this
> sooner.
I know that WAL pages are (or at least were) 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,
ning 7.4 which doesn't have checks in DDL code
to deal with OID collisions. :(
--
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
--
however, I use various
> utility
> tables to accomplish this type of task. You can insert records into a table
> like this while inside a transaction and the current process will be the only
> process that can see it. When you are through with it, delete the record, all
> within the
org/docs/8.1/interactive/storage-toast.html:
"The TOAST code 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
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.
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 [EMAI
t copy
> it, re-transmit it, use it or disclose its contents, but should return
> it to the sender immediately and delete your copy from your system.
> Thank you for your cooperation./
>
> *Dirk Lutzeb?ck* <[EMAIL PROTECTED]> Tel +49.30.5362.1635 Fax .1638
> CTO AEC/com
th a serial 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)--
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:
> >
verbose shows that I have enough entries in the free space map...
A lazy vacuum won't reclaim empty space, 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.
--
Ji
them in a
column. Probably your best bet if you need to do 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:
BEGI
o, the commentary about how MySQL is faster isn't very clear. Are you
using MySQL as some kind of result cache? When you get to running actual
concurrent access on the website, you could well find yourself very
disappointed with the performance of MyISAM and it's table-level
locking. The
t to
> break up data, between schemas, physical separate databases, and the
> combination of the two.
>
> Thanks In Advanced.
>
> Chris
>
> -------(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmast
On Tue, May 23, 2006 at 05:00:13PM -0600, Ed L. wrote:
> On Tuesday May 23 2006 4:55 pm, Jim C. Nasby wrote:
> > Well, I did find one reason not to go ape with this: the
> > number of pages analyzed scales with the number of buckets, so
> > doubling the statistics target wi
1 - 100 of 641 matches
Mail list logo
