Re: [GENERAL] VACUUM ANALYZE extremely slow

2007-06-17 Thread Christopher Browne
A long time ago, in a galaxy far, far away, Sergei Shelukhin <[EMAIL PROTECTED]> wrote: > This is my first (and, by the love of the God, last) project w/pgsql > and everything but the simplest selects is so slow I want to cry. > This is especially bad with vacuum analyze - it takes several hours >

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

2007-10-07 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, michi <[EMAIL PROTECTED]> belched out: > Does PostgreSQL store records sorted by primary key? No. It initially stores tuples based on the order in which they are inserted. Behaviour changes later when a table has free space due to deleted tuples. -- let

Re: [GENERAL] enabling autovacuum

2008-01-28 Thread Christopher Browne
On Jan 28, 2008 10:17 PM, Jeremy Harris <[EMAIL PROTECTED]> wrote: > Hi, > > We're starting to run autovacuum for the first time on a system > that's been running with nightly cron-driven vacuum for some time. > > Version: > PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1

Re: [GENERAL] [SQL] commit inside a function failing

2015-01-24 Thread Christopher Browne
The straightforward answer is that stored functions always run *inside* the context of a preexisting transaction, therefore you cannot request a separate transaction from within a stored function. What you are asking is fairly deeply impossible.

Re: [GENERAL] Imperative Query Languages

2017-07-10 Thread Christopher Browne
On 5 July 2017 at 01:22, Jason Dusek wrote: > Hi All, > > This more of a general interest than specifically Postgres question. Are > there any “semi-imperative” query languages that have been tried in the > past? I’m imagining a language where something like this: > > for employee in employees: >

Re: [GENERAL] Please say it isn't so

2017-07-12 Thread Christopher Browne
On 12 July 2017 at 00:51, Steve Litt wrote: > Hi all, > > Please tell me this is a mistake: > > https://wiki.postgresql.org/wiki/Systemd > > Why a database system should care about how processes get started is > beyond me. Systemd is an entangled mess that every year subsumes more > and more of th

Re: [GENERAL] [HACKERS] SAP Application deployment on PostgreSQL

2017-09-08 Thread Christopher Browne
On 8 September 2017 at 15:34, chiru r wrote: > We have multiple SAP applications running on Oracle as backend and looking > for an opportunity to migrate from Oracle to PostgreSQL. Has anyone ever > deployed SAP on PostgreSQL community edition? > > Is PostgreSQL community involved in any future ro

Re: [GENERAL] looking for a globally unique row ID

2017-09-15 Thread Christopher Browne
On 15 September 2017 at 14:45, Adam Brusselback wrote: >> I cannot image a single postgres index covering more than one physical >> table. Are you really asking for that? > > > While not available yet, that is a feature that has had discussion before. > Global indexes are what i've seen it called

Re: [GENERAL] Finally upgrading to 9.6!

2017-10-18 Thread Christopher Browne
On 18 October 2017 at 17:17, Vik Fearing wrote: > On 10/18/2017 08:17 PM, Don Seiler wrote: >> On Wed, Oct 18, 2017 at 1:08 PM, Vik Fearing >> mailto:vik.fear...@2ndquadrant.com>> wrote: >> >> On 10/18/2017 05:57 PM, Melvin Davidson wrote: >> > >> > I support the policy of using cautio

Re: [GENERAL] Request for help with database of Kenyan election violence

2008-02-02 Thread Christopher Browne
On Feb 2, 2008 4:51 PM, Karl O. Pinc <[EMAIL PROTECTED]> wrote: > Hello, > > The Kenya National Commission for Human Rights is investigating > the violence in Kenya. This has led to an urgent request on Groklaw > http://www.groklaw.net/article.php?story=20080202013451629 > for assistance in settin

Re: [GENERAL] postgresql book - practical or something newer?

2008-02-03 Thread Christopher Browne
On Jan 31, 2008 4:40 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote: > Robert Treat wrote: > > > Just so you know, I approached OReally about writing a PostgreSQL Cookbook, > > and they turned it down. They did offer me some other titles, but those > > don't > > seem to have gone anywhere. > > As som

Re: [GENERAL] postgresql book - practical or something newer?

