Hello,
Investigating many options of pgsql replication softwares. Theres are two
thats come up in discussions earliers today which are Mamoth Replicator and
Slony-I. Is there anybodies who has reviewed them and or compared them in
corporate environment? My companys is moving from Microsoft Seque
On Mon, 2004-08-09 at 19:29, lec wrote:
> Scott Marlowe wrote:
> > >
> > Does that RAID controller have NON battery backed cache?
> >
> >
> >
> I'm not sure.
Find out. If it does, it's an accident looking for a place to happen.
Unless it's set to write thru not write back. If you're
Tom Lane wrote:
Marco Colombo <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
However this would seem to imply disk drive misfeasance above and beyond
your motherboard problem.
Well, no. How about this theory:
1) everythi
Scott Marlowe wrote:
On Mon, 2004-08-09 at 09:07, lec wrote:
Scott Marlowe wrote:
On Sun, 2004-08-08 at 21:26, Alvaro Herrera Munoz wrote:
On Sun, Aug 08, 2004 at 08:36:36PM -0600, Scott Marlowe wrote:
On Su
Hi,
I'm trying to list views, eliminating internal ones from the output.
Using 7.2, I found this simple statement :
SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
It works fine, ignoring 23 pg_* tables. And I get my actual views returned.
But, with 7.4, I get many (about 30) more system
After almost 9 months of development, the PostgreSQL Global Development
Group is proud to announce that development on PostgreSQL 8.0.0 has now
finished, and is ready for some serious testing.
For those wondering about the 8.0.0 designation on this release, there
have been several *very* large
Hi,
Is there any way to prevent implicit joins in 7.3.x?
I tried to put 'ENABLE_IMPLICIT_FROM = false' in postgresql.conf but it did
not work.
Thanks,
Patrick
_
Powerful Parental Controls Let your child discover the best the Internet
"Kevin Bartz" <[EMAIL PROTECTED]> writes:
> Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN
> says:
> test=#
> QUERY PLAN
> --
> HashAggregate (cos
CSN wrote:
> Looking forward to PostgreSQL 8.0 :). Is there an
> "official" feature list? What I've dug up so far:
>
> nested transactions
> transaction checkpoints
> point in time recovery
> tablespaces
> native Windows port
> plpgsql exceptions
> integrated pg_autovacuum
> ARC buffer code?
Plea
On Mon, Aug 09, 2004 at 11:33:04AM -0700, Kevin Bartz wrote:
> Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN
> says:
>
> test=#
> QUERY PLAN
> --
>
Marco Colombo <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> However this would seem to imply disk drive misfeasance above and beyond
>> your motherboard problem.
> Well, no. How about this theory:
> 1) everything is ok:
> the backend executes write()/fsync() for transactions 1-5
> 2) har
On Mon, 2004-08-09 at 09:07, lec wrote:
> Scott Marlowe wrote:
> > On Sun, 2004-08-08 at 21:26, Alvaro Herrera Munoz wrote:
> >
> > > On Sun, Aug 08, 2004 at 08:36:36PM -0600, Scott Marlowe wrote:
> > >
> > > > On Sun, 2004-08-08 at 19:43, lec wrote:
> > > >
> > > > > If I commit th
Hi Lincoln! Thanks for your reply. On the problematic SELECT INTO, EXPLAIN
says:
test=#
QUERY PLAN
--
HashAggregate (cost=42.50..42.50 rows=1000 width=356)
-> Seq Scan on
-Original Message-
From: Kevin Bartz [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 10:37 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [GENERAL] Out of swap space & memory
Thanks for your reply, Mike! Theoretically, I should need only six of the
columns, but as a means of verifying
Well, I didn't set sort_mem, which (does it?) means it defaults to 512.
There are 2 gigs of RAM on the box and one gig of swap space. Should I have
set it to some different value? Thanks for your reply.
Kevin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf O
Hi,
Is there any way to prevent implicit join in version 7.3.x?
I tried to put 'ENABLE_IMPLICIT_FROM = false' in postgresql.conf but it did
not work.
Thanks a lot,
Patrick
_
Take charge with a pop-up guard built on patented Microsoft
On Mon, 9 Aug 2004, Dino Nardini wrote:
> Hello there,
>
> Is there no way to force the JDBC driver to simply pass the data as
> SQL-ASCII, or ignore the encoding altogether?
No because Java itself needs it correctly encoded the JDBC driver needs to
make that happen.
> I tried to dump and r
I have tblhud74b that has a foreign key to tblhudunits with Restrict
Updates. I have a function that DELETEs corresponding records before
doing an UPDATE right after the DELETE statement and receive the
following error:
ERROR: update or delete on "tblhudunits" violates foreign key
constraint "tbl
Tom Lane wrote:
I'm puzzled too. I don't suppose you have the postmaster log from when
it was trying to recover from the crash? Or even better, copies of the
WAL files?
I never knew where the log files are :(
---(end of broadcast)---
TIP 3: if po
19 matches
Mail list logo
