Re: [GENERAL] How to increace nightly backup speed

2006-11-29 Thread Bernhard Weisshuhn
Chris Browne schrieb: > There are other options out there that could conceivably change the > price of compression, such as: > > http://www.lzop.org/ > http://www.quicklz.com/ > > Of course, those are not as well known compression systems, and so are > not as well trusted. Maybe worth looking i

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Bernhard Weisshuhn
Devrim GUNDUZ schrieb: > Hi, > > On Wed, 2006-12-06 at 13:14 +0100, Albe Laurenz wrote: >> I have notified the packager and hope that the problem will be fixed >> soon. > > After thinking about it a bit, I thought it is the only solution to > prepare different RPMs per platform :-( > > Per this

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Bernhard Weisshuhn
Devrim GUNDUZ schrieb: > Hi, > > On Wed, 2006-12-06 at 15:39 +0100, Bernhard Weisshuhn wrote: >> error: unpacking of archive failed on file >> /usr/lib64/libpq.so.4;4576d3af: cpio: MD5 sum mismatch > > Please download the RPM from another mirror, or re-download it. I

[GENERAL] Re: Male/female

2006-12-08 Thread Bernhard Weisshuhn
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa <[EMAIL PROTECTED]> wrote: > Now we just need fast, stable and native replication for " The Girl > That Every Man Secretly Wishes He Was Married To!" I want replication WITH that girl! Any chance for 8.3? bkw --

Re: [GENERAL] Using a 250GB RAID10 server for postgres

2005-12-06 Thread Bernhard Weisshuhn
On Tue, Dec 06, 2005 at 09:41:55AM +, Rory Campbell-Lange <[EMAIL PROTECTED]> wrote: > Is it OK to use logical volume management to run an xfs partition > hosting postgres data? We use just that and it works splendid. It's very nice for adding space and all that. But I must admit th

Re: [GENERAL] Temporal Databases

2006-02-23 Thread Bernhard Weisshuhn
On Thu, Feb 23, 2006 at 03:34:36PM -0300, Rodrigo Sakai <[EMAIL PROTECTED]> wrote: > I'm focus on temporal databases (not temporary), and I want to know if > anyone here is studying this tecnologies too. So, we can exchange > knowlegment. Specifically, anyone who is trying to implement on

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

2006-02-27 Thread Bernhard Weisshuhn
On Mon, Feb 27, 2006 at 09:14:40AM -0800, CG <[EMAIL PROTECTED]> wrote: > I could probably get even better performance out of the table, at the cost of > a > significant increase in table and index size, by chopping up the columns into > smaller chunks. > > "Hello World" would yield > > 'h.e.l.

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

2006-02-27 Thread Bernhard Weisshuhn
On Mon, Feb 27, 2006 at 10:27:20AM -0800, CG <[EMAIL PROTECTED]> wrote: > [...] I'd need to see if the space required for the varchar+btree tables are > comparible, better, or worse than the ltree+gist tables with regards to size. Please test this, I'm guessing (hoping actually) that having bazil

Re: [GENERAL] Some pgbench results

2006-03-23 Thread Bernhard Weisshuhn
Just Someone wrote: 2 10K SCSI disks in RAID1 for OS and WAL (with it's own partiton on ext3), You'll want the WAL on its own spindle. IIRC a separate partition on a shared disc won't give you much benefit. The idea is to keep the disc's head from moving away for other tasks. Or so they say.

Re: [GENERAL] Implementation Suggestions

2006-03-29 Thread Bernhard Weisshuhn
Kenneth Downs wrote: I have been meaning to investigate it because it is the only system I've heard of that makes the same claim that I do, which is to have eliminated entire categories of labor through automation. Have you looked at http://catalyst.perl.org/ lately? IMHO it's "Rails done rig

Re: [GENERAL] "Upcalls" (sort of) from the database

2006-04-06 Thread Bernhard Weisshuhn
Don Y wrote: Hi, I wasn't prepared to ask this question, yet :< but all the talk of stored procedures, etc. suggests this might be a good time to venture forth... Humor me: assume I have done the analysis and *know* this to be correct for my situation :> I want to embed a good deal of the i

Re: [GENERAL] Majordomo drops multi-line Subject:

2006-08-23 Thread Bernhard Weisshuhn
Guido Neitzer wrote: So they don't contain line feeds or carriage returns and so the can't be multi-line. If a mail client sends multi line subjects it does something against the RFC and I assume with that, it does something wrong. This is the theory in RFC 2822 as far as I understand it.

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-14 Thread Bernhard Weisshuhn
Arturo Perez wrote: Any response to this: http://www.internetnews.com/dev-news/article.php/3631831 Oh please! Can we skip this one? Maybe on the advocacy groups, not on [GENERAL], pleze! thanks, bkw ---(end of broadcast)--- TIP 6: explain a

Re: [GENERAL] Is it possible to have multiple names for a column?

2006-09-14 Thread Bernhard Weisshuhn
On Thu, Sep 14, 2006 at 12:18:05PM -0700, [EMAIL PROTECTED] wrote: > We have a need to rename some columns, but since we can't update both > the database and the programs instantly, we'd like to temporarily > assign both names to the same column while the updates are in > progress. Something like

Re: [GENERAL] Migration

2006-09-15 Thread Bernhard Weisshuhn
On Fri, Sep 15, 2006 at 12:33:37PM -0400, Daniel Corbe <[EMAIL PROTECTED]> wrote: > I heard from a bunch of PHP guys that Postgres is total crap. Can > anyone recommend a guide for migrating to MySQL? Hello slashdot! ---(end of broadcast)--- TIP

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-18 Thread Bernhard Weisshuhn
Scott Ribe schrieb: I've never used a hammer to put in a screw. So I guess you're one of those ivory-tower theory-purist academic types, at least when it comes to home repairs. As a more practical person myself, let me just say that sometimes a 3lb hammer is exactly the right tool to get a scre

Re: [GENERAL] cyclical redundancy checksum algorithm(s)?

2006-09-28 Thread Bernhard Weisshuhn
Joachim Wieland schrieb: On Thu, Sep 28, 2006 at 07:09:43AM +0100, John Sidney-Woollett wrote: Why not use an update trigger on the affected tables to record a lastupdated timestamp value when the record is changed. Surely this is simpler thanks computing some kind of row hash? It depends o

Re: [GENERAL] Functional Index

2006-11-22 Thread Bernhard Weisshuhn
On Wed, Nov 22, 2006 at 11:24:33AM -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Wed, 22 Nov 2006, Alexander Presber wrote: > >> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text) > >> using varchar_ops); > > > IIRC, unless you're