2008-02-04 Thread Christopher Browne
On Feb 4, 2008 3:31 PM, Tom Hart <[EMAIL PROTECTED]> wrote: > > Christopher Browne wrote: > > On Jan 31, 2008 4:40 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote: > > > >> Robert Treat wrote: > >> > >> > >>> Just so you know, I app

Re: [GENERAL] [OT] "advanced" database design (long)

2008-02-09 Thread Christopher Browne
On Feb 3, 2008 11:14 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > I"m not a database expert, but wouldn't > > create table attribute ( > attribute_id int > attribute text > ) > > create table value ( > value_id int > value text > ) > > create table attribute_value ( >entity_id int > a

Re: [GENERAL] Continual uptime while loading data ... COPY vs INSERTS within a transaction.

2008-02-09 Thread Christopher Browne
On Feb 9, 2008 6:30 PM, Benjamin Arai <[EMAIL PROTECTED]> wrote: > Hello, > > We are running a system which requires continual uptime while loading > data. Currently one particular table receives a large number of inserts > per commit (about 1 inserts). This process works well allowing both >

Re: [GENERAL] end of life for pg versions...

2008-02-11 Thread Christopher Browne
On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > I did manage to find an announcement about the support of pg for > windows... but I wasn't able to see anything you'd have a summary of > scheduled and planned EOL for various pg versions (on different > platform). There h

Re: [GENERAL] Different host aliases in SLONY configuration table

2008-02-14 Thread Christopher Browne
On Thu, Feb 14, 2008 at 12:10 PM, Timur Luchkin <[EMAIL PROTECTED]> wrote: > I have a question regarding SLONY replication. In short, the question is: > Can I have different values on every node in the "sl_path" table in column > "pa_conninfo"? > > For example, one node has IP addresses in "pa_conn

Re: [GENERAL] Maximum realistic number of database user accounts?

2008-02-14 Thread Christopher Browne
On Thu, Feb 14, 2008 at 5:16 PM, Greg Fausak <[EMAIL PROTECTED]> wrote: > Howdy, > > I find that user accounts are very good for > helping me protect application access to the database. > That is, instead of giving a user 1 account, I may give hem > 10, and each of those accounts are restricted

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

2008-02-15 Thread Christopher Browne
On 2/14/08, hewei <[EMAIL PROTECTED]> wrote: > Can send email from stored procedure in Postgres? In principle, yes, using one of the "untrusted" stored function languages. pl/perl, pl/sh, pl/python, and such. I wouldn't do things that way... I would instead queue messages (or suitable informati

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

2008-02-18 Thread Christopher Browne
On Feb 17, 2008 7:47 AM, Jorge Godoy <[EMAIL PROTECTED]> wrote: > Em Friday 15 February 2008 12:36:37 Adam Rich escreveu: > > > I would instead queue messages (or suitable information about them) in > > > a table, and have a process outside PostgreSQL periodically poll for them > > > > Why poll whe

Re: [GENERAL] handle audiofiles in postgres

2009-09-03 Thread Christopher Browne
, perhaps with cryptic names (hashes?) - Storing the metadata about the files in the database, referencing the files' names If there's good reason to store the files in the DBMS, then do so; just make sure there's good reason for it! -- let name="cbbrowne" and

Re: [GENERAL] postgresql.key secure storage

2009-09-15 Thread Christopher Browne
it publicly enough to make it accessible to rather more than the "1% of supergurus." If you're trying to design something, intending it to be tamper-resistant, then you *have* to consider the "supergurus," particularly because they might blaze a trail for others to follow..

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

2011-07-10 Thread Christopher Browne
On Mon, Jul 11, 2011 at 12:01 AM, Michael Nolan wrote: > > > On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas wrote: >> >> But if that's what you want, just don't put your data in different >> databases in the first place.  That's what schemas are for. > > Sadly, DBAs don't always have the ability to

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

2011-07-11 Thread Christopher Browne
On Mon, Jul 11, 2011 at 10:12 AM, Florian Pflug wrote: > On Jul11, 2011, at 07:08 , Darren Duncan wrote: >> Christopher Browne wrote: >>> Vis-a-vis the attempt to do nested naming, that is "ns1.ns2.table1", >>> there's a pretty good reason NOT to

[GENERAL] UUID + RPM + 64 bit

2010-05-13 Thread Christopher Browne
ut = ("cbbrowne" "@" "ca.afilias.info") Christopher Browne "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three" -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] nntp not working

