On 7 Jul 2003 at 12:59, Mattias Kregert wrote:
> First of all, disable FSYNC... that will speed things up a lot!
That shouldn't have been done so casually. Though can cause performance boost
and it degrades reliability of data as it can cause data corruption in case of
power/disk failure.
Bye
In the case of disk failure, the files will probably be damaged anyway and then i'll
have to install new hardware or format+check badblocks and then restore from the
backup. I can't see how fsync would help in the case of disk crash. Without reliable
raid or something i think this would be a cat
On Mon, Jul 07, 2003 at 01:30:09PM +0200, Mattias Kregert wrote:
> In the case of disk failure, the files will probably be damaged anyway and
> then i'll have to install new hardware or format+check badblocks and then
> restore from the backup. I can't see how fsync would help in the case of
> dis
On Sunday 06 July 2003 08:44, [EMAIL PROTECTED] wrote:
> >Migrating to PostGreSql, i need to know how capable pgsql Functions
> >are , Vis a Vis SQLServer. can pgsql functions replace all
> >functionality provided by Stored Procedures of MSSqlServer
Dear Adivi,
You may also have a loo
"Mattias Kregert" <[EMAIL PROTECTED]> writes:
> [ misguided analysis ]
> Journalling FS will fix the FS problems, so the files are ok.
> PG journal will fix the PG problems so the tables will be ok.
Only if the journal is all down to disk before the crash.
The fundamental problem with fsync off
Tom Lane wrote:
> "Mattias Kregert" <[EMAIL PROTECTED]> writes:
> > [ misguided analysis ]
>
> > Journalling FS will fix the FS problems, so the files are ok.
> > PG journal will fix the PG problems so the tables will be ok.
>
> Only if the journal is all down to disk before the crash.
>
> The f
Hello list,
I'm unable to load http://gborg.postgresql.org/. The
address is pingable, but the website won't load. Anybody know what
happened?
I also can't reach the mailing list archives, but
they have been down for a while...
Server admins: please let me know if you are
interested
> If I turn fsync on and then pull the power cord while a
> number of clients are doing lots of inserts/updates and stuff,
> will the fsync then guarantee that no data will be lost or
> corrupted?
You are surely kidding, aren't you ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291
Should already be fixed ... tested from my location ... runaway postmaster
process doign a SELECT on the gborg database ... been running since Friday
*roll eyes* killed it off and things drop'd back down to normal ...
On Mon, 7 Jul 2003, Aaron Dummer wrote:
> Hello list,
>
> I'm unable to load h
> > If I turn fsync on and then pull the power cord while a
> > number of clients are doing lots of inserts/updates and stuff,
> > will the fsync then guarantee that no data will be lost or
> > corrupted?
> You are surely kidding, aren't you ?
>
> Karsten
No. No kidding.
Just to clarify, what I m
If disabling FSYNC means that some my transaction log records will
reside in
some OS memory cache instead of been written on a disk after transaction
is commited,
I do now want to disable that.
-Original Message-
From: Mattias Kregert [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 200
Do I save memory using a cursor from a SPI-connected procedure ?
I'm working on a table containing geometric objects and I'd like
to keep a geometry in memory just for the time it is needed, and
one at time, otherwise my machine is in permanent swapping.
--strk;
---(end o
On Monday 07 Jul 2003 4:11 pm, Mattias Kregert wrote:
> > > If I turn fsync on and then pull the power cord while a
> > > number of clients are doing lots of inserts/updates and stuff,
> > > will the fsync then guarantee that no data will be lost or
> > > corrupted?
> >
> > You are surely kidding,
I define an SQL function:
CREATE FUNCTION foo(timestamptz) AS '
...' LANGUAGE 'SQL';
Does the plan for the body get built at creation or execution time? I could
have sworn it was execution time, but timings on one function suggest
creation?
For those new to functions, plpgsql always prepares i
The following is the HTML of the www.postgresql.org homepage:
--snip--
http://www.postgresql.org/";>
--snip--
Basically, an empty page that is constantly reloaded.
Pretty FUBAR.
cwl
---(end of broadcast)---
TIP 7: don't forget to increase your f
NM, it appears to be fixed now.
cwl
> -Original Message-
> From: Clay Luther
> Sent: Monday, July 07, 2003 3:59 PM
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTECTED]'
> Subject: www.postgresql.org FUBAR
>
>
> The following is the HTML of the www.postgresql.org homepage:
>
> --snip--
>
Just because all reported commits go in doesn't mean there won't be any
data loss.
If you pull the power cord, the DB should be in a consistent state barring
hardware and other issues. However there can be data loss, because the
clients might have been inserting data which may not be able to be
I believe that its more efficient to group INSERT's together and COMMIT
them in groups.
However, I am automatically entering a lot of data and some of its is
not unique. How can I reap the benefits of using BEGIN and COMMIT
without the whole block of transactions failing if one is duplicated.
Than
On Sunday 06 July 2003 12:39 pm, CSN wrote:
> Is it possible to have the datetime printed along with
> messages in PG's logs?
See postgresql.conf and use syslog or set:
log_timestamp = true
Cheers,
Steve
---(end of broadcast)---
TIP 3: if posting/
Thanks Tom. That is good info.
(gnashing of teeth in background)
Clay
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 6:46 PM
> To: Clay Luther
> Cc: Doug McNaught; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Using C++ With SPI?
>
>
>
Hi.
I have a doubt:
If I make:
update stockline set status=3 where id IN (select id from lap_mpdetail_view where
lap=3976)
postgres makes an Seq Scan on stockline.
when stockline is big, it is better to make an select id from
lap_mpdetail_view where lap=3976) and progr
On Mon, 7 Jul 2003, Dmitry Tkach wrote:
> I understand that with the generic approach to operators in postgres it
> is, probably, not very feasible to try and teach _bt_first () to handle
> this situation automatically (it would need to know how to get
> next/previous value for every indexable ty
If you make an opclass that orders in the reverse order you can use that
opclass in creating the index (which effectively can give you an index
like x, y desc by using the new opclass on y). There was some talk
recently about whether we should provide such opclasses as builtins or
contrib items.
Pedro Alves wrote:
> Hi.
>
>
> I have a doubt:
>
> If I make:
>
> update stockline set status=3 where id IN (select id from lap_mpdetail_view where
> lap=3976)
>
> postgres makes an Seq Scan on stockline.
>
> when stockline is big, it is better to make an select id fro
I am not sure if this is really a bug, but it certainly looks like one
to me...
I have a table that looks something like this:
create table huge_table
(
int x,
int y
);
create index huge_table_idx on huge_table (x,y);
It contains about 80 million rows...
I am trying to get those rows that
Do you realize your entire website is hosed? NONE of the download sites
will resolve, and NONE of the mirror sites work (or will resolve).
What is up?
Dan
---(end of broadcast)---
TIP 8: explain analyze is your friend
I still having that same error on my simple query:
Tables has been rebuild, reindexed, and DB has been moved to another
computer,
worked for a while, and now aging same story.
We run PG 7.3
I repeat query:
SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
ON p.docid
On Fri, Jul 04, 2003 at 02:22:39PM -0700, Maksim Likharev wrote:
> Ok, what I see here tells me that text is slower then fixed len varchar,
> due to stored in separate table ( but how else you can store long fields
> ).
No, sorry, I think I was unclear. varchar() is the same thing as
text(); they
28 matches
Mail list logo