2010-08-21 Thread Christopher Browne
2010/8/18 Arturo Pérez : > Is anyone else having problems accessing the mailing lists through NNTP? Yeah, I see the occasional message coming through, but it looks like the gateway between mail and NNTP isn't working. -- http://linuxfinances.info/info/linuxdistributions.html -- Sent via pgsql-g

Re: [Slony1-general] Re: [GENERAL] Stripping out slony after / before / during pg_restore?

2008-09-25 Thread Christopher Browne
Richard Huxton <[EMAIL PROTECTED]> writes: > Glyn Astill wrote: >> Hi people, >> >> I'm setting us up a separate staging / test server and I want to read >> in a pg_dump of our current origin stripping out all the slony stuff. >> >> I was thinking this could serve two purposes a) test out backups >

Re: [GENERAL] Why would I want to use connection pooling middleware?

2009-01-15 Thread Christopher Browne
On Thu, Jan 15, 2009 at 10:54 AM, Kirk Strauser wrote: > I have a PostgreSQL 8.3.5 server with max_connections = 400. At this > moment, I have 223 open connections, including 64 from a bunch of webserver > processes and about 100 from desktop machines running a particular > application. The rest

Re: [GENERAL] Slave server: FATAL: incorrect checksum in control file

2009-01-16 Thread Christopher Browne
On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen wrote: > You are perfectly right, master is 32bit and slave is 64bit. I didn't even > consider that that would matter when "just" copying the data. First I was > using different versions on the two boxes, but ended up installing 8.3.5 on > both of t

Re: [GENERAL] number of connections

2009-01-19 Thread Christopher Browne
On Mon, Jan 19, 2009 at 12:10 PM, Rubén F. wrote: > First of all, excuse my english... > > I have a doubt. I am designing a program for manage CV's. This program > connect with a PostgresDB. This program will be used for 5,000 persons > becaus it will be used in a University. Then, ¿how many activ

Re: [GENERAL] Pet Peeves?

2009-02-02 Thread Christopher Browne
On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark wrote: > So, what do people say? Is Postgres perfect in your world or does it do some > things which rub you the wrong way? Things I'd particularly like to have that aren't entirely on the map yet: - In place upgrade - Stored procedures that can man

Re: [GENERAL] Pet Peeves?

2009-02-03 Thread Christopher Browne
On Mon, Feb 2, 2009 at 5:48 PM, Gregory Stark wrote: > Christopher Browne writes: > >> - Managing jobs (e.g. - "pgcron") > > A number of people have mentioned a job scheduler. I think a job scheduler > entirely inside Postgres would be a terrible idea. I think it

Re: [GENERAL] Scalability with large numbers of tables

2005-02-21 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Phil Endecott) was seen spray-painting on a wall: > Dear Postgresql experts, > > I have a single database with one schema per user. Each user has a > handful of tables, but there are lots of users, so in total the > database has thousands of tables. > > I'm a bit concerned

pgsql-general@postgresql.org

2005-02-21 Thread Christopher Browne
Quoth [EMAIL PROTECTED] ("Markus Wollny"): > Finally the time has come for us to upgrade our PostgreSQL > 7.4.5-servers to 8.0.1 - and though I'm very much looking forward to > some of the new features, the dump&reload process is worrying me a > bit this time. I've got one cluster in particular whi

Re: [GENERAL] Scalability with large numbers of tables

2005-02-21 Thread Christopher Browne
I'm pretty sure that slowness of tab completion has little to do with the performance of the filesystems. If you've got tens of thousands of relations, the tab completion code has to draw the whole list of relations from pg_class into memory and "marshal" it into a form usable by GNU Readline. TH

pgsql-general@postgresql.org

2005-02-21 Thread Christopher Browne
You might consider using Slony-I to minimize the downtime. I haven't done an upgrade using, but know that others have, and I've done the same using eRServer... The idea is that you set up an 8.0.1 backend, and set up replication well ahead of time. Replicate from the 7.4 system to the 8.0 one.

Re: [GENERAL] postgresql 8.0 advantages

2005-02-26 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] ("Jim C. Nasby") wrote: > On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote: >> On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote: >> > Thanks! >> > >> > Is there any documentation on how to upgrade to 8.0? >> > >> > Is it possible to upgrade from 7

Re: [GENERAL] postgresql 8.0 advantages

2005-02-27 Thread Christopher Browne
Yes, that certainly ought to work. If what you're meaning is that you make a replica that sits in /opt/VERSION8, and then, once the upgrade is complete, rename that to /opt/MYDATABASE which was where your version 7.4 DB used to be. We have copied databases from one server to another by copying th

Re: [GENERAL] Trigger email?

2005-03-01 Thread Christopher Browne
[EMAIL PROTECTED] (CSN) writes: > Is it possible to setup a trigger so that every time a > certain field is changed, an email is sent? Using > pl/pgsql. Something _like_ that is possible. What I would do instead is for the trigger to cause a record to be put into a table that might be called some

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-11 Thread Christopher Browne
That remains to be seen. I wouldn't consider it the least bit worthwhile to try to evaluate it now, as what is happening now is that "WinFolk" are getting their very first exposure to the software. It would seem surprising for new developers to emerge from the Windows(tm) population before at lea

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-11 Thread Christopher Browne
Quoth [EMAIL PROTECTED] ("Jim C. Nasby"): > With the attitude of "Windows can not be made to reliably run a > database", how many developers do you think will be attracted? That remains to be seen. I wouldn't consider it the least bit worthwhile to try to evaluate it now, as what is happening now

Re: [GENERAL] Best practices: Handling Daylight-saving time

2005-03-11 Thread Christopher Browne
[EMAIL PROTECTED] (Együd Csaba) wrote: > I'd like to ask your opininon about how to handle DST on an 7/24 system. > Where should it be handled: on the server side or on the client side? And > how could I (at all could I???) make it transparent? Don't use DST. Use GMT/UTC. That makes the issue g

Re: [GENERAL] Best practices: Handling Daylight-saving time

2005-03-16 Thread Christopher Browne
Don't use DST. Use GMT/UTC. That makes the issue go away. -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://cbbrowne.com/info/slony.html Signs of a Klingon Programmer #2: "You question the worthiness of my code? I should kill you where you stand!" ---(

Re: [GENERAL] Linux Filesystem for PG

2005-03-28 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] ("Joseph M. Day"), an earthling, wrote: > Can anyone recemmend a filesystem to use for Postgres. I currently > have one table that has 80 mil rows, and will take roughly 8GB of > space without indexing. Obviously EXT3 will die for a file size

Re: [GENERAL] Linux Filesystem for PG

2005-03-28 Thread Christopher Browne
Actually, it is common for "obvious" facts to be entirely incorrect. -> ext3 wouldn't "die" with a file of that size; it supports files up to about 2TB in size, and 8GB shouldn't be an "uncomfortable" size -> PostgreSQL normally switches to a new file at 1GB intervals, so that no file is ev

Re: [GENERAL] LWM 2004 Readers' Choice Nomination

2005-03-28 Thread Christopher Browne
[EMAIL PROTECTED] ("Joshua D. Drake") wrote: > On Mon, 2005-03-28 at 11:03 -0700, Ed L. wrote: >> On Thursday March 24 2005 7:07, [EMAIL PROTECTED] wrote: >> > Thank you for registering! >> > >> > http://www.sys-con.com/linux/readerschoice2004 >> >> Curiously, I see PostgreSQL is not even on the b

Re: [GENERAL] LWM 2004 Readers' Choice Nomination

2005-03-28 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] ("Ed L.") wrote: > On Thursday March 24 2005 7:07, [EMAIL PROTECTED] wrote: >> Thank you for registering! >> >> http://www.sys-con.com/linux/readerschoice2004 > > Curiously, I see PostgreSQL is not even on the ballot I see at > the site

Re: [GENERAL] do I need replication or something else?

2005-03-29 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Caleb Simonyi-Gindele) would write: > John Burger wrote: If it were me, and someone proposed a model where two-way replication was needed, I would tell them to rethink their model. It's broken. >>> >>> I would respectfully d

Re: [GENERAL] psql and mysql

2005-04-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("YL") wrote: > Dear List, > I'm new to Psql and very eager to learn the differences between these two > RDBMS. Well, you can find the documentation for PostgreSQL at , and you can find the documentation for M

Re: [GENERAL] www.thekompany.com rekall

2005-04-27 Thread Christopher Browne
Quoth [EMAIL PROTECTED]: > I just downloaded the windows demo for Rekall, which is an MSAccess > like product (loosely speaking) with native drivers for postgresql > and some other engines (plus odbc for yet others).  I was a bit > confused on certain things so I emailed my questions, and the > pre

Re: [GENERAL] Thanks for Rekall link!

2005-04-27 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote: > I must say one intereting thing. When I downloaded the trial version > from TheKompany, and asked it to browse a test file in PGSql which I > loaded with 250,000 rows, it started to read them, and read for a > long long time (as

Re: [GENERAL] postgresql replication

2005-05-05 Thread Christopher Browne
Martha Stewart called it a Good Thing when Peter Wilson <[EMAIL PROTECTED]> wrote: > I looked at Slony, which seems to be a current favourite -but I > couldn't get it working on my database (claimed my tables didn't have > relevant keys - which they do). Slony-I had almost non-existent > documenta

Re: [GENERAL] postgresql replication

2005-05-05 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Scott Marlowe) would write: > On Wed, 2005-05-04 at 21:06, Vlad wrote: >> the number one aim at the moment is to have "always-up-to-date" copy >> of our main DB with minial performance impact on replication > > Have you considered point in

Re: [GENERAL] Adventures in Quest for GUI RAD

2005-05-06 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Zlatko Matic") wrote: > It seems that many people fanatically recommend Delphi, while others > fanaticaly despise Delphi. I've sent a question about comparative > features of MS Access/Visual Studio/Delphi for working with > databases

Re: [GENERAL] bulk loader

2005-05-19 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Hrishikesh Deshmukh) belched out: > Is there a "bulk loader" in postgresql with which one can read in say > a tab delimited format text file. Before one does all one has to do is > create the table with text file column names as attribut

Re: [GENERAL] Fast request for version checking....

2005-05-28 Thread Christopher Browne
Oops! [EMAIL PROTECTED] ("Mohan, Ross") was seen spray-painting on a wall: > I have 2.53, yes. > > But, I am going to rebuild and re-AC this, so need > to build m4 (1.4.3) in order to get to 2.59 of AConf. > > Any reasons to strongly advocate or avoid forcing > compiler into strict ANSI/C99 or IS

Re: [GENERAL] Fast request for version checking....

2005-05-29 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] ("Mohan, Ross") wrote: > Thanks for taking the time for a thoughtful response. Once > again, I am educated on this list > > I was a bit unclear in original post -- while I *am* planning on > stabilizing my build environment (updatin

Re: [GENERAL] Accessing PostgreSQL from C++

2005-05-31 Thread Christopher Browne
[EMAIL PROTECTED] (Jeff Brown) wrote: > Is there some sort of C API available for PostgreSQL? Yes, there is a C API available for PostgreSQL. It is called libpq. Was there some particular reason why you could not find it in the documentation? It has an entire chapter devoted to it in the docume

Re: [GENERAL] PostgreSQL vs. InnoDB performance

2005-06-03 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Marco Colombo) belched out: > On Fri, 2005-06-03 at 11:38 +0200, Peter Eisentraut wrote: >> Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut: >> > On a particular system, loading 1 million rows (100 bytes, nothing >> > fancy) into

Re: [GENERAL] postgresql books

2005-06-04 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: > "Gevik babakhani" <[EMAIL PROTECTED]> wrote: > >> Beside the documentation, which pg book would you recommend? Which one is >> your personal favorite pg book? > > I saw an O'Reilly book [1] this afternoon at a bookshop here in

Re: [GENERAL] Backing up multiple databases

2005-06-17 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Jacob Atzen) wrote: > On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote: >> On 17 Jun 2005 at 13:52, Jacob Atzen wrote: > >> > The second problem is a matter of database ownership. Apparently >> > pg_dumpall will dump th

Re: [GENERAL] PostgreSQL Certification

2005-06-24 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] ("Jim C. Nasby") wrote: > On Fri, Jun 24, 2005 at 08:42:00AM -0700, Joshua D. Drake wrote: >> Tatsuo Ishii wrote: >> >>Am Sonntag, 12. Juni 2005 05:24 schrieb Tatsuo Ishii: >> >> >> >>>Thank you for interested in PostgreSQL CE. There is

Re: [GENERAL] How to force Postgres to calculate MAX(boolean)

2005-07-07 Thread Christopher Browne
> I try to convert code from other database to Postgres. > > CREATE TABLE test(test BOOLEAN); > SELECT MAX(test) FROM test; > > causes error > > ERROR: function max(boolean) does not exist > HINT: No function matches the given name and argument types. You may need > to add explicit type casts. >

Re: [GENERAL] Transaction Handling in pl/pgsql

2005-07-12 Thread Christopher Browne
> I am trying to get a better understanding of how transactions work in > pl/pgsql functions. I found the following text in the help: > "It is important not to confuse the use of BEGIN/END for grouping statements > in PL/pgSQL with the database commands for transaction control. PL/pgSQL's > BEGIN/E

Re: [GENERAL] Checkpoints are occurring too frequently...

2005-07-12 Thread Christopher Browne
> LOG: checkpoints are occurring too frequently (19 seconds apart) > HINT: Consider increasing the configuration parameter > "checkpoint_segments". > LOG: checkpoints are occurring too frequently (12 seconds apart) > HINT: Consider increasing the configuration parameter > "checkpoint_segments

Re: [GENERAL] RAMFS with Postgres

2005-07-23 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Alex Stapleton): > On 21 Jul 2005, at 17:02, Scott Marlowe wrote: > >> On Thu, 2005-07-21 at 02:43, vinita bansal wrote: >> >>> Hi, >>> >>> My application is database intensive. I am using 4 processes since >>> I have 4 >>> processeors on my box. There are times when all th

Re: [GENERAL] postgresql Secure Mode

2005-08-07 Thread Christopher Browne
> Hi, > > i have a probem,. > > I am trying to configure postgresql in sure way, I have made the > following thing: > > 1. - I have created the certificate and put this in the directory it data > 2. - given him privileges to the user postgresql for the certificate > 3. - in the file postgre

Re: [GENERAL] What's up with EnterpriseDB?

2005-08-11 Thread Christopher Browne
> I saw their announment today and they said they have Oracle compatiblility. > > What exactly does this mean? They don't go into any details. Did > they implement a Oracle compatible proc language or something? I believe you are correct. It's probably safer to say "they have implemented a more

Re: [GENERAL] Postgresql Books: Which one ?

2005-08-15 Thread Christopher Browne
> I hope that you are well. Having read both books would your > recommendation be to go with Korry Douglas' book ? Two copies of the Douglas^2 book came in today at the office... I took a peruse of the chapter that everyone would expect I'd look at first, and was quite impressed. I haven't

Re: [GENERAL] do separate databases have any impact each other?

2005-08-15 Thread Christopher Browne
> While writing installation instructions for my new PostgreSQL > product, I found myself writing the following sentence: "For first > time users, we recommend building the gnova database, since it has > no impact on other databases." > > Is this really true? Of course, my gnova database will take

Re: [GENERAL] cobol storedprocedures

2005-08-17 Thread Christopher Browne
> I've been scanning the postgres website and yours to find out any > information on cobol stored procedures. Is there any plans on > incorporating this in future releases? Not really. The 'preferred' sorts of languages to include for stored procedures tend to be interpreted languages. There is

Re: [GENERAL] Replicating databases

2005-11-03 Thread Christopher Browne
> On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote: >> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote: >> > > It seems kludgey this way, though. What you really need is >> > > multimaster with conflict resolution, because you can depend on your >> > >> > Isn't Slony2

Re: [GENERAL] Replicating databases

2005-11-03 Thread Christopher Browne
> On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote: >> experts there may suggest a better solution. I have seen talk of >> disabling the standard slony triggers to allow this sort of thing but >> whether that is more or less nasty is questionable. > > FWIW, I don't think that's the quest

Re: [GENERAL] Replicating databases

2005-11-04 Thread Christopher Browne
>> But if someone decided to "fork" their own *new* project, perhaps >> starting based on one of the releases, that would an entirely >> interesting idea. > > Wouldn't async multimaster make use of most all of what slony-I > currently has? ISTM that it would make life a lot easier to use one > comb

Re: [GENERAL] Choosing PostgreSQL as the database for our next project

2005-11-15 Thread Christopher Browne
> William Yu wrote: >> Johnny Ljunggren wrote: >> >>> 1. Replication - multimaster >>> I'll try to explain the setup to the best of my ability: >>> Three centers: >>> Main center - database with a backup database >>> Center 1 - database with a backup database >>> Center 2 - database with a backup d

Re: [GENERAL] Rebranding PostgreSQL

2005-11-17 Thread Christopher Browne
> On Wed, Nov 16, 2005 at 02:19:28PM -0500, Vivek Khera wrote: >> On Nov 16, 2005, at 1:09 PM, <[EMAIL PROTECTED]> >> <[EMAIL PROTECTED]> wrote: >> >> >There are a few obstinate anti-open source customers though, that >> >prevent my plan from moving forward. They've bought into whatever >> >hype

Re: [GENERAL] Rebranding PostgreSQL

2005-11-17 Thread Christopher Browne
>> Maybe he is going to call it "Orakle"? :) > > I was thinking he could call it "my-sql"... Call it "Your SQL" :-) -- "cbbrowne","@","gmail.com" http://cbbrowne.com/info/slony.html "...Roxanne falls in love with Christian, a chevalier in Cyrano's regiment who hasn't got the brains God gave an ec

Re: [GENERAL] creating table while slony-I replication is running

2006-09-20 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] wrote: > Hi, > I am trying to find out how to CREATE a table while Slony-I replication is > running (meaning without stopping Slony-I replication adding/creating new > table > into replication) I think you have some extra characters in the script.

Re: [GENERAL] postgresql rising

2006-09-21 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Brad Nicholson) belched out: > 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 about is MS SQL Server, >>

Re: [GENERAL] more anti-postgresql FUD

2006-10-12 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] ("Jim C. Nasby"), an earthling, wrote: > But you can actually write good code that will run on multiple > databases if you're willing to write the tools to allow you to do it. There's an argument out there that we don't actually have relation

Re: [GENERAL] Wordpress & PostgreSQL ...

2006-10-21 Thread Christopher Browne
[EMAIL PROTECTED] ("Joshua D. Drake") wrote: > Marc G. Fournier wrote: >> >> Does anyone know of any work being done to get wordpress ported to >> PostgreSQL? >> My search on the web finds emails from March of this year concerning some >> ppl >> more or less "looking into it", but I can't find

Re: [GENERAL] CUBE, ROLLUP, GROUPING SETS?

2006-10-28 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Nicolas Barbier") would write: > 2006/10/28, Robert Treat <[EMAIL PROTECTED]>: > >> On Tuesday 10 October 2006 15:19, stig erikson wrote: >> >>> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in >>> future PostgreSQL v

Re: [GENERAL] time value '24:00:00'

2006-11-02 Thread Christopher Browne
On 11/1/06, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote: why don't you just use < '00:00:00'::time and avoid the issue? IMHO there shouldn't even be a 24:00:00, because that would imply that there is a 24:00:01 - which there is not. It should go from 23:59 to 00:00 But then, I didn't write the s

Re: [GENERAL] per-row security

2006-11-07 Thread Christopher Browne
[EMAIL PROTECTED] (Andrew Sullivan) wrote: > On Mon, Nov 06, 2006 at 01:40:18PM -0800, Marc Munro wrote: >> You will of course be replicating the underlying tables and not the >> views, so your replication user will have to have full access to the >> unsecured data. This is natural and should not

Re: [GENERAL] Does PostgreSQL support multi-instancing?

2006-11-08 Thread Christopher Browne
After a long battle with technology, "Bill" <[EMAIL PROTECTED]>, an earthling, wrote: > Is is possible to have two different versions of PostgreSQL running on > the same computer at the same time? Certainly. You need separate binaries, separate data directories, separate port configuration. If

Re: [GENERAL] Database Mirroring Solution

2006-11-10 Thread Christopher Browne
[EMAIL PROTECTED] (Gideon) wrote: > Thanks for the quick reply. > > We basicaly need to run a database servers in 2 different > towns. Now there will be update's and selects and both need > to be in sync with each other. Aswell as if / when database in > town 1 goes down ... we need to be able to s

Re: [GENERAL] VACUUM and transactions in different databases

2006-12-06 Thread Christopher Browne
Oops! [EMAIL PROTECTED] (Cornelia Boenigk) was seen spray-painting on a wall: > Hi all > > If I have a running transaction in database1 and try to vacuum > database2 but the dead tuples in database2 cannot be removed. > > INFO: vacuuming "public.dummy1" > INFO: "dummy1": found 0 removable, 14

Re: [GENERAL] Second attempt, roll your own autovacuum

2006-12-19 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Tom Lane) transmitted: > Glen Parker <[EMAIL PROTECTED]> writes: >> I am still trying to roll my own auto vacuum thingy. > > Um, is this purely for hack value? What is it that you find inadequate > about regular autovacuum?

Re: [GENERAL] Autovacuum Improvements

2006-12-23 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Csaba Nagy) belched out: > On Thu, 2006-12-21 at 18:41, Alvaro Herrera wrote: >> > From all the discussion here I think the most benefit would result from >> > a means to assign tables to different categories, and set up separate >> > au

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: > Suggest you download my little application and read the documentation, > you'll see its very different, maybe even interesting. > Maybe they should change that to Postgres DOES HAVE a free multi-master > replication system

Re: [GENERAL] Autovacuum Improvements

2006-12-31 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Alvaro Herrera) wrote: > Christopher Browne wrote: > >> Seems to me that you could get ~80% of the way by having the >> simplest "2 queue" implementation, where tables with size < some >> thre

Re: [GENERAL] Slony across platforms

2007-01-06 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Scott Marlowe) wrote: > On Fri, 2007-01-05 at 15:54, Raymond O'Donnell wrote: >> Hi all, >> >> Would there be any problem with using Slony-I to replicate from a >> Windows server to Linux? Has anyone done this? It otta work... >> Al

Re: [GENERAL] Autovacuum Improvements

2007-01-10 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Csaba Nagy) wrote: > On Mon, 2007-01-08 at 22:29, Chris Browne wrote: > [snip] >> Based on the three policies I've seen, it could make sense to assign >> worker policies: >> >> 1. You have a worker that moves its way through the queue

Re: [GENERAL] PG Email Client

2007-01-29 Thread Christopher Browne
Sim Zacks <[EMAIL PROTECTED]> wrote: > DBMail is an interesting concept, but I think the real advantage would > be if there were a client that could take advantage of the power of a > database backend. > > For example, instead of saving a copy of an email in 1 folder, the > same email could be inde

Re: [GENERAL] Lifecycle of PostgreSQL releases

2007-03-16 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Erik Jones) transmitted: > On Mar 14, 2007, at 6:17 PM, CAJ CAJ wrote: > > > Hello, > > What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to > be released in July, what will be the stat

Re: [GENERAL] Lifecycle of PostgreSQL releases

2007-03-16 Thread Christopher Browne
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Joshua D. Drake") transmitted: >>> There is zero question that 8.2 is faster than 7.4 *but* if 7.4 isn't >>> slow for them... Note, that I meant no reason for him to upgrade 7.4 >>> *right now*. He could wait for 8.3. (I thi

Re: [GENERAL] 8.0.0beta3 vacuum analyze

2004-10-18 Thread Christopher Browne
over all I/O -- let name="cbbrowne" and tld="linuxfinances.info" in String.concat "@" [name;tld];; http://www3.sympatico.ca/cbbrowne/ Fatal Error: Found [MS-Windows] System -> Repartitioning Disk for Linux... -- <[EMAIL PROTECTED]> Christoph

Re: [GENERAL] Slony-I 1.0.4 Released

2004-10-21 Thread Christopher Browne
Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall: > Chris Browne wrote: > > The Slony-I team is proud to present the 1.0.4 release of the most > > advanced replication solution for the most advanced Open Source > > Database in the world. > > > > The release tarball i

Re: [GENERAL] Slony-I 1.0.4 Released

2004-10-22 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, Gaetano Mendola <[EMAIL PROTECTED]> belched out: > Christopher Browne wrote: > > Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall: > > > >>Chris Browne wrote: > >> > The

Re: [GENERAL] 24x7x365 high-volume ops ideas

2004-11-07 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Karim Nassar) wrote: > On Wed, 2004-11-03 at 18:10, Ed L. wrote: >> unfortunately, the requirement is 100% uptime all the time, and any >> downtime at all is a liability. Here are some of the issues: > > Seems like 100% uptime is alw

Re: [GENERAL] When to switch to Postgres 8.0?

2004-11-11 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] wrote: > Quoting Bruno Wolff III <[EMAIL PROTECTED]>: > >> On Thu, Nov 11, 2004 at 14:17:41 -0500, >> [EMAIL PROTECTED] wrote: >> > ... >> > Suppose 8.0 is released in December or January. Is it a sane thing >> > to put 8.0 in a shipping product within the

  1   2   3   4   >